09-27-2023, 02:31 PM
learningrx.com
Format - .SQL
Date - 2023
All Rows - 1kk
Website - learningrx.com
Download:
Format - .SQL
Date - 2023
All Rows - 1kk
Website - learningrx.com
Code:
INSERT INTO `lrx_tmp_client` (`id_client`, `id_center`, `id_status`, `first_name`, `middle_init`, `last_name`, `g_first_name`, `g_middle_init`, `g_last_name`, `g_type`, `email_addr`, `date_created`, `addr_street`, `addr_zip`, `addr_city`, `addr_state`, `age`) VALUES
(17303, 8, 2, 'Shana', '', 'midgette', '', '', '', 'Self', 'binrenud@hotmail.com', '2009-03-30', '', '28530', '', '', '0'),
(17304, 8, 2, 'Joanne', '', 'coamach', '', '', '', 'Self', 'joanneamacoh@ymail.com', '2009-03-30', '', '27530', '', '', '0'),
(17305, 8, 2, 'Gary', '', 'snyder', '', '', '', 'Self', 'snyder@yahoo.com', '2009-03-30', '', '27713', '', '', '0'),
(17306, 8, 2, 'Georgina', '', 'mollick', '', '', '', 'Self', 'georgina.mollick@scichild.com', '2009-03-30', '', '27612', '', '', '0'),
(17307, 8, 2, 'Jennifer', '', 'wimbush', '', '', '', 'Self', 'jwimbush@uslines.com', '2009-03-30', '', '29464', '', '', '0'),
(17308, 8, 2, 'Harlene', '', 'parker', '', '', '', 'Self', 'harlenep@gmail.com', '2009-03-30', '', '27909', '', '', '0'),
(17309, 4, 2, 'Kaitlyn', 'N', 'phillips', '', '', '', 'Self', 'dbphillips@zoominternet.net', '2009-03-30', '1327 Vineyard Dr.', '44256', 'Medina', 'OH', '8'),
(17310, 28, 4, 'Claire', '', 'williams', '', '', '', 'Self', 'gina972@comcast.net', '2009-03-30', '972 Thousand Oaks Bend', '30152', 'Kennesaw', 'GA', '14'),
(17311, 4, 4, 'Junee', 'K', 'grewal', '', '', '', 'Self', 'jrgrewal@yahoo.com', '2009-03-30', '5955 Laurawood Ln.', '44236', 'Hudson', 'OH', '10'),
(17312, 55, 2, 'Hollaway', '', 'anna', '', '', '', 'Self', 'cjholloway@knology.net', '2009-03-30', '2829 Aquaduct Ct.', '29414', 'Charleston', 'SC', '13'),
(17313, 59, 3, 'Savannah', 'H', 'sabaka', '', '', '', 'Self', 'kathryn.sabaka@marriott.com', '2009-03-30', '5008 Cliffony Drive', '23464', 'Virginia Beach', 'VA', '16'),
(17314, 50, 4, 'Charlie', '', 'elderd', '', '', '', 'Self', 'ryeld@yahoo.com', '2009-03-30', '5871 Cardnial Ridge Trail S.E.', '55372', 'Prior Lake', 'MN', '12'),
(17315, 59, 3, 'Rebecca', '', 'sabaka', '', '', '', 'Self', 'kathryn.sabaka@marriott.com', '2009-03-30', '5008 Cliffony Drive', '', 'Virginia Beach', 'VA', '12'),
(17316, 15, 2, 'Lead \'Rose\'', '', '?', '', '', '', 'Self', 'buddrosebud@earthlink.net', '2009-03-30', '', '81008', 'Colorado Springs', 'CO', '0'),
(17317, 7, 4, 'John Michael', '', 'lane', '', '', '', 'Self', 'melissaannlane@hotmail.com', '2009-03-30', '2209 Helens Way', '37027', 'Brentwood', 'TN', '6'),
(17318, 59, 3, 'Mackenzie', 'H', 'sabaka', '', '', '', 'Self', 'kathryn.sabaka@marriott.com', '2009-03-30', '5008 Cliffony Drive', '23464', 'Virginia Beach', 'VA', '10'),
(17319, 26, 4, 'Mackenzie', '', 'forman', '', '', '', 'Self', 'kaforman@comcast.net', '2009-03-30', '935 Front Street South', '98027', 'Issaquah', 'WA', '7'),
(17320, 52, 4, 'Madison', '', 'wentworth', '', '', '', 'Self', 'crstrish@comcast.net', '2009-03-30', '2968 Risinger', '71119', 'Shreveport', 'LA', '13'),
(17321, 51, 2, 'Blessed', '', 'moreno', '', '', '', 'Self', 'trifoldunity@yahoo.com', '2009-03-30', 'P.O. Box 35222', '21222', 'Dundalk', 'MD', '0'),
(17322, 62, 2, 'Joseph', '', 'marji', '', '', '', 'Self', 'raja.marji@yahoo.com', '2009-03-30', '1316 Vista Grande', '92835', 'Fullerton', 'CA', '6'),
(17323, 43, 4, 'Alberto', '', 'cruz', '', '', '', 'Self', 'marysell73@hotmail.com', '2009-03-30', '1201 Lakeview Drive East', '33411', 'Royal Palm Beach', 'FL', '10'),
(17324, 62, 2, 'Justina', '', 'marji', '', '', '', 'Self', 'raja.marji@yahoo.com', '2009-03-30', '1316 Vista Grande', '92835', 'Fullerton', 'CA', '8'),
(17325, 16, 2, 'Caitlin', '', 'seibel', '', '', '', 'Self', 'lseibel@peakinet.net', '2009-03-30', 'PO Box 131', '80814', 'Divide', 'CO', '13'),
INSERT INTO `imd_lead_account` (`id_acc`, `email_addr`, `subjec_tline`, `is_client`, `is_exported`, `date_last_visit`, `date_added`, `is_deleted`) VALUES
(112999, 'go.parra4@gmail.com', '', '0', '0', '2012-11-12 12:40:58', '2012-11-12 12:40:58', '0'),
(113000, 'dnavetta@yahoo.com', '', '0', '0', '2012-11-12 12:44:02', '2012-11-12 12:44:02', '0'),
(113001, 'jonquilhair@yahoo.com', '', '0', '0', '2012-11-12 12:51:12', '2012-11-12 12:51:12', '0'),
(113002, 'dahlia98@hotmail.com', '', '0', '0', '2012-11-12 12:52:36', '2012-11-12 12:52:36', '0'),
(113003, 'pbarjesteh@gmail.com', '', '0', '0', '2012-11-12 12:54:04', '2012-11-12 12:54:04', '0'),
(113004, 'lmanobanda@kpmg.com', '', '0', '0', '2012-11-12 12:59:56', '2012-11-12 12:59:56', '0'),
(113005, 'ssamuels1075@yahoo.com', '', '0', '0', '2012-11-12 13:04:18', '2012-11-12 13:04:18', '0'),
(113006, 'taylorgainey4@gmail.com', '', '0', '0', '2012-11-12 13:12:09', '2012-11-12 13:12:09', '0'),
(113007, 'jackgclark@gmail.com', '', '0', '0', '2012-11-12 13:17:20', '2012-11-12 13:17:20', '0'),
(113008, 'adkinskrystal28@yahoo.com', '', '0', '0', '2012-11-12 13:17:52', '2012-11-12 13:17:52', '0'),
(113009, 'camiebarger@yahoo.com', '', '0', '0', '2012-11-12 13:25:51', '2012-11-12 13:25:51', '0'),
(113010, 'rondauvso@aol.com', '', '0', '0', '2012-11-12 13:35:01', '2012-11-12 13:35:01', '0'),
(113011, 'bainhanning1@mac.com', '', '0', '0', '2012-11-12 13:36:11', '2012-11-12 13:36:11', '0'),
(113012, 'jerrellking@bellsouth.net', '', '0', '0', '2012-11-12 13:40:39', '2012-11-12 13:40:39', '0'),
(113013, 'angela.adkins@trimble.kyschools.us', '', '0', '0', '2012-11-12 13:41:21', '2012-11-12 13:41:21', '0'),
(113014, 'rbs7@rediffmail.com', '', '0', '0', '2012-11-12 13:46:53', '2012-11-12 13:46:53', '0'),
(113015, 'daniellie.says.hello@gmail.com', '', '0', '0', '2012-11-12 13:48:17', '2012-11-12 13:48:17', '0'),
(113016, 'heatherlynnhicks@gmail.com', '', '0', '0', '2012-11-12 13:49:31', '2012-11-12 13:49:31', '0'),
(113017, 'edithsponce@aol.com', '', '0', '0', '2012-11-12 13:53:37', '2012-11-12 13:53:37', '0'),
(113018, 'luigi59969@gmail.com', '', '0', '0', '2012-11-12 14:09:20', '2012-11-12 14:09:20', '0'),
(113019, 'jensanders648@gmail.com', '', '0', '0', '2012-11-12 14:10:19', '2012-11-12 14:10:19', '0'),
(113020, 'haileymarie_2007@yahoo.com', '', '0', '0', '2012-11-12 14:13:03', '2012-11-12 14:13:03', '0'),
(113021, 'anjelitar8707@hotmail.com', '', '0', '0', '2012-11-12 14:13:29', '2012-11-12 14:13:29', '0'),
(113022, 'woodenneedle_81@hotmail.com', '', '0', '0', '2012-11-12 14:16:05', '2012-11-12 14:16:05', '0'),
(113023, 'adprince2002@msn.com', '', '0', '0', '2012-11-12 14:16:47', '2012-11-12 14:16:47', '0'),
(113024, 'drnanette@gmail.com', '', '0', '0', '2012-11-12 14:33:58', '2012-11-12 14:33:58', '0'),
(113025, 'vintageswine@msn.com', '', '0', '0', '2012-11-12 14:36:59', '2012-11-12 14:36:59', '0'),
(113026, 'carrie.b.care@gmail.com', '', '0', '0', '2012-11-12 14:40:33', '2012-11-12 14:40:33', '0'),
INSERT INTO `imd_person_detail` (`id_detail`, `id_gtw`, `id_addr`, `id_src`, `id_lead`, `id_center`, `session_id`, `prefix`, `first_name`, `middle_init`, `last_name`, `suffix`, `age`, `birth_date`, `gender`, `area_code`, `phone`, `sid`, `fbclid`, `gclid`, `utm_source`, `utm_medium`, `utm_campaign`, `utm_term`, `utm_content`, `mkr_source`, `SPPC`, `is_default`, `date_added`, `is_sent_to_hub`, `sent_to_hub_on`, `is_sent_to_infusoft`, `hub_failure_code`, `referrer`, `AgreePrivacyTerms`, `MoreInfoSubscription`, `is_sent_to_bigcontact`, `is_sent_to_salesforce`, `id_center_ppc`) VALUES
(167184, NULL, 184243, 6, 141198, 35, NULL, ' ', 'sami', '', 'Elamin', ' ', NULL, NULL, 'u', '267', '241-3154', '', '', '', '', '', '', '', '', '', '', '0', '2013-05-03 19:06:26', 1, '2013-05-03 19:10:04', 0, 0, 'http://lsds.learningrx.com/lsds-ab/form.php', 'yes', 'yes', 1, 1, 35),
(167185, NULL, 184244, 7, 141199, 1, NULL, ' ', 'Chad', '', 'Cromer', ' ', NULL, NULL, 'u', '510', '295-8190', '', '', '', '', '', '', '', '', '', '', '1', '2013-05-03 19:09:01', 1, '2013-05-03 19:10:04', 0, 0, 'http://lsds.learningrx.com/form.php', 'yes', 'yes', 1, 1, 1),
(167186, NULL, 184245, 7, 141200, 45, NULL, ' ', 'morgan', '', 'Porter', ' ', NULL, NULL, 'u', '817', '789-9971', '', '', '', '', '', '', '', '', '', '', '1', '2013-05-03 19:44:00', 1, '2013-05-03 19:45:01', 0, 0, 'http://lsds.learningrx.com/form.php', 'yes', 'yes', 1, 1, 45),
(167187, NULL, 184246, 7, 141201, 29, NULL, ' ', 'Alma', '', 'Ramirez', ' ', NULL, NULL, 'u', '352', '988-8125', '', '', '', '', '', '', '', '', '', '', '1', '2013-05-03 19:46:37', 1, '2013-05-03 19:50:01', 0, 0, 'http://lsds.learningrx.com/form.php', 'yes', 'yes', 1, 1, 29),
(167188, NULL, 184247, 6, 141202, 1, NULL, ' ', 'andrea', '', 'milsap', ' ', NULL, NULL, 'u', '501', '693-6108', '', '', '', '', '', '', '', '', '', '', '1', '2013-05-03 19:53:42', 1, '2013-05-03 19:55:01', 0, 0, 'http://lsds.learningrx.com/lsds-ab/form.php', 'yes', 'yes', 1, 1, 1),
(167189, NULL, 184248, 7, 141203, 1, NULL, ' ', 'N', '', 'B', ' ', NULL, NULL, 'u', '0', '000-0000', '', '', '', '', '', '', '', '', '', '', '1', '2013-05-03 20:14:57', 1, '2013-05-03 20:15:02', 0, 0, 'http://lsds.learningrx.com/form.php', 'yes', 'yes', 1, 1, 1),
(167190, NULL, 184249, 6, 141204, 1, NULL, ' ', 'Samya', '', 'El Kettani', ' ', NULL, NULL, 'u', '805', '291-7908', '', '', '', '', '', '', '', '', '', '', '1', '2013-05-03 20:17:03', 1, '2013-05-03 20:20:02', 0, 0, 'http://lsds.learningrx.com/lsds-ab/form.php', 'yes', 'yes', 1, 1, 1),
(167191, NULL, 184250, 7, 141205, 112, NULL, ' ', 'L', '', 'Smith', ' ', NULL, NULL, 'u', '240', '595-1412', '', '', '', '', '', '', '', '', '', '', '1', '2013-05-03 20:20:38', 1, '2013-05-03 20:25:02', 0, 0, 'http://lsds.learningrx.com/form.php', 'yes', 'yes', 1, 1, 112),
(167192, NULL, 184251, 7, 141206, 1, NULL, ' ', 'eduardo', '', 'corsi', ' ', NULL, NULL, 'u', '805', '415-3326', '', '', '', '', '', '', '', '', '', '', '1', '2013-05-03 20:20:55', 1, '2013-05-03 20:25:02', 0, 0, 'http://lsds.learningrx.com/form.php', 'yes', 'yes', 1, 1, 1),
(167193, NULL, 184252, 6, 141207, 113, NULL, ' ', 'Abby', '', 'La', ' ', NULL, NULL, 'u', '201', '247-1672', '', '', '', '', '', '', '', '', '', '', '1', '2013-05-03 20:24:48', 1, '2013-05-03 20:25:02', 0, 0, 'http://lsds.learningrx.com/lsds-ab/form.php', 'yes', 'yes', 1, 1, 113),
(167194, NULL, 184253, 6, 141208, 27, NULL, ' ', 'joseph', '', 'long', ' ', NULL, NULL, 'u', '904', '866-8802', '', '', '', '', '', '', '', '', '', '', '1', '2013-05-03 20:31:58', 1, '2013-05-03 20:35:02', 0, 0, 'http://lsds.learningrx.com/lsds-ab/form.php', 'yes', 'yes', 1, 1, 27),
(167195, NULL, 184254, 6, 141209, 112, NULL, ' ', 'Lindsay', '', 'Ross', ' ', NULL, NULL, 'u', '202', '641-7412', '', '', '', '', '', '', '', '', '', '', '1', '2013-05-03 20:34:45', 1, '2013-05-03 20:35:02', 0, 0, 'http://lsds.learningrx.com/lsds-ab/form.php', 'yes', 'yes', 1, 1, 112),
(183, 380341, NULL, NULL, 'CA16', 'LearningRx Center - Irvine', 0, 'Irvine', '657', '212-5686', '', '', '', 'irvine.ca@learningrx.net', 'irvine.ca@learningrx.net', 'cmesa.irvine.ca@learningrx.netirvine.ca@learningrx.net', '', '', '', '', 'ppc', '-117.8743314', '33.6786932', 0, '0', 0, '0', '0', '1', '0', '0', '0', '', '', 'www.learningrx.com/irvine/', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-10-30 20:43:28', '2023-05-05 21:47:53', '', 0, '0', '0', NULL, 1, '', '', '', 0, '607782240', 'USA'),
(187, 401496, NULL, NULL, 'ON01', 'LearningRx Center - Richmond Hill', 0, '', '905', '237-8860', '', '', '', 'richmondhill.on@learningrx.net', 'richmondhill.on@learningrx.net', '', '', '', '', '', 'ppc', '-79.381558', '43.866764', 0, '0', 0, '0', '0', '0', '0', '0', '0', '', '', 'www.learningrx.com/richmond-hill', '', '2020-09-21 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2020-08-25 01:20:47', '2023-05-05 21:52:38', '', 0, '0', '0', NULL, 1, '', '', '', 0, '', 'CA'),
(189, 412839, NULL, NULL, 'TN07', 'LearningRx Center - Franklin', 0, '', '', '(615)601-3254', '', '', '', 'franklin.tn@learningrx.net', 'franklin.tn@learningrx.net', '', '', '', '', '', 'non-ppc', '-86.838647', '35.940757', 0, '0', 0, '0', '0', '1', '0', '0', '0', '', '', 'www.learningrx.com/franklin', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-10-31 20:17:38', '2023-05-05 21:46:13', '', 0, '0', '0', NULL, 1, '', '', '', 0, '', 'USA'),
(190, 413161, NULL, NULL, 'AR03', 'LearningRx Center - River Valley', 0, '', '479', '434-2700', '', '', '', 'rivervalley.ar@learningrx.net', 'rivervalley.ar@learningrx.net', 'rivervalley.ar@learningrx.net', '', '', '', '', 'ppc', '-94.4038986', '35.3687621', 0, '0', 0, '0', '0', '0', '0', '0', '0', '', '', 'www.learningrx.com/river-valley', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2023-02-25 20:44:32', '2023-05-05 21:50:01', '', 0, '0', '0', NULL, 1, '', '', '', 0, '', 'USA'),
(191, 413174, NULL, NULL, 'AZ03', 'LearningRx Center - Glendale', 0, '', '480', '855-9099', '', '', '', 'glendale.az@learningrx.net', 'glendale.az@learningrx.net', '', '', '', '', '', 'ppc', '-112.2365221', '33.6450516', 0, '0', 0, '0', '0', '0', '0', '0', '0', '', '', '', '', '2023-03-01 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2023-03-02 23:14:19', '2023-05-05 21:50:18', '', 0, '0', '0', NULL, 1, '', '', '', 0, '', 'USA'),
(192, 413287, NULL, NULL, 'CO10', 'LearningRx - Highlands Ranch', 0, '', '303', '955-2959', '', '', '', 'highlandsranch.co@learningrx.net', 'highlandsranch.co@learningrx.net', 'highlandsranch.co@learningrx.net', '', '', '', '', 'ppc', '-105.0109', '39.5397', 0, '0', 0, '0', '0', '0', '0', '0', '0', '', '', 'www.learningrx.com/highlands-ranch', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2023-04-22 15:35:44', '2023-06-08 13:23:35', '', 0, '0', '0', NULL, 1, '', '', '', 0, '', 'USA'),Download: