DBHunter
Infinity Member
Golden Member
- Joined
- August 23, 2025
- Messages
- 1,138
- Reaction score
- 1,439
- Points
- 113
- Thread Author
- #1
chiemtaimobile.vn
year: 2022
total rows: 1487k
users 143k
size: 1.58 GB
Code:
year: 2022
total rows: 1487k
users 143k
size: 1.58 GB
Code:
Code:
INSERT INTO `cscart_orders` (`order_id`, `is_parent_order`, `parent_order_id`, `company_id`, `issuer_id`, `user_id`, `total`, `subtotal`, `discount`, `subtotal_discount`, `payment_surcharge`, `shipping_ids`, `shipping_cost`, `timestamp`, `status`, `notes`, `details`, `promotions`, `promotion_ids`, `firstname`, `lastname`, `company`, `b_firstname`, `b_lastname`, `b_address`, `b_address_2`, `b_city`, `b_county`, `b_state`, `b_country`, `b_zipcode`, `b_phone`, `s_firstname`, `s_lastname`, `s_address`, `s_address_2`, `s_city`, `s_county`, `s_state`, `s_country`, `s_zipcode`, `s_phone`, `s_address_type`, `phone`, `fax`, `url`, `email`, `payment_id`, `tax_exempt`, `lang_code`, `ip_address`, `repaid`, `validation_code`, `localization_id`, `profile_id`, `storefront_id`, `vi_district_id`, `vi_ward_id`, `kiot_invoice_id`, `updated_at`) VALUES
13, 0, 3, '', 0, '', '1377184829', 'mehraz_133', 'mehraz_133', '433b42fc30073b3d25d734682642d389', 0, 0, 'mehrazasadi@gmail.com', 0, '', 1533796287, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'fa', '0.00', 0, '', 0, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 0, 0, 0, 1, 1, 1, 1, 230271, '13-mehraz_13.jpg', 3, 750, 750, '', '', '', 'iran/tehran/tehran', '', '', '', '', '', 'http://https://www.facebook.com/mehraz.asadi', '', '', '', 535753800, '9125275904', '', 'PBI', 0, 0, 0, 0, 0, '', '', '', 1, 0, 0, 'mehraz asadi', '', 1, NULL, 10, NULL, 0, 0, 0, '', 0, NULL, NULL, 4096, 0, 1, 0, 1, 1, 0, 1, 0, 0, 3, 'D d M, Y H:i:s', 1, 1, 1, 1, 0, 0, 2950, '37.137.44.130', 0, 0, 0, 2, '2', 'YES', 0, 0),
(14, 0, 3, '', 0, '', '1377187177', 'alme6974', 'alme6974', '6834dbcad282c1ef359957ddb7ab96a1', 0, 0, 'alme6974@me.com', 0, '', 1592230199, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'fa', '0.00', 0, '', 0, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 0, 0, 0, 1, 1, 1, 1, 230271, '14-alme6974.jpeg', 3, 640, 640, '', '', '', '//', 'alme6974', '', '', '', '', 'http://', '', '', '', 820441800, '9911208878', 'ایرانی', '', 0, 0, 0, 0, 0, '', '', '', 1, 0, 0, 'مهدی درخشان', '', 1, NULL, 10, NULL, 0, 0, 0, '', 0, NULL, NULL, 4096, 0, 0, 0, 1, 1, 0, 1, 0, 0, 3, 'D d M, Y H:i:s', 1, 1, 1, 1, 0, 0, 5812, '162.158.202.152', 0, 0, 0, 2, '2', 'YES', 0, 0),
(15, 0, 3, '', 0, '', '1377190280', 'pejman', 'pejman', '1247ca74d06624b5d78737d1103ef7cd', 0, 0, 'pejman6767@gmail.com', 0, '', 1398426787, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'fa', '0.00', 0, '', 0, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 0, 0, 0, 1, 0, 1, 1, 230271, '15-pejman.jpg', 3, 407, 440, '', '', '', '//', '', '', '', '', '', '', '', '', '', 600121800, '0', '', '', 0, 0, 0, 0, 0, '', '', '', 1, 0, 0, 'pejman taheri', '', 0, NULL, 10, NULL, 0, 0, 0, '', 0, NULL, NULL, 4096, 0, 0, 0, 1, 1, 0, 1, 0, 0, 3, 'D d M, Y H:i:s', 0, 0, 0, 1, 0, 0, 950, '188.245.77.232', 0, 0, 0, 2, '2', 'YES', 0, 0),
(16, 0, 3, '', 0, '', '1377191905', 'samangraphic', 'samangraphic', 'e10adc3949ba59abbe56e057f20f883e', 0, 0, 'saman_red2004@yahoo.com', 0, '', 1379786434, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'fa', '0.00', 0, '', 0, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 0, 0, 0, 1, 0, 1, 1, 230271, '16-samangraphic.jpg', 3, 500, 500, '', '', '', '//', '', '', '', '', '', '', '', '', '', -12600, '0', 'IRAN', '', 0, 0, 0, 0, 0, '', '', '', 1, 0, 0, 'saman bahari', '', 0, NULL, 10, NULL, 0, 0, 0, '', 0, NULL, NULL, 4096, 0, 1, 0, 1, 1, 0, 1, 0, 0, 3, 'D d M, Y H:i:s', 0, 0, 0, 1, 0, 0, 350, '91.99.21.140', 0, 0, 0, 2, '2', 'YES', 0, 0),
(17, 0, 3, '', 0, '', '1377192188', 'ARATAA', 'ARATAA', '31496a9dc9c08a6c1cf66fc5f932c477', 0, 0, 'maleky_12@yahoo.com', 0, '', 1522773840, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'fa', '0.00', 0, '', 0, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 0, 0, 0, 1, 0, 1, 1, 230271, '17-ARATAA.jpg', 3, 215, 304, '', '', '', 'ایران/کرمان/جیرفت', '', '', '', '', '', 'http://www.facebook.com/SEKTOR1987', '', '', 'لیسانس', 558995400, '0', '', '', 0, 0, 0, 0, 0, '', '', '', 1, 0, 0, 'محمدصادق مالکی', '', 0, NULL, 10, NULL, 0, 0, 0, '', 0, NULL, NULL, 4096, 0, 1, 0, 1, 1, 0, 1, 0, 0, 3, 'D d M, Y H:i:s', 0, 0, 0, 1, 0, 0, 850, '151.247.94.142', 0, 0, 0, 2, '2', 'YES', 0, 0),
(18, 0, 3, '', 0, '', '1377193622', 'Alpha2', 'Alpha2', 'cfe3e2ef2d3f8cecac3370609e95eaa9', 0, 0, 'designeralpha8@gmail.com', 0, '', 1504189197, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'fa', '0.00', 0, '', 0, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 0, 0, 0, 1, 0, 1, 1, 230271, '18-Alpha2.jpg', 3, 530, 530, '', '', '', 'ایران/خراسان رضوی/مشهد', '', '', '', '', '', 'http://', '', '', '', 748553400, '9151197448', '', 'Real Madrid', 0, 0, 0, 0, 0, '', '', '', 1, 0, 0, 'امیر ابراهیمی', '', 0, NULL, 10, NULL, 0, 0, 0, '', 0, NULL, NULL, 4096, 0, 1, 0, 1, 1, 0, 1, 0, 0, 3, 'D d M, Y H:i:s', 0, 0, 0, 1, 0, 0, 1658, '151.238.93.205', 0, 0, 0, 2, '2', 'YES', 0, 0),
(19, 0, 3, '', 0, '', '1377196424', 'omidmm', 'omidmm', '8643130df760f001932854a1f34b9d9f', 0, 0, 'omidmm16@yahoo.com', 0, '', 1378472485, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'fa', '0.00', 0, '', 0, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 0, 0, 0, 1, 0, 1, 1, 230271, '19-omidmm.jpg', 3, 640, 480, '', '', '', 'IRN/Kurdistan/Baneh city', '', '', '', '', '', 'http://www.progsoft.ir', 'Programmer', 'Football, Software engineer', 'daneshjoo computer', 691014600, '0', 'IRN', 'RMA, Juve , Liverpool', 0, 0, 0, 0, 0, '', '', '', 1, 0, 0, 'omid mm', '', 0, NULL, 10, NULL, 0, 0, 0, '', 0, NULL, NULL, 4096, 0, 1, 0, 1, 1, 0, 1, 0, 0, 3, 'D d M, Y H:i:s', 0, 0, 0, 1, 0, 0, 50, '2.182.242.145', 0, 0, 0, 2, '2', 'YES', 0, 0),
(13497, 1621610015, 'Nguyen Hung', '518/2/11 Vo Van Kiet, Cau Kho Ward, Q1', '0355976943', 0, 'Xiaomi raising the mini detectors xividids, supporting GPS navigation with degree with degree exactly 9 times higher, the price is only 355,000 VND ',' A ', 1478),
(13498, 1621610025, 'Le Khang', '22 Le Van Luong Ptan Phong District 7 ',' 0932723313 ', 0,' Xiaomi raising the fundraising of Xunkids mini detectors, supporting GPS positioning with 9 times more accuracy The time, the price is only 355,000 VND ',' A ', 1478),
(13499, 1621610027, 'Le Khang', '22 Le Van Luong Ptan Phong District 7 ',' 0932723313 ', 0,' Xiaomi raising the fundrais of Xunkids mini detectors, supporting GPS positioning with 9 times higher accuracy The time, the price is only 355,000 VND ',' A ', 1478),
(13500, 1621610280, 'Le Tuan Dat', '129, Street 11, Linh Xuan Ward, Thu Duc District, Ho Chi Minh City', '0816554148', 19826, '', 'D', 0),
(13574, 1621689404, 'Ngân', '160 nguyễn văn quỳ ,quận 7,hcm', '0929034754', 3296, '', 'D', 0),
(13575, 1621694895, 'Ms Tuyền', '159 Xa Lộ Hà Nội Thảo Điền Q2', '0944996117', 5131, '', 'D', 0),
(13576, 1621697001, 'Nguyen truong giang', '32/2 duong 3-2 phuong 1 thi xa cai lay tien gia g', '0385059079', 16132, '', 'D', 0),
INSERT INTO `cscart_repair_lookup` (`idlookup`, `receipt_date`, `date_auto`, `model`, `status`, `pending_status`, `imei`, `phone`, `status_review`, `price`, `staff`, `staff_receipt`, `customer`, `flow`, `delivery_date`, `time_add`, `created_by`, `time_modify`, `updated_by`, `idparent`, `trangthai`, `company_id`, `lang_code`, `id_address`) VALUES
(6, '2016-09-22 09:08:00', '2016-10-06 09:28:47', 'L-01f', 'Liệt cảm ứng, kg test, máy trày', 'C', '0', '0938636318', 'đã tiếp nhận: thay lcd', 1000000, '', 'châu', 'A Hải', 'kiều anh ', '0000-00-00 00:00:00', '2016-10-06 09:28:47', '66', '0000-00-00 00:00:00', '', 0, '', 0, '', ''),
(7, '2016-09-22 09:17:00', '2016-10-06 09:30:38', 'Lenovo P70-a', 'bể liệt cảm ứng, ko test chức năng, máy trầy', 'C', '78342', '0909544767', 'đã tiếp nhận: thay lcd', 750000, '', 'hân', 'Chú Liêm', 'thủy', '0000-00-00 00:00:00', '2016-10-06 09:30:38', '66', '0000-00-00 00:00:00', '', 0, '', 0, '', ''),
(8, '2016-09-22 09:18:00', '2016-10-06 09:36:13', 'Iphone 5 trắng ', 'Bể kính, sim ghép, máy trày, máy kén sạc, có icloud', 'C', '95293', '0', 'đã tiếp nhận: thay kính+ sạc ', 450000, '', 'hân', 'Chú Ba', 'kiều anh ', '0000-00-00 00:00:00', '2016-10-06 09:36:13', '66', '0000-00-00 00:00:00', '', 0, '', 0, '', ''),
(9, '2016-09-22 09:24:00', '2016-10-06 09:37:45', 'Iphone 5s 16gb', 'sọc mh, có icloud, máy trầy', 'C', '83035', '0901395540', 'đã tiếp nhận: thay lcd', 650000, '', 'hân', 'A Cường ', 'thủy', '0000-00-00 00:00:00', '2016-10-06 09:37:45', '66', '0000-00-00 00:00:00', '', 0, '', 0, '', ''),
(10, '2016-09-22 09:25:00', '2016-10-06 09:42:03', 'Sony Z3 ', 'mất nguồn, ko test, máy trầy', 'C', '78619', '0938518993', 'đã tiếp nhận: thay lcd', 1200000, '', 'châu', 'A Minh', 'kiều anh ', '0000-00-00 00:00:00', '2016-10-06 09:42:03', '66', '0000-00-00 00:00:00', '', 0, '', 0, '', ''),
(11, '2016-09-22 09:30:00', '2016-10-06 09:43:50', 'A1-811', 'bể, liệt cảm ứng, kg test', 'C', '0', '0909195833', 'đã tiếp nhận: thay lcd', 700000, '', 'hân', 'A Đức', 'kiều anh ', '0000-00-00 00:00:00', '2016-10-06 09:43:50', '66', '0000-00-00 00:00:00', '', 0, '', 0, '', ''),