- Joined
- Jun 14, 2024
- Messages
- 2,590
- Reaction score
- 22,400
- 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', 'kvasu1980@gmail.com', 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', 'ch.jayalakshmi925@gmail.com', 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', 'littyanoob18@gmail.com', 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', 'garlapatihamsika@gmail.com', 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', 'n.ashwini.ash@gmail.com', 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', 'Vijideva86@gmail.com', 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', 'paddypillai@gmail.com', 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', 'maneesharao99121@gmail.com', 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', 'vasu75107@gmail.com', 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', 'alikantisushitha@gmail.com', 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', 'manjusrimamidi22@gmail.com', 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', 'nandiniakella9@gmail.com', 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', 'usha2345@yahoo.com', 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', 'kishanchaitanyasandra@gmail.com', 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>bhask6@gmail.com</EmailId><MobileNo>9704823305</MobileNo><UserName>apiuser@sieliteclub.com</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>pentyalaranjith@gmail.com</EmailId><MobileNo>9177441789</MobileNo><UserName>apiuser@sieliteclub.com</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>apiuser@sieliteclub.com</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>pentyalaranjith@gmail.com</EmailId><MobileNo>9177441789</MobileNo><UserName>apiuser@sieliteclub.com</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>bhask6@gmail.com</EmailId><MobileNo>9704823305</MobileNo><UserName>apiuser@sieliteclub.com</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>bodamounika84@gmail.com</EmailId><MobileNo>9642224428</MobileNo><UserName>apiuser@sieliteclub.com</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>apiuser@sieliteclub.com</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>apiuser@sieliteclub.com</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'),