[Sphere]

By Chucky on LB. There are over 390k unique emails by my count, however the customer db itself is more like ~300k

Sample:

INSERT INTO `customer` (`CustomerID`, `CustomerPassword`, `CustomerFirst`, `CustomerLast`, `CustomerShipFirst`, `CustomerShipLast`, `CustomerStreet1`, `CustomerStreet2`, `CustomerCity`, `CustomerState`, `CustomerZip`, `CustomerCountry`, `CustomerBillingFirstName`, `CustomerBillingLastName`, `CustomerBillingStreet1`, `CustomerBillingStreet2`, `CustomerBillingCity`, `CustomerBillingState`, `CustomerBillingZip`, `CustomerBillingCountry`, `CustomerPhone`, `CustomerEmail`, `CustomerCompany`, `CustomerType`, `FacebookUserId`, `IsGuest`, `CustomerComments`, `CreatedDate`, `S_R`, `customer_from`, `RetailerID`, `CustomerProfileID`, `Account_Executive`, `QuickBooks_DisplayName`, `QuickBooks_CustomerID`, `QB_Return_Obj`, `auth_key`, `company`, `status`, `isSmsOptIn`, `birthday`) VALUES

(157723, 'c4b828e73f2f6e98be22d3c287566edc', 'james', 'rich', 'james', 'rich', '1624 Blackrock rd', NULL, 'Swarthmore', 'PA', '19081', 'US', 'james', 'rich', '1624 Blackrock rd', NULL, 'Swarthmore', 'PA', '19081', 'US', '6108093917', '[email protected]', '', 'c', '', '1', NULL, 1586964793, '', 0, '', '', '', '', '', '', '', '', 0, 'no', ''),
(157724, 'a1fe2a8e688345354c319c7e9e6db39a', 'Dylan', 'Kemp', 'Dylan', 'Kemp', '525 north church st.', NULL, 'Hastings ', 'MI', '49058', 'US', 'Dylan', 'Kemp', '525 north church st.', NULL, 'Hastings ', 'MI', '49058', 'US', '2698041828', '[email protected]', '', 'c', '', '1', NULL, 1586964820, '', 0, '', '1651887632', '', '', '', '', '', '', 0, 'no', ''),
(157725, 'e428c75c69c9876e03dc3e8ecfee499a', 'Tommy ', 'Sipes', 'Tommy ', 'Sipes', '2274 Deerfield 3', NULL, 'Maiden ', 'NC', '29750', 'US', 'Tommy ', 'Sipes', '2274 Deerfield 3', NULL, 'Maiden ', 'NC', '29750', 'US', '8282925157', '[email protected]', '', 'c', '', '1', NULL, 1586964885, '', 0, '', '', '', '', '', '', '', '', 0, 'no', ''),
(157726, '013717d81e878e4328594103f75bf5ba', 'Brianna', 'Tilden', 'Brianna', 'Tilden', '9301 e cardinal pl', NULL, 'midwest city', 'OK', '73130', 'US', NULL, '', '9301 e cardinal pl', NULL, 'midwest city', 'OK', '73130', 'US', '4055148011', '[email protected]', '', 'c', '', '0', NULL, 1586964976, '', 0, '', '1652014349', '', '', '', '', '', '', 0, 'no', ''),
(157727, '9344cd4c019342aa0c62fba3b13d993e', 'Julie', 'Gosselin', 'Julie', 'Gosselin', '64 Root Rd', NULL, 'Somers', 'CT', '06071', 'US', 'Julie', 'Gosselin', '64 Root Rd', NULL, 'Somers', 'CT', '06071', 'US', '8607630021', '[email protected]', '', 'c', '', '1', NULL, 1586965024, '', 0, '', '1651888417', '', '', '', '', '', '', 0, 'no', ''),
(157728, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[email protected]', '', 'c', '', '0', NULL, 1586965138, '', 0, '', '', '', '', '', '', '', '', 0, 'no', ''),
(157729, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[email protected]', '', 'c', '', '0', NULL, 1586965312, '', 0, '', '', '', '', '', '', '', '', 0, 'no', ''),
(157730, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[email protected]', '', 'c', '', '0', NULL, 1586965831, '', 0, '', '', '', '', '', '', '', '', 0, 'no', ''),
(157731, '9a825196b0b01c39a91df7fb9f213d05', 'Amanda', 'Griffin', 'Amanda', 'Griffin', '127 East Pike Rd. Apt 4', NULL, 'Falkville', 'AL', '35622', 'US', 'Amanda', 'Griffin', '127 East Pike Rd. Apt 4', NULL, 'Falkville', 'AL', '35622', 'US', '2563873592', '[email protected]', '', 'c', '', '1', NULL, 1586966159, '', 0, '', '1651892860', '', '', '', '', '', '', 0, 'no', ''),

Download:

Hidden Content

You must register or login to view this content.