[1]
SELECT `username`,`groupname`,`expiration` FROM `users` WHERE `sub_dealer_id` = 'sky' AND `is_expired` = 'N' AND `expiration` != '2000-02-02'
[2]
INSERT INTO `managers_services_rate` (manager_username, groupname, rate)
SELECT username, groupname, rate FROM `reseller_service_rate`
[3]
SELECT `username`,`groupname`,`expiration` FROM `users` WHERE `id_creadted_by` = 'galaxynetwork' AND `is_expired` = 'N' AND `expiration` != '2000-02-02'
[4]
SELECT `full_name`,`username`,`password`,`password`,`cnic`,`phone1`,`phone2`,`email`,`address` FROM `users` WHERE `sub_dealer_id` = 'zubairnet'
[5]
SELECT `full_name`,`username`,`phone1`,`phone2`,`cnic`,`sub_dealer_id`,`dealer_id`,`address` FROM `users` WHERE `is_expired` = 'N' AND `expiration` != '2000-02-02' AND `phone1` != '0323' AND `cnic` != '' AND `cnic` != '00000-0000000-0' AND `phone1` != '0' AND `cnic` != '0' AND `phone1` != '0000-0000000' AND `phone1` != '12345678910' AND `phone1` != '00000' AND `phone1` != '000000000' AND `phone1` != '0000000000' AND `phone1` != '009000090909' AND `cnic` != '11111-2222222-9'
[6]
SELECT a.user_username, a.user_service_groupname, a.user_charged_date,
b.username, b.full_name, b.phone1, b.phone2, b.cnic, b.address FROM `users_activation_history_archive` a, `users` b WHERE a.user_username = b.username
[7]
SELECT a.user_username, a.user_service_groupname, a.user_charged_date,
b.username, b.full_name, b.phone1, b.phone2, b.cnic, b.address, b.sub_dealer_id, b.dealer_id FROM `users_activation_history_archive` a, `users` b WHERE a.user_username = b.username AND a.user_charged_date BETWEEN '2019-05-01 00:00:00' AND '2019-05-31 23:59:59'
[8]
SELECT a.user_username, a.user_service_groupname, a.user_charged_date,
b.username, b.full_name, b.phone1, b.phone2, b.cnic, b.address, b.sub_dealer_id, b.dealer_id FROM `users_activation_history_archive` a, `users` b WHERE a.user_username = b.username AND a.user_charged_date BETWEEN '2019-05-01' AND '2019-05-31'
[9]
SELECT `username`,`full_name`, `phone1`,`phone2`,`cnic`,`address`,`sub_dealer_id`,`dealer_id` FROM `users` WHERE `is_expired` = 'N' AND `phone1` != '' AND `cnic` != '' AND `phone1` != '0' AND `cnic` != '00000-0000000-0' AND `cnic` != '123456789101112' AND `phone1` != '03451234567' AND `phone1` != '0323' AND `phone1` != '0345-1234567' AND `phone1` != '12345678910' AND `phone1` != '0000-0000000' AND `phone1` != '0000' AND `phone1` != '123456789' AND `phone1` != '033333333333' AND phone1 != '000000000000'
[10]
SELECT COUNT(`username`) AS Radcheck_Count ,`username` FROM `radcheck` GROUP BY `username` ORDER BY `Radcheck_Count` DESC
[11]
UPDATE `users` SET `dealer_id` = 'pmsa' , `id_creadted_by` = 'pmsa' WHERE `sub_dealer_id` = 'agrnet'
[12]
UPDATE `users_charged_history` SET `activationTimeStamp` = NULL WHERE `activationTimeStamp` = '2019-03-14 19:38:44';
[13]
update users_charged_history_2
set user_charged_date = activationTimeStamp
where activationTimeStamp != '2019-03-14 21:35:08';
[14]
UPDATE `users_charged_history` SET `activationTimeStamp` = NULL WHERE `activationTimeStamp` = '2019-03-08 18:35:50';
[15]
UPDATE users_charged_history
SET user_charged_date = activationTimeStamp
WHERE activationTimeStamp IS NOT NULL
[16]
SELECT `username`,`full_name`,`email`,`phone1`,`cnic`,`groupname`,`sub_dealer_id`,`dealer_id` FROM users WHERE `cnic` != '' AND expiration != '2000-02-02' AND is_expired = 'N';
[17]
SELECT `username`,`full_name`,`phone1`,`phone2`,`cnic`,`groupname`,`sub_dealer_id`,`dealer_id`,`address` FROM users WHERE `phone1` != '' AND `cnic` != '' AND expiration != '2000-02-02' AND is_expired = 'N' AND `phone1` != '0323' AND `phone1` != '03451234567' AND `phone1` != '12345678910' AND `phone1` != '0345-1234567' AND `phone1` != '0000000000' AND `phone1` != '03000000000' AND `phone1` != '009000090909' AND phone1 != '033333333333' AND `phone1` != '033333333333' AND `phone1` != '0000-0000000' AND `phone1` != '0000' AND `phone1` != '131212311231' AND `phone1` != '123123156456' AND `phone1` != '03320000001' AND `phone1` != '03121111111' AND `phone1` != '03320000000' AND phone1 != '12345678' AND `phone1` != '123456789' AND `phone1` != '0' AND `phone1` != '000000000000' AND `phone1` != '1' AND `phone1` != '121' AND `phone1` != '0000000' AND `phone1` != '123456789000' AND `phone1` != '0300-0000000' AND `cnic` != '421010000000' AND `cnic` != '478978978978789' AND `cnic` != 'Nic' AND cnic != '42101' AND `cnic` != 'nic' AND `cnic` != '12345' AND `cnic` != '5' AND cnic != '1' AND cnic != '2' AND cnic != '1234567890000' AND cnic != '1122331' AND `cnic` != '121' AND `cnic` != '12345678' AND `cnic` != '11111' AND `cnic` != '1234512345671' AND `cnic` != '0' AND `cnic` != '11111-1111111' AND `cnic` != '2554898689533' AND `cnic` != '12345-1234567' AND `cnic` != '12345-6789999-0' AND `cnic` != '1234567899990' AND `cnic` != '12334-34-34-543' AND `cnic` != '12345-1234567-1' AND `cnic` != '11111-2637383-1' AND `cnic` != '11111-2222222-9' AND `cnic` != '12345-1234567-8' AND `cnic` != '111111111111' AND `cnic` != '123456789000000' AND `cnic` != '123456789101112' AND `cnic` != '00000-0000000-0' AND `cnic` != '6110117344125' AND `dealer_id` != 'ccrown3' AND `dealer_id` != 'dani' AND `reseller_id` != 'netconnect';
[18]
SELECT `is_days_expired` FROM `users` WHERE `is_days_expired` = 'Y'
[19]
UPDATE `users` SET `is_expired` = 'Y' WHERE `is_days_expired` = 'Y'
[20]
INSERT IGNORE INTO `all_users_id` (`user_id`, `index_id`, `user_role_code`) SELECT `username`, `id`, `user_role_code` FROM `free_ids`
[21]
INSERT INTO `all_users_id` (`user_id`, `index_id`, `user_role_code`) SELECT DISTINCT Id, Name FROM Table1
[22]
SELECT a.user_username, a.user_service_groupname, a.user_charged_date, b.sub_dealer_id, b.dealer_id, b.full_name, b.phone1, b.phone2, b.cnic, b.address FROM users_activation_history_archive a,
users b WHERE a.user_username = b.username AND MONTHNAME(a.user_charged_date) = 'JUNE' AND YEAR(a.user_charged_date) = '2019';
[23]
UPDATE `users` SET `sub_dealer_id` = 'kcs', `sub_dealer_i_id` = '272', `dealer_i_id` = '180', `reseller_i_id` = '83', `created_by` = '272', `id_creadted_by` = 'kcs' WHERE `sub_dealer_id` = 'usnet';
[24]
UPDATE `users` SET `sub_dealer_id` = 'usnet', `sub_dealer_i_id` = '208', `dealer_i_id` = '180', `reseller_i_id` = '83', `created_by` = '208', `id_creadted_by` = 'usnet' WHERE `sub_dealer_id` = 'kcs';
[25]
UPDATE `users` SET `sub_dealer_id` = 'kcs', `sub_dealer_i_id` = '272', `dealer_i_id` = '180', `reseller_i_id` = '83', `created_by` = '272', `id_creadted_by` = 'kcs' WHERE `sub_dealer_id` = 'usnet' AND `username` LIKE '%gnet%';
[26]
SELECT u.username, r.username, r.groupname, r.priority FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '200' AND r.username = u.username
[27]
SELECT u.username, r.attribute, r.op, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '202' AND r.username = u.username
[28]
SELECT u.username, STR_TO_DATE(TIME_FORMAT( r.value, '%Y-%m-%d'),'%Y-%m-%d') AS formatted_date FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '202' AND r.username = u.username AND r.`attribute` = 'Expiration'
[29]
SELECT u.username, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '202' AND r.username = u.username AND r.`attribute` = 'Expiration'
[30]
SELECT u.username, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '200' AND r.username = u.username AND r.`attribute` = 'Expiration'
[31]
INSERT IGNORE INTO `customer_usernames` (`username`) SELECT `username` FROM `users`
[32]
UPDATE `users` SET `sub_dealer_id` = 'clicknet', `id_creadted_by` = 'clicknet' WHERE `dealer_id` = 'idea';
[33]
SELECT `user_username`,`user_service_groupname`,`dealer_rate`,`dealer_wallet`,`sub_dealer_rate`,`sub_dealer_wallet`,`user_charged_date` FROM `users_charged_history` WHERE `sub_dealer_i_id` = '92' AND MONTHNAME(`user_charged_date`) = 'August' AND YEAR(`user_charged_date`) = '2019';
[34]
SELECT a.user_username AS Customer_Username,a.user_service_groupname AS Service_Plan,a.dealer_rate,a.dealer_wallet,a.sub_dealer_rate AS Sub_Dealer_Rate_Wrong,a.sub_dealer_wallet,a.user_charged_date, b.rate AS Sub_Dealer_Rate_Actual FROM users_charged_history a, sub_dealer_service_rate b WHERE b.groupname = a.user_service_groupname AND b.username = 'spxnet' AND a.sub_dealer_i_id = '92' AND MONTHNAME(a.user_charged_date) = 'August' AND YEAR(a.user_charged_date) = '2019';
[35]
SELECT a.user_username AS Customer_Username,a.user_service_groupname AS Service_Plan,a.sub_dealer_rate AS Sub_Dealer_Rate_Wrong,a.sub_dealer_wallet,a.user_charged_date, b.rate AS Sub_Dealer_Rate_Actual FROM users_charged_history a, sub_dealer_service_rate b WHERE b.groupname = a.user_service_groupname AND b.username = 'spxnet' AND a.sub_dealer_i_id = '92' AND MONTHNAME(a.user_charged_date) = 'August' AND YEAR(a.user_charged_date) = '2019';
[36]
UPDATE `users` SET `sub_dealer_id` = 'hsn' WHERE `id_creadted_by` = 'hsn';
[37]
SELECT u.username, r.groupname, r.priority FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '156' AND r.username = u.username;
[38]
SELECT `username` FROM `users` WHERE `id_creadted_by` = 'sajjadcity';
SELECT `username` FROM `users` WHERE `id_creadted_by` = 'ikramdr';
SELECT `username` FROM `users` WHERE `id_creadted_by` = 'imran';
[39]
SELECT u.username, r.groupname, r.priority FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '148' AND r.username = u.username;
[40]
SELECT u.username, r.attribute, r.op, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '202' AND r.username = u.username
[41]
INSERT IGNORE INTO `customer_usernames` (`username`, `index_id`) SELECT `username`, `id` FROM `users` WHERE users.dealer_id = 'imran';
[42]
INSERT IGNORE INTO `customer_usernames` (`username`, `index_id`) SELECT `username`, `id` FROM `users`;
[43]
UPDATE customer_usernames
INNER JOIN users ON (customer_usernames.username = users.username)
SET customer_usernames.index_id = users.id;
[44]
UPDATE manager_usernames
INNER JOIN web_managers ON (manager_usernames.username = web_managers.username)
SET manager_usernames.index_id = web_managers.id;
[45]
SELECT u.username, r.attribute, r.op, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '202' AND r.username = u.username
[46]
SELECT u.username FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '156' AND r.username = u.username;
SELECT u.username FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '148' AND r.username = u.username;
SELECT u.username FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '150' AND r.username = u.username;
[47]
SELECT u.username, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '156' AND r.username = u.username AND r.`attribute` = 'Expiration';
SELECT u.username, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '148' AND r.username = u.username AND r.`attribute` = 'Expiration';
SELECT u.username, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '150' AND r.username = u.username AND r.`attribute` = 'Expiration';
[48]
UPDATE `users` SET `expiration` = '2000-02-02' WHERE `account_status` = '2';
[49]
UPDATE `users` SET `sub_dealer_id` = 'easylink' WHERE `id_creadted_by` = 'easylink';
[50]
UPDATE `users` SET `sub_dealer_id` = 'kcs' WHERE `username` LIKE '%gs%' AND `id_creadted_by` = 'usnet';
[51]
UPDATE `users` SET `id_creadted_by` = 'kcs' WHERE `sub_dealer_id` = 'kcs';
[52]
SELECT r.* FROM `users` u, `radcheck` r WHERE u.dealer_id = 'nadeem' AND r.username = u.username;
[53]
SELECT r.username FROM `users` u, `radcheck` r WHERE u.dealer_id = 'nadeem' AND r.username = u.username GROUP BY r.username Having COUNT(r.username) > 3
[54]
SELECT r.username FROM `users` u, `radcheck` r WHERE r.username = u.username GROUP BY r.username Having COUNT(r.username) > 3
[55]
SELECT r.username FROM `users` u, `radcheck` r WHERE r.username = u.username GROUP BY r.username Having COUNT(r.username) > 3
[56]
SELECT a.user_username, a.user_service_groupname, a.user_charged_date,
b.username, b.full_name, b.phone1, b.phone2, b.cnic, b.address, b.sub_dealer_id, b.dealer_id FROM `users_activation_history_archive` a, `users` b WHERE a.user_username = b.username AND a.user_charged_date BETWEEN '2019-07-01' AND '2019-07-31';
[57]
SELECT `full_name`,`username`,`password`,`password`,`cnic`,`phone1`,`phone2`,`email`,`address` FROM `users` WHERE `id_creadted_by` = 'asifnetwork';
[58]
SELECT `full_name`,`username`,`password`,`password`,`cnic`,`phone1`,`phone2`,`email`,`address` FROM `users` WHERE `id_creadted_by` = 'yasirpittal';
[59]
SELECT `username`,`groupname`,`expiration` FROM `users` WHERE `id_creadted_by` = 'nati';
[60]
SELECT `username`,`groupname`,`expiration` FROM `users` WHERE `sub_dealer_id` = 'sky' AND `is_expired` = 'N' AND `expiration` != '2000-02-02'
[2]
INSERT INTO `managers_services_rate` (manager_username, groupname, rate)
SELECT username, groupname, rate FROM `reseller_service_rate`
[3]
SELECT `username`,`groupname`,`expiration` FROM `users` WHERE `id_creadted_by` = 'galaxynetwork' AND `is_expired` = 'N' AND `expiration` != '2000-02-02'
[4]
SELECT `full_name`,`username`,`password`,`password`,`cnic`,`phone1`,`phone2`,`email`,`address` FROM `users` WHERE `sub_dealer_id` = 'zubairnet'
[5]
SELECT `full_name`,`username`,`phone1`,`phone2`,`cnic`,`sub_dealer_id`,`dealer_id`,`address` FROM `users` WHERE `is_expired` = 'N' AND `expiration` != '2000-02-02' AND `phone1` != '0323' AND `cnic` != '' AND `cnic` != '00000-0000000-0' AND `phone1` != '0' AND `cnic` != '0' AND `phone1` != '0000-0000000' AND `phone1` != '12345678910' AND `phone1` != '00000' AND `phone1` != '000000000' AND `phone1` != '0000000000' AND `phone1` != '009000090909' AND `cnic` != '11111-2222222-9'
[6]
SELECT a.user_username, a.user_service_groupname, a.user_charged_date,
b.username, b.full_name, b.phone1, b.phone2, b.cnic, b.address FROM `users_activation_history_archive` a, `users` b WHERE a.user_username = b.username
[7]
SELECT a.user_username, a.user_service_groupname, a.user_charged_date,
b.username, b.full_name, b.phone1, b.phone2, b.cnic, b.address, b.sub_dealer_id, b.dealer_id FROM `users_activation_history_archive` a, `users` b WHERE a.user_username = b.username AND a.user_charged_date BETWEEN '2019-05-01 00:00:00' AND '2019-05-31 23:59:59'
[8]
SELECT a.user_username, a.user_service_groupname, a.user_charged_date,
b.username, b.full_name, b.phone1, b.phone2, b.cnic, b.address, b.sub_dealer_id, b.dealer_id FROM `users_activation_history_archive` a, `users` b WHERE a.user_username = b.username AND a.user_charged_date BETWEEN '2019-05-01' AND '2019-05-31'
[9]
SELECT `username`,`full_name`, `phone1`,`phone2`,`cnic`,`address`,`sub_dealer_id`,`dealer_id` FROM `users` WHERE `is_expired` = 'N' AND `phone1` != '' AND `cnic` != '' AND `phone1` != '0' AND `cnic` != '00000-0000000-0' AND `cnic` != '123456789101112' AND `phone1` != '03451234567' AND `phone1` != '0323' AND `phone1` != '0345-1234567' AND `phone1` != '12345678910' AND `phone1` != '0000-0000000' AND `phone1` != '0000' AND `phone1` != '123456789' AND `phone1` != '033333333333' AND phone1 != '000000000000'
[10]
SELECT COUNT(`username`) AS Radcheck_Count ,`username` FROM `radcheck` GROUP BY `username` ORDER BY `Radcheck_Count` DESC
[11]
UPDATE `users` SET `dealer_id` = 'pmsa' , `id_creadted_by` = 'pmsa' WHERE `sub_dealer_id` = 'agrnet'
[12]
UPDATE `users_charged_history` SET `activationTimeStamp` = NULL WHERE `activationTimeStamp` = '2019-03-14 19:38:44';
[13]
update users_charged_history_2
set user_charged_date = activationTimeStamp
where activationTimeStamp != '2019-03-14 21:35:08';
[14]
UPDATE `users_charged_history` SET `activationTimeStamp` = NULL WHERE `activationTimeStamp` = '2019-03-08 18:35:50';
[15]
UPDATE users_charged_history
SET user_charged_date = activationTimeStamp
WHERE activationTimeStamp IS NOT NULL
[16]
SELECT `username`,`full_name`,`email`,`phone1`,`cnic`,`groupname`,`sub_dealer_id`,`dealer_id` FROM users WHERE `cnic` != '' AND expiration != '2000-02-02' AND is_expired = 'N';
[17]
SELECT `username`,`full_name`,`phone1`,`phone2`,`cnic`,`groupname`,`sub_dealer_id`,`dealer_id`,`address` FROM users WHERE `phone1` != '' AND `cnic` != '' AND expiration != '2000-02-02' AND is_expired = 'N' AND `phone1` != '0323' AND `phone1` != '03451234567' AND `phone1` != '12345678910' AND `phone1` != '0345-1234567' AND `phone1` != '0000000000' AND `phone1` != '03000000000' AND `phone1` != '009000090909' AND phone1 != '033333333333' AND `phone1` != '033333333333' AND `phone1` != '0000-0000000' AND `phone1` != '0000' AND `phone1` != '131212311231' AND `phone1` != '123123156456' AND `phone1` != '03320000001' AND `phone1` != '03121111111' AND `phone1` != '03320000000' AND phone1 != '12345678' AND `phone1` != '123456789' AND `phone1` != '0' AND `phone1` != '000000000000' AND `phone1` != '1' AND `phone1` != '121' AND `phone1` != '0000000' AND `phone1` != '123456789000' AND `phone1` != '0300-0000000' AND `cnic` != '421010000000' AND `cnic` != '478978978978789' AND `cnic` != 'Nic' AND cnic != '42101' AND `cnic` != 'nic' AND `cnic` != '12345' AND `cnic` != '5' AND cnic != '1' AND cnic != '2' AND cnic != '1234567890000' AND cnic != '1122331' AND `cnic` != '121' AND `cnic` != '12345678' AND `cnic` != '11111' AND `cnic` != '1234512345671' AND `cnic` != '0' AND `cnic` != '11111-1111111' AND `cnic` != '2554898689533' AND `cnic` != '12345-1234567' AND `cnic` != '12345-6789999-0' AND `cnic` != '1234567899990' AND `cnic` != '12334-34-34-543' AND `cnic` != '12345-1234567-1' AND `cnic` != '11111-2637383-1' AND `cnic` != '11111-2222222-9' AND `cnic` != '12345-1234567-8' AND `cnic` != '111111111111' AND `cnic` != '123456789000000' AND `cnic` != '123456789101112' AND `cnic` != '00000-0000000-0' AND `cnic` != '6110117344125' AND `dealer_id` != 'ccrown3' AND `dealer_id` != 'dani' AND `reseller_id` != 'netconnect';
[18]
SELECT `is_days_expired` FROM `users` WHERE `is_days_expired` = 'Y'
[19]
UPDATE `users` SET `is_expired` = 'Y' WHERE `is_days_expired` = 'Y'
[20]
INSERT IGNORE INTO `all_users_id` (`user_id`, `index_id`, `user_role_code`) SELECT `username`, `id`, `user_role_code` FROM `free_ids`
[21]
INSERT INTO `all_users_id` (`user_id`, `index_id`, `user_role_code`) SELECT DISTINCT Id, Name FROM Table1
[22]
SELECT a.user_username, a.user_service_groupname, a.user_charged_date, b.sub_dealer_id, b.dealer_id, b.full_name, b.phone1, b.phone2, b.cnic, b.address FROM users_activation_history_archive a,
users b WHERE a.user_username = b.username AND MONTHNAME(a.user_charged_date) = 'JUNE' AND YEAR(a.user_charged_date) = '2019';
[23]
UPDATE `users` SET `sub_dealer_id` = 'kcs', `sub_dealer_i_id` = '272', `dealer_i_id` = '180', `reseller_i_id` = '83', `created_by` = '272', `id_creadted_by` = 'kcs' WHERE `sub_dealer_id` = 'usnet';
[24]
UPDATE `users` SET `sub_dealer_id` = 'usnet', `sub_dealer_i_id` = '208', `dealer_i_id` = '180', `reseller_i_id` = '83', `created_by` = '208', `id_creadted_by` = 'usnet' WHERE `sub_dealer_id` = 'kcs';
[25]
UPDATE `users` SET `sub_dealer_id` = 'kcs', `sub_dealer_i_id` = '272', `dealer_i_id` = '180', `reseller_i_id` = '83', `created_by` = '272', `id_creadted_by` = 'kcs' WHERE `sub_dealer_id` = 'usnet' AND `username` LIKE '%gnet%';
[26]
SELECT u.username, r.username, r.groupname, r.priority FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '200' AND r.username = u.username
[27]
SELECT u.username, r.attribute, r.op, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '202' AND r.username = u.username
[28]
SELECT u.username, STR_TO_DATE(TIME_FORMAT( r.value, '%Y-%m-%d'),'%Y-%m-%d') AS formatted_date FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '202' AND r.username = u.username AND r.`attribute` = 'Expiration'
[29]
SELECT u.username, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '202' AND r.username = u.username AND r.`attribute` = 'Expiration'
[30]
SELECT u.username, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '200' AND r.username = u.username AND r.`attribute` = 'Expiration'
[31]
INSERT IGNORE INTO `customer_usernames` (`username`) SELECT `username` FROM `users`
[32]
UPDATE `users` SET `sub_dealer_id` = 'clicknet', `id_creadted_by` = 'clicknet' WHERE `dealer_id` = 'idea';
[33]
SELECT `user_username`,`user_service_groupname`,`dealer_rate`,`dealer_wallet`,`sub_dealer_rate`,`sub_dealer_wallet`,`user_charged_date` FROM `users_charged_history` WHERE `sub_dealer_i_id` = '92' AND MONTHNAME(`user_charged_date`) = 'August' AND YEAR(`user_charged_date`) = '2019';
[34]
SELECT a.user_username AS Customer_Username,a.user_service_groupname AS Service_Plan,a.dealer_rate,a.dealer_wallet,a.sub_dealer_rate AS Sub_Dealer_Rate_Wrong,a.sub_dealer_wallet,a.user_charged_date, b.rate AS Sub_Dealer_Rate_Actual FROM users_charged_history a, sub_dealer_service_rate b WHERE b.groupname = a.user_service_groupname AND b.username = 'spxnet' AND a.sub_dealer_i_id = '92' AND MONTHNAME(a.user_charged_date) = 'August' AND YEAR(a.user_charged_date) = '2019';
[35]
SELECT a.user_username AS Customer_Username,a.user_service_groupname AS Service_Plan,a.sub_dealer_rate AS Sub_Dealer_Rate_Wrong,a.sub_dealer_wallet,a.user_charged_date, b.rate AS Sub_Dealer_Rate_Actual FROM users_charged_history a, sub_dealer_service_rate b WHERE b.groupname = a.user_service_groupname AND b.username = 'spxnet' AND a.sub_dealer_i_id = '92' AND MONTHNAME(a.user_charged_date) = 'August' AND YEAR(a.user_charged_date) = '2019';
[36]
UPDATE `users` SET `sub_dealer_id` = 'hsn' WHERE `id_creadted_by` = 'hsn';
[37]
SELECT u.username, r.groupname, r.priority FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '156' AND r.username = u.username;
[38]
SELECT `username` FROM `users` WHERE `id_creadted_by` = 'sajjadcity';
SELECT `username` FROM `users` WHERE `id_creadted_by` = 'ikramdr';
SELECT `username` FROM `users` WHERE `id_creadted_by` = 'imran';
[39]
SELECT u.username, r.groupname, r.priority FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '148' AND r.username = u.username;
[40]
SELECT u.username, r.attribute, r.op, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '202' AND r.username = u.username
[41]
INSERT IGNORE INTO `customer_usernames` (`username`, `index_id`) SELECT `username`, `id` FROM `users` WHERE users.dealer_id = 'imran';
[42]
INSERT IGNORE INTO `customer_usernames` (`username`, `index_id`) SELECT `username`, `id` FROM `users`;
[43]
UPDATE customer_usernames
INNER JOIN users ON (customer_usernames.username = users.username)
SET customer_usernames.index_id = users.id;
[44]
UPDATE manager_usernames
INNER JOIN web_managers ON (manager_usernames.username = web_managers.username)
SET manager_usernames.index_id = web_managers.id;
[45]
SELECT u.username, r.attribute, r.op, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '202' AND r.username = u.username
[46]
SELECT u.username FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '156' AND r.username = u.username;
SELECT u.username FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '148' AND r.username = u.username;
SELECT u.username FROM `usersinfo` u, `radusergroup` r WHERE u.createdby = '150' AND r.username = u.username;
[47]
SELECT u.username, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '156' AND r.username = u.username AND r.`attribute` = 'Expiration';
SELECT u.username, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '148' AND r.username = u.username AND r.`attribute` = 'Expiration';
SELECT u.username, r.value FROM `usersinfo` u, `radcheck` r WHERE u.createdby = '150' AND r.username = u.username AND r.`attribute` = 'Expiration';
[48]
UPDATE `users` SET `expiration` = '2000-02-02' WHERE `account_status` = '2';
[49]
UPDATE `users` SET `sub_dealer_id` = 'easylink' WHERE `id_creadted_by` = 'easylink';
[50]
UPDATE `users` SET `sub_dealer_id` = 'kcs' WHERE `username` LIKE '%gs%' AND `id_creadted_by` = 'usnet';
[51]
UPDATE `users` SET `id_creadted_by` = 'kcs' WHERE `sub_dealer_id` = 'kcs';
[52]
SELECT r.* FROM `users` u, `radcheck` r WHERE u.dealer_id = 'nadeem' AND r.username = u.username;
[53]
SELECT r.username FROM `users` u, `radcheck` r WHERE u.dealer_id = 'nadeem' AND r.username = u.username GROUP BY r.username Having COUNT(r.username) > 3
[54]
SELECT r.username FROM `users` u, `radcheck` r WHERE r.username = u.username GROUP BY r.username Having COUNT(r.username) > 3
[55]
SELECT r.username FROM `users` u, `radcheck` r WHERE r.username = u.username GROUP BY r.username Having COUNT(r.username) > 3
[56]
SELECT a.user_username, a.user_service_groupname, a.user_charged_date,
b.username, b.full_name, b.phone1, b.phone2, b.cnic, b.address, b.sub_dealer_id, b.dealer_id FROM `users_activation_history_archive` a, `users` b WHERE a.user_username = b.username AND a.user_charged_date BETWEEN '2019-07-01' AND '2019-07-31';
[57]
SELECT `full_name`,`username`,`password`,`password`,`cnic`,`phone1`,`phone2`,`email`,`address` FROM `users` WHERE `id_creadted_by` = 'asifnetwork';
[58]
SELECT `full_name`,`username`,`password`,`password`,`cnic`,`phone1`,`phone2`,`email`,`address` FROM `users` WHERE `id_creadted_by` = 'yasirpittal';
[59]
SELECT `username`,`groupname`,`expiration` FROM `users` WHERE `id_creadted_by` = 'nati';
[60]
0 Comments