- Joined
- Jun 14, 2024
- Messages
- 2,617
- Reaction score
- 31,618
- Points
- 113
- Thread Author
- #1
southindiaeshop.com
southindiaeshop.com
Format - .SQL
Date - 2024
All Rows - 5kk
About 19k phone/users
Website - southindiaeshop.com
Code:
INSERT INTO `customer_grid_flat`
(`entity_id`,
`name`,
`email`,
`group_id`,
`created_at`,
`website_id`,
`confirmation`,
`created_in`,
`dob`,
`gender`,
`taxvat`,
`lock_expires`,
`shipping_full`,
`billing_full`,
`billing_firstname`,
`billing_lastname`,
`billing_telephone`,
`billing_postcode`,
`billing_country_id`,
`billing_region`,
`billing_region_id`,
`billing_street`,
`billing_city`,
`billing_fax`,
`billing_vat_id`,
`billing_company`) VALUES
Code:
(13053, 'Vasundhara K', '[email protected]', 1, '2020-10-04 06:40:02', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, 'B110, Keerthi Rivera Apt, 6th G Cross\nKaggadasapura, CV Raman Nagar\nLakeView Road Bangalore Karnataka 560093', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13054, 'Jaya Lakshmi', '[email protected]', 1, '2020-10-04 07:33:01', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, '3-17-2, gandhi nagar,ramanthapur,Hyderabad- 500013\nHyderabad Hyderabad Telangana 500013', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13055, 'Litty Anoob', '[email protected]', 1, '2020-10-04 07:52:21', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, 'Kaleekal veedu\nChenkulam po\nOyoor Oyoor Kerala 691510', 'Kaleekal veedu\nChenkulam po\nOyoor Oyoor Kerala 691510', 'Litty', 'Anoob', '8304886163', '691510', 'IN', 'Kerala', 550, 'Kaleekal veedu\nChenkulam po\nOyoor', 'Oyoor', NULL, NULL, NULL),
(13056, 'G.satyanarayana Reddy', '[email protected]', 1, '2020-10-04 09:22:58', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, 'Bharathnagar\nNewbusstand\nH.no.29 Ieeja Telangana 509127', 'Bharathnagar\nNewbusstand\nH.no.29 Ieeja Telangana 509127', 'G.satyanarayana', 'Reddy', '9701656662', '509127', 'IN', 'Telangana', 564, 'Bharathnagar\nNewbusstand\nH.no.29', 'Ieeja', NULL, NULL, NULL),
(13057, 'Ashwini N', '[email protected]', 1, '2020-10-04 09:27:17', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, 'House no 318, Mahaveer rich apartment\n11th main, agb layout\nBENGALURU Bangalore Karnataka 560090', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13058, 'Srinivassa Devarajan', '[email protected]', 1, '2020-10-04 10:47:40', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13059, 'Padmaparna Bhadra', '[email protected]', 1, '2020-10-04 11:43:04', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, 'Janhvi Enclave Apartments E818 Korichikanahalli\nJanhvi Enclave Apartments E818 Korichikanahalli\nJanhvi Enclave Apartments E818 Korichikanahalli Bangalore Karnataka 560076', 'Janhvi Enclave Apartments E818 Korichikanahalli\nJanhvi Enclave Apartments E818 Korichikanahalli\nJanhvi Enclave Apartments E818 Korichikanahalli Bangalore Karnataka 560076', 'Padmaparna', 'Bhadra', '98300 30073', '560076', 'IN', 'Karnataka', 549, 'Janhvi Enclave Apartments E818 Korichikanahalli\nJanhvi Enclave Apartments E818 Korichikanahalli\nJanhvi Enclave Apartments E818 Korichikanahalli', 'Bangalore', NULL, NULL, NULL),
(13060, 'Maneesha Meneni', '[email protected]', 1, '2020-10-04 11:53:49', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13061, 'Vasavi Vasu', '[email protected]', 1, '2020-10-04 12:09:40', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13062, 'Sushitha Alikanti', '[email protected]', 1, '2020-10-04 12:52:47', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, 'H.No:10-06-183/13, Raparthi Nagar-2\nNear Gowri Shankar Clinic\nKhammam Khammam Telangana 507002', 'H.No:10-06-183/13, Raparthi Nagar-2\nNear Gowri Shankar Clinic\nKhammam Khammam Telangana 507002', 'Sushitha', 'Alikanti', '8374601214', '507002', 'IN', 'Telangana', 564, 'H.No:10-06-183/13, Raparthi Nagar-2\nNear Gowri Shankar Clinic\nKhammam', 'Khammam', NULL, NULL, NULL),
(13063, 'Manju PALAKURTHI', '[email protected]', 1, '2020-10-04 14:17:18', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13064, 'Nandini Akella', '[email protected]', 1, '2020-10-04 14:20:55', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, 'G-5 Sri hema durga classic\nOpp SR estates\nCine town road, miyapur Hyderabad Telangana 500049', 'G-5 Sri hema durga classic\nOpp SR estates\nCine town road, miyapur Hyderabad Telangana 500049', 'Nandini', 'Akella', '8074326072', '500049', 'IN', 'Telangana', 564, 'G-5 Sri hema durga classic\nOpp SR estates\nCine town road, miyapur', 'Hyderabad', NULL, NULL, NULL),
(13065, 'Usha Sankala', '[email protected]', 1, '2020-10-04 14:27:38', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13066, 'Kishan Sandra', '[email protected]', 1, '2020-10-04 15:03:20', 1, NULL, 'Default Store View', NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), INSERT INTO `tenovia_ezlogs_ezlogs` (`ezlogs_id`, `api_url`, `request`, `response`, `date`) VALUES (34189, 'http://lpaaswebapi.easyrewardz.com/api/RegisterEasyAccount', '<Request><SecurityToken>w7WH/WQpKKGs5k4IlxZt9zKZFlCNBzCS/FCLM3KtxnQA3Y9B1DAciJCV+DSqOnExqnKWDqIQ3A2wxAJ8roK6XHT69UoiPT/0SOeWWUTJVrka0/xP1zHyW4dcAYBLJDDXpggmL1AhEHnJJCpp8GQYziHWe7OJn0P8jhzzd8RSBoFSkvl7mBiCTzDqQzUVhsSZ</SecurityToken><FirstName>V B R </FirstName><LastName>777</LastName><DateOfBirth>01 Jan 1970</DateOfBirth><EasyId>9704823305</EasyId><EmailId>[email protected]</EmailId><MobileNo>9704823305</MobileNo><UserName>[email protected]</UserName><Gender>Female</Gender><StoreCode>Webstore</StoreCode><ChannelCode>Online</ChannelCode><CustomerTypeCode>Loyalty</CustomerTypeCode><CountryCode>91</CountryCode></Request>', '<Response>\r\n <ReturnCode>0</ReturnCode>\r\n <SmsStatus>0</SmsStatus>\r\n <EmailStatus>0</EmailStatus>\r\n <TPEnrollStatus>0</TPEnrollStatus>\r\n <EREnrollStatus>0</EREnrollStatus>\r\n <ProgramStatus>0</ProgramStatus>\r\n <MemberShipNumber></MemberShipNumber>\r\n <BonusPoints>0</BonusPoints>\r\n <CCIPoints>0</CCIPoints>\r\n <ReturnMessage>Success.</ReturnMessage>\r\n <OTP></OTP>\r\n <EnrollStatus>1</EnrollStatus>\r\n <ProfileStatus>-1</ProfileStatus>\r\n <LoginStatus>1</LoginStatus>\r\n <UpdateProfileFlagSet>true</UpdateProfileFlagSet>\r\n</Response>', '2020-01-30 16:26:32'),
(34190, 'http://lpaaswebapi.easyrewardz.com/api/RegisterEasyAccount', '<Request><SecurityToken>w7WH/WQpKKGs5k4IlxZt9zKZFlCNBzCS/FCLM3KtxnQA3Y9B1DAciJCV+DSqOnExqnKWDqIQ3A2wxAJ8roK6XHT69UoiPT/0SOeWWUTJVrka0/xP1zHyW4dcAYBLJDDXpggmL1AhEHnJJCpp8GQYziHWe7OJn0P8jhzzd8RSBoFSkvl7mBiCTzDqQzUVhsSZ</SecurityToken><FirstName>Pentyala</FirstName><LastName>Ranjith</LastName><DateOfBirth>01 Jan 1970</DateOfBirth><EasyId>9177441789</EasyId><EmailId>[email protected]</EmailId><MobileNo>9177441789</MobileNo><UserName>[email protected]</UserName><Gender>Female</Gender><StoreCode>Webstore</StoreCode><ChannelCode>Online</ChannelCode><CustomerTypeCode>Loyalty</CustomerTypeCode><CountryCode>91</CountryCode></Request>', '<Response>\r\n <ReturnCode>0</ReturnCode>\r\n <SmsStatus>0</SmsStatus>\r\n <EmailStatus>0</EmailStatus>\r\n <TPEnrollStatus>0</TPEnrollStatus>\r\n <EREnrollStatus>0</EREnrollStatus>\r\n <ProgramStatus>0</ProgramStatus>\r\n <MemberShipNumber></MemberShipNumber>\r\n <BonusPoints>0</BonusPoints>\r\n <CCIPoints>0</CCIPoints>\r\n <ReturnMessage>Success.</ReturnMessage>\r\n <OTP></OTP>\r\n <EnrollStatus>1</EnrollStatus>\r\n <ProfileStatus>-1</ProfileStatus>\r\n <LoginStatus>0</LoginStatus>\r\n <UpdateProfileFlagSet>false</UpdateProfileFlagSet>\r\n</Response>', '2020-01-30 16:32:03'),
(34191, 'http://lpaaswebapi.easyrewardz.com/api/CheckForEasyPointsRedemption', '<Request><SecurityToken>w7WH/WQpKKGs5k4IlxZt9zKZFlCNBzCS/FCLM3KtxnQA3Y9B1DAciJCV+DSqOnExqnKWDqIQ3A2wxAJ8roK6XHT69UoiPT/0SOeWWUTJVrka0/xP1zHyW4dcAYBLJDDXpggmL1AhEHnJJCpp8GQYziHWe7OJn0P8jhzzd8RSBoFSkvl7mBiCTzDqQzUVhsSZ</SecurityToken><StoreCode>Webstore</StoreCode><UserName>[email protected]</UserName><EasyId>9704823305</EasyId><TransactionCode>26530</TransactionCode><EasyPoints>1078</EasyPoints><LapseEndDate></LapseEndDate><TransactionDescription>Order Placed on South India Website with Bill Value 429.8200</TransactionDescription><RedemptionDate>30 Jan 2020</RedemptionDate><Amount>429.8200</Amount><RedemptionType>PD</RedemptionType><ActivityCode>Redemption</ActivityCode><Activities></Activities><CountryCode>91</CountryCode></Request>', '<Response>\r\n <ReturnCode>0</ReturnCode>\r\n <EasyPoints>860</EasyPoints>\r\n <CashWorthPoints>429.8200</CashWorthPoints>\r\n <BalanceToPay>0</BalanceToPay>\r\n <BillAmountPoints>860</BillAmountPoints>\r\n <IsPointsPlusCash>true</IsPointsPlusCash>\r\n <ReturnMessage>Success.</ReturnMessage>\r\n <Vouchers></Vouchers>\r\n <BillNo>26530</BillNo>\r\n <IsRedeemWithOutOTP>false</IsRedeemWithOutOTP>\r\n</Response>', '2020-01-30 16:36:21'),
(34192, 'http://lpaaswebapi.easyrewardz.com/api/RegisterEasyAccount', '<Request><SecurityToken>w7WH/WQpKKGs5k4IlxZt9zKZFlCNBzCS/FCLM3KtxnQA3Y9B1DAciJCV+DSqOnExqnKWDqIQ3A2wxAJ8roK6XHT69UoiPT/0SOeWWUTJVrka0/xP1zHyW4dcAYBLJDDXpggmL1AhEHnJJCpp8GQYziHWe7OJn0P8jhzzd8RSBoFSkvl7mBiCTzDqQzUVhsSZ</SecurityToken><FirstName>Pentyala</FirstName><LastName>Ranjith</LastName><DateOfBirth>01 Jan 1970</DateOfBirth><EasyId>9177441789</EasyId><EmailId>[email protected]</EmailId><MobileNo>9177441789</MobileNo><UserName>[email protected]</UserName><Gender>Female</Gender><StoreCode>Webstore</StoreCode><ChannelCode>Online</ChannelCode><CustomerTypeCode>Loyalty</CustomerTypeCode><CountryCode>91</CountryCode></Request>', '<Response>\r\n <ReturnCode>0</ReturnCode>\r\n <SmsStatus>0</SmsStatus>\r\n <EmailStatus>0</EmailStatus>\r\n <TPEnrollStatus>0</TPEnrollStatus>\r\n <EREnrollStatus>0</EREnrollStatus>\r\n <ProgramStatus>0</ProgramStatus>\r\n <MemberShipNumber></MemberShipNumber>\r\n <BonusPoints>0</BonusPoints>\r\n <CCIPoints>0</CCIPoints>\r\n <ReturnMessage>Success.</ReturnMessage>\r\n <OTP></OTP>\r\n <EnrollStatus>1</EnrollStatus>\r\n <ProfileStatus>-1</ProfileStatus>\r\n <LoginStatus>0</LoginStatus>\r\n <UpdateProfileFlagSet>false</UpdateProfileFlagSet>\r\n</Response>', '2020-01-30 16:36:23'),
(34193, 'http://lpaaswebapi.easyrewardz.com/api/RegisterEasyAccount', '<Request><SecurityToken>w7WH/WQpKKGs5k4IlxZt9zKZFlCNBzCS/FCLM3KtxnQA3Y9B1DAciJCV+DSqOnExqnKWDqIQ3A2wxAJ8roK6XHT69UoiPT/0SOeWWUTJVrka0/xP1zHyW4dcAYBLJDDXpggmL1AhEHnJJCpp8GQYziHWe7OJn0P8jhzzd8RSBoFSkvl7mBiCTzDqQzUVhsSZ</SecurityToken><FirstName>V B R</FirstName><LastName>777</LastName><DateOfBirth>01 Jan 1970</DateOfBirth><EasyId>9704823305</EasyId><EmailId>[email protected]</EmailId><MobileNo>9704823305</MobileNo><UserName>[email protected]</UserName><Gender>Female</Gender><StoreCode>Webstore</StoreCode><ChannelCode>Online</ChannelCode><CustomerTypeCode>Loyalty</CustomerTypeCode><CountryCode>91</CountryCode></Request>', '<Response>\r\n <ReturnCode>0</ReturnCode>\r\n <SmsStatus>0</SmsStatus>\r\n <EmailStatus>0</EmailStatus>\r\n <TPEnrollStatus>0</TPEnrollStatus>\r\n <EREnrollStatus>0</EREnrollStatus>\r\n <ProgramStatus>0</ProgramStatus>\r\n <MemberShipNumber></MemberShipNumber>\r\n <BonusPoints>0</BonusPoints>\r\n <CCIPoints>0</CCIPoints>\r\n <ReturnMessage>Success.</ReturnMessage>\r\n <OTP></OTP>\r\n <EnrollStatus>1</EnrollStatus>\r\n <ProfileStatus>-1</ProfileStatus>\r\n <LoginStatus>1</LoginStatus>\r\n <UpdateProfileFlagSet>false</UpdateProfileFlagSet>\r\n</Response>', '2020-01-30 16:58:29'),
(34194, 'http://lpaaswebapi.easyrewardz.com/api/RegisterEasyAccount', '<Request><SecurityToken>w7WH/WQpKKGs5k4IlxZt9zKZFlCNBzCS/FCLM3KtxnQA3Y9B1DAciJCV+DSqOnExqnKWDqIQ3A2wxAJ8roK6XHT69UoiPT/0SOeWWUTJVrka0/xP1zHyW4dcAYBLJDDXpggmL1AhEHnJJCpp8GQYziHWe7OJn0P8jhzzd8RSBoFSkvl7mBiCTzDqQzUVhsSZ</SecurityToken><FirstName>Mounika</FirstName><LastName>Boda</LastName><DateOfBirth>01 Jan 1970</DateOfBirth><EasyId>9642224428</EasyId><EmailId>[email protected]</EmailId><MobileNo>9642224428</MobileNo><UserName>[email protected]</UserName><Gender>Female</Gender><StoreCode>Webstore</StoreCode><ChannelCode>Online</ChannelCode><CustomerTypeCode>Loyalty</CustomerTypeCode><CountryCode>91</CountryCode></Request>', '<Response>\r\n <ReturnCode>0</ReturnCode>\r\n <SmsStatus>0</SmsStatus>\r\n <EmailStatus>0</EmailStatus>\r\n <TPEnrollStatus>0</TPEnrollStatus>\r\n <EREnrollStatus>0</EREnrollStatus>\r\n <ProgramStatus>0</ProgramStatus>\r\n <MemberShipNumber></MemberShipNumber>\r\n <BonusPoints>0</BonusPoints>\r\n <CCIPoints>0</CCIPoints>\r\n <ReturnMessage>Success.</ReturnMessage>\r\n <OTP></OTP>\r\n <EnrollStatus>1</EnrollStatus>\r\n <ProfileStatus>-1</ProfileStatus>\r\n <LoginStatus>0</LoginStatus>\r\n <UpdateProfileFlagSet>false</UpdateProfileFlagSet>\r\n</Response>', '2020-01-30 17:42:30'),
(34195, 'http://lpaaswebapi.easyrewardz.com/api/SearchMember', '<Request><SecurityToken>w7WH/WQpKKGs5k4IlxZt9zKZFlCNBzCS/FCLM3KtxnQA3Y9B1DAciJCV+DSqOnExqnKWDqIQ3A2wxAJ8roK6XHT69UoiPT/0SOeWWUTJVrka0/xP1zHyW4dcAYBLJDDXpggmL1AhEHnJJCpp8GQYziHWe7OJn0P8jhzzd8RSBoFSkvl7mBiCTzDqQzUVhsSZ</SecurityToken><EasyId>9553367888</EasyId><CountryCode>91</CountryCode></Request>', '<Response>\r\n <ReturnCode>172</ReturnCode>\r\n <ReturnMessage>No results found.</ReturnMessage>\r\n</Response>', '2020-01-30 18:02:26'),
(34196, 'http://lpaaswebapi.easyrewardz.com/api/GenerateOTP', '<Request><SecurityToken>w7WH/WQpKKGs5k4IlxZt9zKZFlCNBzCS/FCLM3KtxnQA3Y9B1DAciJCV+DSqOnExqnKWDqIQ3A2wxAJ8roK6XHT69UoiPT/0SOeWWUTJVrka0/xP1zHyW4dcAYBLJDDXpggmL1AhEHnJJCpp8GQYziHWe7OJn0P8jhzzd8RSBoFSkvl7mBiCTzDqQzUVhsSZ</SecurityToken><StoreCode>Webstore</StoreCode><UserName>[email protected]</UserName><MobileNumber>9553367888</MobileNumber><CountryCode>91</CountryCode></Request>', '<Response>\r\n <ReturnCode>0</ReturnCode>\r\n <RequestID>sieliteclub6563</RequestID>\r\n <ReturnMessage>Success</ReturnMessage>\r\n</Response>', '2020-01-30 18:02:34'),
(34197, 'http://lpaaswebapi.easyrewardz.com/api/ValidateOTP', '<Request><SecurityToken>w7WH/WQpKKGs5k4IlxZt9zKZFlCNBzCS/FCLM3KtxnQA3Y9B1DAciJCV+DSqOnExqnKWDqIQ3A2wxAJ8roK6XHT69UoiPT/0SOeWWUTJVrka0/xP1zHyW4dcAYBLJDDXpggmL1AhEHnJJCpp8GQYziHWe7OJn0P8jhzzd8RSBoFSkvl7mBiCTzDqQzUVhsSZ</SecurityToken><RequestID>sieliteclub6563</RequestID><UserName>[email protected]</UserName><MobileNumber>9553367888</MobileNumber><OTP>986456</OTP><CountryCode>91</CountryCode></Request>', '<Response>\r\n <ReturnCode>0</ReturnCode>\r\n <ReturnMessage>Success</ReturnMessage>\r\n</Response>', '2020-01-30 18:02:52'), INSERT INTO `customer_entity_varchar` (`value_id`, `attribute_id`, `entity_id`, `value`) VALUES (29, 139, 2, '9789448623'),
(2, 139, 3, '9845165710'),
(3, 139, 4, '7508610824'),
(21, 139, 21, '9900080420'),
(24, 139, 24, '8888000009'),
(31, 139, 25, '9884044011'),
(32, 139, 26, '7978784856'),
(35, 139, 29, '9884491228'),
(36, 139, 30, '7871584074'),
(37, 139, 31, '7891391223'),
(39, 139, 33, '9959178887'),
(40, 139, 34, '9000237749'),
(43, 139, 37, '9632624789'),