INSERT INTO `users` (`id`, `fbId`, `fbEmail`, `device_key`, `device_token`, `version`, `firstname`, `lastname`, `name`, `username`, `password`, `device_id`, `gender`, `phone`, `street`, `city`, `province`, `postalcode`, `country`, `card_type`, `card_no`, `card_exp`, `cvv_no`, `birthdate`, `profileImage`, `fbData`, `promocodeid`, `refererid`, `credit`, `is_phone`, `is_email`, `lastcc`, `created_at`, `updated_at`, `lastUsedAp_at`, `specialnote`, `apartment`, `device_type`, `device_idfa`, `totalorder`, `ip_as`, `ip_city`, `ip_country`, `ip_countryCode`, `ip_isp`, `ip_lat`, `ip_lon`, `ip_org`, `ip_query`, `ip_region`, `ip_regionName`, `ip_status`, `ip_timezone`, `ip_zip`, `ip_ClosestinApp`, `campaignName`, `bdaynotifcation`, `expiredcode`, `currentcard`, `location`) VALUES (1, '1521397251271773', 'waseem81@live.ca', '', '2b2eb3431ad57ad701aa6b825608f04dd1ce0419aaf2ae9bac3cb5461bb53b44', NULL, 'Waseem', 'Sakka', '', 'waseem81@live.ca', 'AyUDYgAhBndSN1QxATUHbw==', '41d98b2839d681271d4d6ac6645e311a7b1e73eb', 'male', '4167950024', '', '', '', '', '', NULL, NULL, NULL, NULL, '1981-01-17 00:00:00', '1', '', NULL, NULL, 10, '1', '1', NULL, '2017-12-11 12:53:48', '2019-12-04 14:14:06', '2019-12-04 14:14:06', '', '', 5, NULL, '3', '206.223.168.165', '', 'Canada', '', '', '43.6426', '-79.4002', '', '206.223.168.165', 'ON', 'Ontario', '', '', 'M5V', '0', NULL, '1', NULL, 39701, NULL), (2, '629297470', '', '', '6390277baa02a0b8aa9ac576c3ab672691f1e470d20b8b2616090f53142e2d89', '2.8.15', 'Jason', 'Reid', '', '', NULL, 'cee5fcbb8cec3237e8f4c0a6e329907a', 'Male', '4169030305', '', 'Toronto', 'Ontario', 'M5V2M5', '', 'Visa', 'rLibzF1RVc/E7FpyHtMPzXM9bmBy83UXqvw9Kfza2yo=', '10/2018', 'Hd6in5c42AqvqOepAyM2og==', '1997-11-17 00:00:00', '0', '', NULL, NULL, 113.205, '1', '1', '7152', '2013-07-31 22:27:01', '2020-02-28 16:36:21', '2020-02-24 15:10:04', '', '', 1, '85A63584-C19B-43C0-AEE7-EB103D2567A3', '267', '206.223.168.165', 'Toronto', 'Canada', 'CA', 'Rogers Wireless', '43.63830947876', '-79.425552368164', 'Rogers Wireless', '206.223.168.165', 'ON', 'Ontario', 'success', 'America/Toronto', 'M6K 3E3', '0', 'Distribution_Partner', '1', '0', 49, NULL), (3, NULL, '', '', '', '2.8', 'Guest', 'User', '', 'hello@shit.com', 'AyUDYgAhBndSN1QxATUHbw==', '', 'Male', '', '', '', '', '', '', NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0', '', NULL, NULL, NULL, '1', '1', NULL, '2017-12-11 12:53:48', '2018-12-07 23:45:49', '2018-11-24 08:44:03', '', '', 1, '772DE1F8-BAFC-49AA-8264-655DC1CB12A9', '3', '206.223.168.165', '', 'Canada', '', '', '43.6404', '-79.3995', '', '206.223.168.165', 'ON', 'Ontario', '', '', 'M5V', '0', NULL, '1', NULL, NULL, NULL), (4, '58010691', '', '', 'eHMWpTEE6nM:APA91bHgmYCCHEeP4T0Td3-7BbapV5uB8Cb0NhbEtVKKLLQL4-9r6nFYnkAGY0Xu4v3KBuQZYutIOeSbI2MNCTqsDq1htX7Admyl_xpswhFjnRyHxZZmn6A3P5nivKWJ9CnJ7GE3fu1i', NULL, 'Warren', 'Needler', '', 'warrenneedler@gmail.com', 'BGcPMlY8VmAEYQ1jW2hTNw==', '', 'Male', '4243304406', '948 Lake St. Apt E.', 'Venice ', 'Ca', '90291', 'USA', 'Visa', 'mSXoAtALKbiuUiec2cjcOHM9bmBy83UXqvw9Kfza2yo=', '08/2018', 'm0KA2pzaC7DL2xzhQkrVDg==', '1983-08-15 00:00:00', '1', '', NULL, NULL, 355.51, '1', '1', '9400', '2013-07-31 22:47:28', '2020-02-20 07:46:52', '2019-11-01 09:38:42', '', 'Apt. E', 5, NULL, '309', '99.239.34.29', 'Santa Monica', 'Canada', 'US', 'Verizon Business', '43.703170776367', '-79.512191772461', 'Verizon Business', '99.239.34.29', 'ON', 'Ontario', 'success', 'America/Los_Angeles', 'M3H 6A7', '0', NULL, '1', '0', 22240, NULL), (5, NULL, NULL, '', '90df76e68edd9efc822310a8616983a52574392a5d90f18c04dc470b54307443', '1.6.3', 'Marco', 'Bresba', '', 'marcobresba@gmail.com', 'UnBXIVNoUzUFNAFkU21UO1Ay', 'daa1faff9362266b645f5c13b3cc7b9c', 'Male', '', '', '', '', '', '', 'Visa', 'kFhtLhBbjctzHhJBca0GK3M9bmBy83UXqvw9Kfza2yo=', '05/2020', '5Zfpm3IQ9EMQZ4m5R9GLNA==', '1998-07-12 00:00:00', '0', '', NULL, NULL, 0, '1', '1', '8355', '2013-07-31 22:55:47', '2020-02-01 21:19:35', '2018-12-15 19:59:40', NULL, '', 1, NULL, '6', '99.230.186.104', 'Toronto', 'Canada', 'CA', 'Rogers Cable', '43.703170776367', '-79.512191772461', 'Rogers Cable', '99.230.186.104', 'ON', 'Ontario', 'success', 'America/Toronto', 'M3H 6A7', '0', NULL, '1', '0', 36783, NULL), (6, NULL, NULL, '', 'e19727f859341a30720f0811ad35edece2ac1713b04030df03221c920789b02c', '2.5.12', 'carlo', 'trevisan', '', 'carlo.trevisan@me.com', 'UnADZlJzBHJXdwc1VyNcdA==', '190385e6004eb1d55261848623df175a', 'Male', NULL, '', '', '', '', '', 'Visa', 'Ack43Jug6L1FTmsPY0GSs3M9bmBy83UXqvw9Kfza2yo=', '03/2017', 'dnupy4cAGaKuNVpC8x9Z2w==', NULL, '0', '', NULL, NULL, 0, '1', '1', '0869', '2013-07-31 22:59:54', '2018-08-19 17:39:50', '2018-03-18 00:17:10', NULL, NULL, 1, '00000000-0000-0000-0000-000000000000', '4', '162.249.163.26', 'Toronto', 'Canada', 'CA', NULL, '43.6572', '-79.3783', NULL, '162.249.163.26', 'ON', 'Ontario', NULL, 'America/Toronto', 'M5B', '0', NULL, '1', '0', 29828, NULL), (8, NULL, NULL, '', '96e5c0028ee4dea56c7514f3c881765a4cbf791959973aeb769bacc20cfa6c65', '1.6.1', 'Van', 'Echeverri', '', 'van@vanechmedia.com', 'VzIHMl0/UhpTaAA4UDlUbVR+VycGZgZhUC4=', 'd6529742a3396f6112641d2a2017750e', '', NULL, '', '', '', '', '', 'Visa', 'hO5oO26Jdhxi9bZj/i90bnM9bmBy83UXqvw9Kfza2yo=', '08/2015', 'VxtlO+6TLuL0ddac3SlG6w==', NULL, '0', '', NULL, NULL, 0, '1', '1', '0999', '2013-08-02 21:40:01', '2019-01-14 00:58:56', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL), (9, '100002928271672', 'rosecarter2483@gmail.com', '', 'c931af8b28f86a6fe944f73586885a904f445e5e74e07e1bfd4806d01ebc5e98', '1.6.5', 'Nishant', 'Modi', '', NULL, NULL, 'bfb6f973418a91a14eeee0995f85197d', 'female', '', '', '', '', '', '', '', 'cz1uYHLzdReq/D0p/NrbKg==', '', 'cz1uYHLzdReq/D0p/NrbKg==', '1983-04-02 00:00:00', '1', '', NULL, NULL, 0, '1', '1', '', '2013-08-06 00:08:57', '2017-11-28 18:29:46', '2014-08-07 19:25:04', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', 54, NULL), (10, '100005231913894', 'astrologer@techflitter.com', '', '', '1.0', 'Kiranchandra', 'Modi', '', NULL, NULL, '74c89e1254bbcea41dfa74635af133dc', 'male', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, '1953-09-30 00:00:00', '0', '', NULL, NULL, 0, '1', '1', NULL, '2013-08-06 00:14:55', '2017-11-28 18:29:46', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL), (11, NULL, '', '', 'a88884dcb1408146ed0074b3bc0345e4487c5f05724f45382cb489256bcb70de', '1.6.7', 'Robert', 'Tallack', '', 'rtallack@gmail.com', 'VXMBZAE9DmAAIAcxUDlSZQ==', '8b34fceb1efaaf475402ca7355caad97', NULL, '4806860286', '', '', '', '', '', 'Visa', 'npPRD2tb+IaxnGRJveoQrHM9bmBy83UXqvw9Kfza2yo=', '09/2017', 'T4Ufs0utkFipID96la4epQ==', '1979-12-13 00:00:00', '0', '', NULL, NULL, 0.0048, '1', '1', '2186', '2013-08-06 01:09:03', '2020-02-26 15:08:59', '2020-02-26 15:08:59', '', '', 1, NULL, '52', '70.187.172.183', 'Irvine', 'United States', 'US', 'Cox Communications Inc.', '33.651969909668', '-117.83888244629', 'Cox Communications', '70.187.172.183', 'CA', 'California', 'success', 'America/Los_Angeles', '92612', '0', NULL, '1', '0', 32892, NULL), (12, '767276018', 'glennbakie@gmail.com', '', 'e07a795b0680f7de654c58b1fc90d698373d2963a5020a35539fe75da043955e', '2.8.4', 'Glenn', 'Bakie', '', NULL, NULL, '0b7f170e72228d2adefc28d4edb9c12d', NULL, '6134023858', '1921 Cedarlakes Way', 'Greely', 'On', 'k4p0e4', 'Canada', 'Visa', 'h9Od/Iu7fCRypituV4+bCHM9bmBy83UXqvw9Kfza2yo=', '10/2017', 'wi9BJiCNmAn0ifV3RCf/UA==', '1974-05-26 00:00:00', '0', '', NULL, NULL, 0, '1', '1', '7387', '2013-08-06 03:54:28', '2020-01-02 17:47:48', '2019-12-19 10:32:30', NULL, '', 1, '4D80C877-3D11-431C-8AF1-F485F93B16DC', '2', '209.226.181.114', 'Ottawa', 'Canada', 'CA', 'Bell Canada', '45.235801696777', '-75.472702026367', 'Bell Canada', '209.226.181.114', 'ON', 'Ontario', 'success', 'America/Toronto', 'K0A 2P0', '0', NULL, '1', '0', 41392, NULL), (13, '304700258', 'adamjones07@gmail.com', '', '048541eb78d2700eb73df57514a82d65891f4331c05ec92ed7d556914ba78b40', '1.6.6', 'Adam', 'Jones', '', NULL, NULL, '23f94cec4f14fa243636b11213d50c2d', 'male', '', '', '', '', '', '', '', 'cz1uYHLzdReq/D0p/NrbKg==', '', 'cz1uYHLzdReq/D0p/NrbKg==', '1987-11-12 00:00:00', '0', '', NULL, NULL, 0, '1', '1', '', '2013-08-06 16:16:32', '2017-11-28 18:29:46', '2014-06-17 20:33:51', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', 57, NULL), (14, '902405004', 'mike@riptidegames.com', '', '362adddd7509392214208be53d8fe086a0860341361451f82adef4084d3e1267', '1.6.2', 'Mike', 'Montgomery', '', NULL, NULL, '1e5bb2b0f7bc7c43ea5ee3b8ff64f63c', 'male', '', '', '', '', '', '', '', 'cz1uYHLzdReq/D0p/NrbKg==', '', 'cz1uYHLzdReq/D0p/NrbKg==', '1979-09-26 00:00:00', '0', '', NULL, NULL, 0, '1', '1', '', '2013-08-06 20:30:45', '2017-11-28 18:29:46', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', 58, NULL), (15, NULL, NULL, '', 'e2e8480f45c48bf1379681d1a9ac7c8978701a94c80a45d50dcfe39a6e6113a5', '1.0', 'Blake', 'Armstrong', '', 'blake@addsaltandpepper.com', 'BDEEaVJmVCUJPAQ0VyIHOlFv', '8f21f3512b510513f24522e98ab47b5e', '', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, '0', '', NULL, NULL, 0, '1', '1', NULL, '2013-08-06 21:24:26', '2018-08-19 17:39:50', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL), (16, NULL, NULL, '', '03a693043cc757ef135417ca108da6b0864f8c2d14ee4e0ec9f4de93f3070cd5', '2.5.7', 'kayla', 'rimer', '', 'kaylarimer@hotmail.com', 'AT5XMFxpB2tSagQ/BDMAZQ==', '8a371f2f7aeda2590788391b4809aedc', '', '6479694437', '', '', '', '', '', 'MasterCard', '8VjZOwfzQhLL2RdwO2UAjXM9bmBy83UXqvw9Kfza2yo=', '11/2017', 'coefhg1uMuwBo+EWAFb+oA==', '2017-09-21 00:00:00', '1', '', NULL, NULL, 0, '1', '1', '7717', '2013-08-06 22:17:32', '2019-11-29 08:33:24', '2017-10-01 13:54:30', '', '', 1, '9B8519B1-C410-409D-9E33-39AE465B3FB8', '6', '69.159.72.207', 'Toronto', 'Canada', 'CA', 'Rogers Cable', '43.652828216553', '-79.39582824707', 'Rogers Wireless', '69.159.72.207', 'ON', 'Ontario', 'success', 'America/Toronto', 'M5T 2A6', '0', NULL, '1', '0', NULL, NULL), (17, NULL, NULL, '', '966e58008e172cb8dfcb5e9aa6c74e1c0485a26625b3996f5e6fdf2eb94f92e2', '2.8.4', 'Michael', 'Mavian', '', 'Michael@mrmavian.com', 'BwYOfgYxAWgIMAE3BjABbg==', '1cc54248f66043d1dc4e1d729aab05ba', '', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, '0', '', NULL, NULL, 0, '1', '1', NULL, '2013-08-06 23:46:28', '2018-12-08 18:12:23', '2018-12-08 18:12:21', NULL, NULL, 1, '1723607F-7F2E-466B-9C84-2A42F5189FF4', NULL, '72.139.198.74', 'Toronto', 'Canada', 'CA', 'Rogers Cable', '43.6909', '-79.8377', 'Rogers Cable', '72.139.198.74', 'ON', 'Ontario', 'success', 'America/Toronto', 'L7A', '0', NULL, '1', '0', NULL, NULL), (18, NULL, NULL, '', 'a1110d5d19b7d213ad273e75ac257125ab26262d2116377e1ea618c7863b1249', '2.5.7', 'Sarah', 'Paterson', '', 'sarah@patersonpartners.com', 'CT8GbQY4AWgBLFA2', '772fbb05fd1696d6b2ad5d8b1318d1ef', 'Female', '6472626334', '66 Rowanwood Ave', 'Toronto', 'Ontario', 'm4w 1y9', 'canada', 'Visa', '89LeBzDmt5imev27faUWCXM9bmBy83UXqvw9Kfza2yo=', '11/2016', 'kH/PNrZfyg528q8EYRWM+A==', '0000-11-04 00:00:00', '0', '', NULL, NULL, 0, '1', '1', '2344', '2013-08-07 03:33:31', '2020-01-25 00:41:48', '2020-01-04 13:38:16', '', '', 1, 'A6DA166F-97CC-4465-8261-F6A66D4AFD43', '324', '24.114.59.158', 'Toronto', 'Canada', 'CA', 'Rogers Wireless', '43.682510375977', '-79.557479858398', 'Rogers Wireless', '24.114.59.158', 'ON', 'Ontario', 'success', 'America/Toronto', 'M9R 2A2', '0', NULL, '1', '0', 38982, NULL), (19, NULL, NULL, '', '', '1.0', 'brad', 'Detlor', '', 'bdetlor@hotmial.com', 'U2NXNwNkU2MFZQdh', '1bc34586859d954e97c08e4c644c3b97', 'Male', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, '0', '', NULL, NULL, 0, '1', '1', NULL, '2013-08-07 03:48:36', '2018-08-19 17:39:50', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL), (20, NULL, NULL, '', 'd5a46c709b34d116c30e04d7d58386cd535767d8596441b39dca0abedb73ac1a', '2.2.3', 'Todd', 'Finch', '', 'toddmfinch@gmail.com', 'AD8CZ1d1AGlUZQQ/UjAAPVxp', '0b478f4b359fc9f754059c41b5fd7d66', 'Male', '', '172 Elton Park Road', 'Oakville', 'Ontario', 'L6J 4C1', '', 'Visa', 'jhPpdmjhr9iEf+6QsUDUzHM9bmBy83UXqvw9Kfza2yo=', '03/2015', 'XGavAZWg/q6KyzNlxH2WAg==', '0000-01-30 00:00:00', '0', '', NULL, NULL, 0, '1', '1', '1865', '2013-08-07 15:43:02', '2019-01-14 00:58:56', '2016-01-04 12:08:24', NULL, NULL, 1, 'AB1C0213-1295-47DC-9B60-4F7B14F7EB32', NULL, 'AS812 Rogers Cable Communications Inc.', 'Toronto', 'Canada', 'CA', 'Rogers Cable', '43.6683', '-79.4205', 'Rogers Wireless', '24.114.65.113', 'ON', 'Ontario', 'success', 'America/Toronto', 'M6G', NULL, NULL, '1', '0', NULL, NULL), (21, '804600009', NULL, '', '30e42873cb1c404ec8ee1f68831b6868bca581ea0c8c8a6df3d02778d8f692ed', '1.6', 'Randy', 'Clemens', '', NULL, NULL, '8184b599ae29647830525666d533e9f0', 'male', '', '', '', '', '', '', 'Visa', 'Xyec7o4KiDZ7NaGlOslNy3M9bmBy83UXqvw9Kfza2yo=', '05/2016', 'wv0cQzekCRnBzgNAwoCsuQ==', '1973-08-14 00:00:00', '0', '', NULL, NULL, 19, '1', '1', '9773', '2013-08-07 16:37:24', '2019-01-14 00:58:56', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL), (22, NULL, NULL, '', '1c58b6f1462145b4b40a6c781c623ada461b4c17a657beb7a0b0586ccd5c2ec3', '1.0', 'warren', 'needler', '', 'warrenneedler1@gmail.com', 'BGcPMlY8VmAEYQ1jW2hTNw==', 'd9ea80e4db83f2116505518896d881d4', '', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, '0', '', NULL, NULL, 0, '1', '1', NULL, '2013-08-07 16:45:31', '2018-08-19 17:39:50', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL), (23, '693721367', 'pbaveling@hotmail.com', '', '9b7f19f01ae9de1273f6b856eff0adf04fcceb4d48a9e426f4ec53e6eddb697f', '2.2.1', 'Paula', 'Aveling', '', 'Paula.aveling@gmail.com', 'U2NSI1NjD2gHP1NhBmNSb1F2BW4=', '0c7079d074a2b6ee937535f8f3afe552', 'female', '', '3 Sudbury Street Unit 303', 'Ontario', '', 'M6j 3w6', '', 'MasterCard', 'xO6gv4F6ma4fEXh62OOzqXM9bmBy83UXqvw9Kfza2yo=', '02/2015', 'KD77uSUknmM92VlbfNgWGg==', '1986-01-07 00:00:00', '0', '', NULL, NULL, 1, '1', '', '8829', '2013-08-07 19:15:07', '2019-01-14 00:58:56', '2015-09-03 15:39:52', NULL, NULL, 1, '2F6B8E4F-B15D-4689-9083-2D0C98A41A2F', NULL, 'AS852 TELUS Communications Inc.', 'Montreal', 'Canada', 'CA', 'Telus Communications', '45.4987', '-73.5793', 'Telus Communications', '142.169.78.170', 'QC', 'Quebec', 'success', 'America/Toronto', 'H3G', NULL, NULL, '1', '0', NULL, NULL), (24, NULL, NULL, '', '', '1.0', 'Lucy', 'Gillette', '', 'lucy.sullivan@hotmail.co.uk', 'CQ8HbFV1UzlXbVd0AGgBbA==', '96303ba000f371ccc1f84c0c18052d3d', 'Female', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, '0', '', NULL, NULL, 0, '1', '1', NULL, '2013-08-07 20:03:12', '2018-08-19 17:39:50', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL), (25, '575296728', 'lucy.anita.sullivan@hotmail.co.uk', '', '56680240dd57ce7c5d544f14681e0423bf80230a5811c78200168a75355fb6e5', '2.1.2', 'Lucy', 'Sullivan', '', 'lucy.anita.sullivan@hotmail.co.uk', 'BQMEbwcnAWsAOlBzUDgHag==', '96303ba000f371ccc1f84c0c18052d3d', 'Female', '', '', 'Pickering', 'Ontario', 'L1x 0c3', '', 'Visa', 'b+hrMCjWrNSIXH5Hcg4gtHM9bmBy83UXqvw9Kfza2yo=', '04/2017', 'Bu4BmkBnUjUo9UpaQTrpMQ==', '1982-12-09 00:00:00', '0', '', NULL, NULL, 0, '1', '1', '1023', '2013-08-07 20:05:18', '2019-01-14 00:58:56', '2015-03-24 12:13:56', '', NULL, 1, NULL, '19', 'AS812 Rogers Cable Communications Inc.', 'Toronto', 'Canada', 'CA', 'Rogers Cable', '43.683', '-79.4184', 'Rogers Wireless', '24.114.65.153', 'ON', 'Ontario', 'success', 'America/Toronto', 'M6C', NULL, NULL, '1', '0', NULL, NULL), (26, '81005199', 'mark.delottinville@gmail.com', '', '0434cd1ed5984cf2232c574e24366ad1ef44929bb9864404be54239a5f92714b', '1.6.4', 'Mark', 'DeLottinville', '', NULL, NULL, '94a9bbd5ff4b86c2c06b1fd75a4678c9', 'male', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, '1987-07-21 00:00:00', '0', '', NULL, NULL, 20, '1', '1', NULL, '2013-08-07 20:26:59', '2016-07-12 11:06:59', '2014-07-15 16:53:12', NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL), (27, '596475329', 'bradbrodi@gmail.com', '', 'c71dafb7a204c1acf2a033aae82641145c7bf10f3d763cebcfa70dd0d4376f11', '1.6.7', 'Brad', 'Rosenberg', '', 'bradbrodi@gmail.com', 'VDcFMAZlVGBVMAdh', '00d95a3eb47bba3dca1e31cb6e941dd6', 'male', '', '', '', '', '', '', 'Amex', 'iCQkaYaSSajpoxKAxNmKHg==', '08/2017', 'MjniKP1BBLgenITV+KhPQA==', '1965-11-25 00:00:00', '0', '', NULL, NULL, 0, '1', '1', '0010', '2013-08-07 20:32:02', '2019-01-14 00:58:56', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL), (28, NULL, NULL, '', '6551651fe9748de7157a5a05075dc09587526213dbc26cdea8500ba462919784', '1.0', 'A J', 'Roach', '', 'ajr10001@yahoo.com', 'V2ICbwM3VidQZVBgUSRWawQ6', '1e1d5b111560e0102af1726438e0befe', '', '', '', '', '', '', '', '', 'cz1uYHLzdReq/D0p/NrbKg==', '', 'cz1uYHLzdReq/D0p/NrbKg==', NULL, '0', '', NULL, NULL, 0, '1', '1', '', '2013-08-07 21:18:11', '2018-08-19 17:39:50', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', 66, NULL), (29, NULL, NULL, '', '43ff7946198aa0a77f96e7be6e76a146aa077d5749c8dfaaf7cedbcd5e5fd855', '2.5.7', 'Adam', 'Zaret', '', 'Adam.j.zaret@gmail.com', 'BTYBfwFgU2YGYgFnATRXOg==', '2257baf0cb70b12152ca7ea38b188271', NULL, '', '122 Ashland Place ', 'Toronto', 'Ontario', 'M4v2z2', '', 'MasterCard', '/f7TEBCp8ttR5jIoNFeFZHM9bmBy83UXqvw9Kfza2yo=', '04/2017', '2P8tPetlmNKEPNoS+3uQQQ==', '1985-05-02 00:00:00', '0', '', NULL, NULL, 0, '1', '', '7420', '2013-08-07 22:12:51', '2020-01-06 11:32:31', '2019-12-13 13:11:06', '', NULL, 1, '54D8695B-7768-465F-A7CF-7A77BF849DD2', '71', '65.93.202.168', 'Montreal', 'Canada', 'CA', 'Rogers Wireless', '45.444229125977', '-75.692779541016', 'Rogers Wireless', '65.93.202.168', 'ON', 'Ontario', 'success', 'America/Toronto', 'K1A 0A1', '0', NULL, '1', '0', 24653, NULL), (30, '667850239', 'kathryn.ducey@rci.rogers.com', '', 'a49ec1fb344156231592aee31f003fe37fede662d12df1d3befede0b007da8ed', '2.5.0', 'Kathryn', 'Ducey', '', 'kathryneducey@gmail.com', 'BRABYAAgVjEFNFN2AWcFKlEz', '00e88c7a8165575a004abc45c117df8d', 'Female', '', '', '', '', '', '', 'Visa', 'VfT+HazmE8hNIAtSl+njEHM9bmBy83UXqvw9Kfza2yo=', '11/2016', 'r/8HN3lgJRX/x+dUvSKHww==', '1981-11-23 00:00:00', '0', '', NULL, NULL, 39.74, '1', '1', '1689', '2013-08-07 23:02:49', '2019-01-14 00:58:56', '2016-04-14 07:29:03', NULL, '', 1, '0662CD27-008B-42F4-A545-266E2F4CB3A1', '6', 'AS852 TELUS Communications Inc.', 'Toronto', 'Canada', 'CA', 'Telus Communications', '43.6667', '-79.4167', 'Telus Communications', '209.171.88.225', 'ON', 'Ontario', 'success', 'America/Toronto', 'M6G', NULL, NULL, '1', '0', NULL, NULL), (31, NULL, NULL, '', 'bda78842da082e52b6dcd5b82c239fb2c5b85fa9edff98acb7ea009c6949b4f8', '2.5.15', 'Alicia', 'Pestill', '', 'apestill@hotmail.com', 'VWEEaVRjB25SYlNhUSRTPlYz', 'd239eb4f6f2c84b78d763fc9d8aac13f', 'Female', '', '195 Greenwood Ave', 'Toronto ', 'Ontario', 'M4L 2P8', '', 'Visa', 'mjbXcId5EgEAX0M1rnDmR3M9bmBy83UXqvw9Kfza2yo=', '09/2018', 'taSoEowRow0iI1diStolBA==', '0000-08-04 00:00:00', '0', '', NULL, NULL, 0, '1', '', '9303', '2013-08-08 02:01:28', '2019-03-24 17:18:44', '2018-05-24 08:47:24', NULL, NULL, 1, '00000000-0000-0000-0000-000000000000', '3', '99.230.61.84', 'Toronto', 'Canada', 'CA', 'Bell Mobility', '43.6541', '-79.3978', 'Bell Mobility', '99.230.61.84', 'ON', 'Ontario', 'success', 'America/Toronto', 'M5T', '0', NULL, '0', '0', NULL, NULL), (32, NULL, NULL, '', '', '1.0', 'Ali', 'Safi', '', 'al.safi89@gmail..com', 'UHYCaVFxUjgDOVZ1BGxQPQ==', 'e853a6d0419590bb86334126e5cd36ea', '', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, '0', '', NULL, NULL, 0, '1', '1', NULL, '2013-08-08 14:32:35', '2018-08-19 17:39:50', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL), (33, NULL, NULL, '', '', '1.0', 'Kelsey', 'Mckibbon', '', 'kelssmckibb@hotmail.com', 'UGhQPlE0AzJSPgEhAXE=', '64e009ac07c3796ce3cf3ba108d22e77', '', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, '0', '', NULL, NULL, 0, '1', '1', NULL, '2013-08-08 19:52:05', '2018-08-19 17:39:50', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, NULL),