Jun 26, 2023, 07:40 PM
Website - ezlive.biz
Format - .SQL
Size sql file - 4GB
Date - 2023
All Rows - 18kk
SAMPLE
Format - .SQL
Size sql file - 4GB
Date - 2023
All Rows - 18kk
INSERT INTO `payment_transactions` (`id`, `country_id`, `order_id`, `customer_id`, `payment_method_id`, `reference_no`, `payment_gateway_identifier`, `provider`, `request_id`, `transaction_id`, `unique_id`, `auth_code`, `order_amount`, `received_amount`, `credit_card_name`, `credit_card_no`, `credit_card_bank`, `credit_card_country`, `status`, `remarks`, `data`, `created_at`, `updated_at`) VALUES
INSERT INTO `orders` (`id`, `country_id`, `page_id`, `user_id`, `subscriber_id`, `customer_id`, `campaign_id`, `payment_method_id`, `payment_collected_by`, `delivery_address_id`, `courier_id`, `shipping_option_id`, `pickup_branch_id`, `pickup_time`, `order_no_running_no`, `order_no`, `invoice_no_running_no`, `invoice_no`, `invoice_barcode`, `unique_id`, `delivery_method`, `payment_method`, `payment_type`, `order_amount`, `shipping_amount`, `outstanding_shipping_amount`, `total_amount`, `paid_amount`, `total_product_items_weight`, `delivery_status`, `payment_status`, `status`, `force_recheck_out`, `delivery_tracking_no`, `remarks`, `internal_remarks`, `payment_remarks`, `invoice_print_count`, `delivery_order_print_count`, `data`, `prepared_by`, `prepared_at`, `notified_at`, `ready_delivery_at`, `delivered_at`, `pickup_date`, `payment_at`, `attempt_payment_at`, `confirmed_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
INSERT INTO `customers` (`id`, `country_id`, `page_id`, `membership_tier`, `user_id`, `subscriber_id`, `fb_user_id`, `fb_name`, `full_name`, `gender`, `contact_no`, `email`, `dob`, `address_1`, `address_2`, `postcode`, `city`, `state`, `note`, `blacklisted_at`, `created_at`, `updated_at`, `deleted_at`) VALUESSAMPLE
(303376, 127, 612203, 302264, NULL, 'VW00000344', '[email protected]', 'payex', '6399607149f1c', NULL, '30337646131', NULL, '399.00', '0.00', NULL, NULL, NULL, NULL, 'pending', NULL, '{\"language\":\"en\"}', 1670996062, 1670996081),
(303377, 127, 612203, 302264, NULL, 'VW00000344', '[email protected]', 'payex', '639960843e464', 'PX1075601ab7c81068b8', '30337718828', '00', '399.00', '399.00', NULL, NULL, NULL, NULL, 'success', NULL, '{\"language\":\"en\",\"amount\":\"399.00\",\"currency\":\"MYR\",\"customer_name\":\"Chin Pey Shan\",\"description\":\"Dec Custom Order\",\"reference_number\":\"VW00000344\",\"mandate_reference_number\":null,\"payment_intent\":\"b83e8aa2f0034acfa66e5a407955363f\",\"collection_id\":null,\"invoice_id\":null,\"txn_id\":\"PX1075601ab7c81068b8\",\"external_txn_id\":\"2212141335180001\",\"response\":\"Approved\",\"auth_code\":\"00\",\"auth_number\":\"2348726513\",\"txn_date\":\"20221214133518\",\"fpx_mode\":\"01\",\"fpx_buyer_name\":\"PRISCILLA CHIN PEY SHAN\",\"fpx_buyer_bank_id\":\"HLB0224\",\"fpx_buyer_bank_name\":\"Hong Leong Bank\",\"card_holder_name\":null,\"card_number\":null,\"card_expiry\":null,\"card_brand\":null,\"card_on_file\":null,\"signature\":\"b7573f6f3ddf045cb43386a9b9e46edb3733a29ba1b2e7ee858c323654e673c4005cdb94baeb64b167a8685c28ece26bc17dbe85cdb4357206693c9c87568fad\",\"txn_type\":\"FPX\",\"nonce\":\"639960843e464\",\"metadata\":\"{}\"}', 1670996082, 1670996175),
(303378, 127, 612162, 302289, NULL, 'JJ00008588', '[email protected]', 'payex', '639960eab2124', 'PX10652014c429a9f3a8', '30337836692', '1B', '409.00', '0.00', NULL, NULL, NULL, NULL, 'fail', 'Buyer Failed To Provide The Necessary Info To Login To Internet Banking Login Page', '{\"language\":\"zh\",\"amount\":\"409\",\"currency\":\"MYR\",\"customer_name\":\"Janet YN Wong\",\"description\":\"1\\u6708 8\\u53f7-1\\u670814\\u53f7 \\u5168\\u9a6c\\u53d1\\u8d27(\\u8d76\\u65b0\\u5e74\\u524d\\u4f46\\u4e0d\\u4fdd\\u8bc1\\uff09\",\"reference_number\":\"JJ00008588\",\"mandate_reference_number\":null,\"payment_intent\":\"e36563b4a89a4d7d9da7382f0f8a34af\",\"collection_id\":null,\"invoice_id\":null,\"txn_id\":\"PX10652014c429a9f3a8\",\"external_txn_id\":\"2212141337440083\",\"response\":\"Transaction Pending\",\"auth_code\":\"09\",\"auth_number\":null,\"txn_date\":\"20221214133743\",\"fpx_mode\":\"02\",\"fpx_buyer_name\":null,\"fpx_buyer_bank_id\":\"PBB0233\",\"fpx_buyer_bank_name\":\"Public Bank PBe\",\"card_holder_name\":null,\"card_number\":null,\"card_expiry\":null,\"card_brand\":\"FPX\",\"card_on_file\":null,\"signature\":\"b4e7fbfbb35e9d718263e38e921224c1e6bb572f8d064092f052c843538dbdc90e826411d6b70b24f81ad7f5ef494d07715f1678f0fcd7388cc256d086d0ae3c\",\"txn_type\":\"FPX B2B\",\"nonce\":\"639960eab2124\",\"metadata\":\"{}\"}', 1670996184, 1671429607),
(303379, 127, 612204, 302280, NULL, 'JJ00008617', '[email protected]', 'payex', '639960eb552f2', NULL, '30337956627', NULL, '808.00', '0.00', NULL, NULL, NULL, NULL, 'pending', NULL, '{\"language\":\"zh\"}', 1670996185, 1670996203),
(303380, 127, 612164, 296516, NULL, 'JJ00008590', '[email protected]', 'payex', '639960f168691', 'PX106520152bd48b6b96', '30338030386', '00', '409.00', '409.00', NULL, NULL, NULL, NULL, 'success', NULL, '{\"language\":\"en\",\"amount\":\"409.00\",\"currency\":\"MYR\",\"customer_name\":\"Chriz Tina\",\"description\":\"1\\u6708 8\\u53f7-1\\u670814\\u53f7 \\u5168\\u9a6c\\u53d1\\u8d27(\\u8d76\\u65b0\\u5e74\\u524d\\u4f46\\u4e0d\\u4fdd\\u8bc1\\uff09\",\"reference_number\":\"JJ00008590\",\"mandate_reference_number\":null,\"payment_intent\":\"6909a391cc774b63a5aa827f009c66d9\",\"collection_id\":null,\"invoice_id\":null,\"txn_id\":\"PX106520152bd48b6b96\",\"external_txn_id\":\"2212141337030432\",\"response\":\"Approved\",\"auth_code\":\"00\",\"auth_number\":\"EB20-02044\",\"txn_date\":\"20221214133703\",\"fpx_mode\":\"01\",\"fpx_buyer_name\":\"CHRISTINA LIM\",\"fpx_buyer_bank_id\":\"HSBC0223\",\"fpx_buyer_bank_name\":\"HSBC Bank\",\"card_holder_name\":null,\"card_number\":null,\"card_expiry\":null,\"card_brand\":null,\"card_on_file\":null,\"signature\":\"2c0d1d3ce6a676bd1c6f8df29bef3386aa4cc692addec2a2e96a843bbb526d56a4feb9f3b3ae7f2ec6cfd167bf5ef66aa0aac70fb1b5b98cd7c4de6a6236708c\",\"txn_type\":\"FPX\",\"nonce\":\"639960f168691\",\"metadata\":\"{}\"}', 1670996192, 1670996342),
(303381, 127, 612204, 302280, NULL, 'JJ00008617', '[email protected]', 'payex', '639960fd48edb', 'PX10652019b1166e8e1a', '30338190590', '00', '808.00', '808.00', NULL, NULL, NULL, NULL, 'success', NULL, '{\"language\":\"zh\",\"amount\":\"808.00\",\"currency\":\"MYR\",\"customer_name\":\"Eoh Fong Ming\",\"description\":\"1\\u6708 8\\u53f7-1\\u670814\\u53f7 \\u5168\\u9a6c\\u53d1\\u8d27(\\u8d76\\u65b0\\u5e74\\u524d\\u4f46\\u4e0d\\u4fdd\\u8bc1\\uff09\",\"reference_number\":\"JJ00008617\",\"mandate_reference_number\":null,\"payment_intent\":\"52bbef334c0b466d9a1b993dca448db4\",\"collection_id\":\"T2K2Hmt2\",\"invoice_id\":null,\"txn_id\":\"PX10652019b1166e8e1a\",\"external_txn_id\":\"2212141337160924\",\"response\":\"Approved\",\"auth_code\":\"00\",\"auth_number\":\"8877194429\",\"txn_date\":\"20221214133716\",\"fpx_mode\":\"01\",\"fpx_buyer_name\":\"EOH FONG MING @ AU YONG FONG M\",\"fpx_buyer_bank_id\":\"PBB0233\",\"fpx_buyer_bank_name\":\"Public Bank PBe\",\"card_holder_name\":null,\"card_number\":null,\"card_expiry\":null,\"card_brand\":null,\"card_on_file\":null,\"signature\":\"ec091797f176e3e84546fc8ba943d8f692da57913b4617f9931b8e14c15ad1c0014c770b378e1b10bade8d2d6be83b47587f6efd08aece77d6351eed6a3a6bd4\",\"txn_type\":\"FPX\",\"nonce\":\"639960fd48edb\",\"metadata\":\"{}\"}', 1670996203, 1670996311),
(303382, 127, 612205, 67150, NULL, 'CD00020650', '[email protected]', 'payex', '6399610751bbf', NULL, '30338269783', NULL, '314.00', '0.00', NULL, NULL, NULL, NULL, 'pending', NULL, '{\"language\":\"en\"}', 1670996213, 1670996231),
(303383, 127, 612205, 67150, NULL, 'CD00020650', '[email protected]', 'payex', '639961190cf29', 'PX1046801595b2d18540', '30338311835', '00', '314.00', '314.00', NULL, NULL, NULL, NULL, 'success', NULL, '{\"language\":\"en\",\"amount\":\"314\",\"currency\":\"MYR\",\"customer_name\":\"Candy Lee\",\"description\":\"13\\/12\\/22 Wooden Chair\",\"reference_number\":\"CD00020650\",\"mandate_reference_number\":null,\"payment_intent\":\"0cce3123616049f38612b84cb8bb431c\",\"collection_id\":null,\"invoice_id\":null,\"txn_id\":\"PX1046801595b2d18540\",\"external_txn_id\":\"1025fa0b13ec4fe9baff2ae404eed2e0\",\"response\":\"success\",\"auth_code\":\"00\",\"auth_number\":null,\"txn_date\":\"20221214133819\",\"fpx_mode\":null,\"fpx_buyer_name\":null,\"fpx_buyer_bank_id\":null,\"fpx_buyer_bank_name\":null,\"card_holder_name\":null,\"card_number\":null,\"card_expiry\":null,\"card_brand\":\"N.A.\",\"card_on_file\":null,\"signature\":\"ed9bb913972ca93e7e89513b4ee923b649c89cb89bd35b42f0ade06056867b5c8f8593fbb55ff5ffca1df995efa3e43444e09ea78f514669d7bd26290878579e\",\"txn_type\":\"GrabPay\",\"nonce\":\"639961190cf29\",\"metadata\":\"{}\"}', 1670996231, 1670996342),
(303384, 127, 612206, 302161, NULL, 'CD00020651', '[email protected]', 'payex', '6399614343958', NULL, '30338482671', NULL, '393.00', '0.00', NULL, NULL, NULL, NULL, 'pending', NULL, '{\"language\":\"en\"}', 1670996273, 1670996291),
(303385, 127, 612206, 302161, NULL, 'CD00020651', '[email protected]', 'payex', '63996155f1a7f', 'PX10468010de3c4021b9', '30338549521', '00', '393.00', '393.00', NULL, NULL, NULL, NULL, 'success', NULL, '{\"language\":\"en\",\"amount\":\"393\",\"currency\":\"MYR\",\"customer_name\":\"JoanNe Tan\",\"description\":\"13\\/12\\/22 Wooden Chair\",\"reference_number\":\"CD00020651\",\"mandate_reference_number\":null,\"payment_intent\":\"1b279872a4c94d2c9b48b93ed1391fea\",\"collection_id\":null,\"invoice_id\":null,\"txn_id\":\"PX10468010de3c4021b9\",\"external_txn_id\":\"95f1b2aa2a654bfdacfd99376a66394b\",\"response\":\"success\",\"auth_code\":\"00\",\"auth_number\":null,\"txn_date\":\"20221214133931\",\"fpx_mode\":null,\"fpx_buyer_name\":null,\"fpx_buyer_bank_id\":null,\"fpx_buyer_bank_name\":null,\"card_holder_name\":null,\"card_number\":null,\"card_expiry\":null,\"card_brand\":\"N.A.\",\"card_on_file\":null,\"signature\":\"87e0c25d62fb60c76754deb4767a078b75c3a20f39e9828fb6db8615d6b51c0d5eac37f9502c8f4b65bba955d3506b609caa5255b2a1b8614843a6233ddcc9e7\",\"txn_type\":\"GrabPay\",\"nonce\":\"63996155f1a7f\",\"metadata\":\"{}\"}', 1670996291, 1670996392),
(303386, 127, 611616, 282749, NULL, 'JJ00008520', '[email protected]', 'payex', '63996180b7e8b', 'PX106520121392550331', '30338643436', '00', '270.00', '270.00', NULL, NULL, NULL, NULL, 'success', NULL, '{\"language\":\"zh\",\"amount\":\"270.00\",\"currency\":\"MYR\",\"customer_name\":\"JonJon Neo\",\"description\":\"1\\u6708 8\\u53f7-1\\u670814\\u53f7 \\u5168\\u9a6c\\u53d1\\u8d27(\\u8d76\\u65b0\\u5e74\\u524d\\u4f46\\u4e0d\\u4fdd\\u8bc1\\uff09\",\"reference_number\":\"JJ00008520\",\"mandate_reference_number\":null,\"payment_intent\":\"3ba738944c59442a8321273533b1cded\",\"collection_id\":null,\"invoice_id\":null,\"txn_id\":\"PX106520121392550331\",\"external_txn_id\":\"2212141340260789\",\"response\":\"Approved\",\"auth_code\":\"00\",\"auth_number\":\"2348727591\",\"txn_date\":\"20221214134026\",\"fpx_mode\":\"01\",\"fpx_buyer_name\":\"JEANETTE ONG\",\"fpx_buyer_bank_id\":\"HLB0224\",\"fpx_buyer_bank_name\":\"Hong Leong Bank\",\"card_holder_name\":null,\"card_number\":null,\"card_expiry\":null,\"card_brand\":null,\"card_on_file\":null,\"signature\":\"9e476e4784ff96d4fab3a59e402243eeb9991e81ed456d77867a91e8db6f75ab02ce448adf0ab05b946b6b0ef37c8f5313e4709bd82808395fcf458792a6f11b\",\"txn_type\":\"FPX\",\"nonce\":\"63996180b7e8b\",\"metadata\":\"{}\"}', 1670996334, 1670996598),
(303387, 127, 612173, 296676, NULL, 'JJ00008599', '[email protected]', 'payex', '639961ef543a4', NULL, '3033878318', NULL, '409.00', '0.00', NULL, NULL, NULL, NULL, 'pending', NULL, '{\"language\":\"zh\"}', 1670996445, 1670996463),
(303388, 127, 612173, 296676, NULL, 'JJ00008599', '[email protected]', 'payex', '639961f2a3401', NULL, '303388555', NULL, '409.00', '0.00', NULL, NULL, NULL, NULL, 'pending', NULL, '{\"language\":\"zh\"}', 1670996448, 1670996466),
(329510, 127, 167, 0, 167, 180082, 11025, NULL, NULL, NULL, NULL, 148, 152, NULL, 646, 'BBK00000646', 634, 'BBKINV00000634', NULL, '32951058689', 'self_pickup', 'online_transfer', NULL, '226.00', '0.00', NULL, '216.00', '216.00', '0.00', 'delivered', 'paid', 'completed', 0, NULL, NULL, NULL, NULL, 1, 0, '{\"payment_receipts\":[{\"filename\":\"61cee5adcd536.jpg\",\"timestamp\":1640949165}]}', NULL, NULL, NULL, NULL, 1641483996, NULL, 1640949179, NULL, 1640949005, 1640948999, 1655941986, NULL),
(329511, 127, 167, 0, 167, 180082, 11025, NULL, NULL, NULL, NULL, 148, 152, NULL, 647, 'BBK00000647', 635, 'BBKINV00000635', NULL, '32951161977', 'self_pickup', 'online_transfer', NULL, '226.00', '0.00', NULL, '216.00', '216.00', '0.00', 'delivered', 'paid', 'completed', 0, NULL, NULL, NULL, NULL, 1, 0, '{\"payment_receipts\":[{\"filename\":\"61cee5866cf7f.jpg\",\"timestamp\":1640949126}]}', NULL, NULL, NULL, NULL, 1641123371, NULL, 1640949181, NULL, 1640949029, 1640949023, 1655941986, NULL),
(329512, 127, 72, 0, 72, 185348, 11120, NULL, NULL, 112743, 6, 63, NULL, NULL, 52019, 'MPL00052019', 46182, 'MPLO00046182', NULL, '32951247206', 'courier', 'online_transfer', NULL, '99.00', '35.00', NULL, '134.00', '134.00', '0.10', 'delivered', 'paid', 'completed', 0, 'MY37072656000', NULL, '987谢谢 XN 3/1', NULL, 1, 0, '{\"payment_receipts\":[{\"filename\":\"61cefe98df01a.jpg\",\"timestamp\":1640955545}]}', NULL, NULL, NULL, NULL, 1642318253, NULL, 1641191034, NULL, 1640949093, 1640949027, 1655941515, NULL),
(329513, 127, 167, 0, 167, 180082, 11025, NULL, NULL, NULL, NULL, 148, 152, NULL, 648, 'BBK00000648', 636, 'BBKINV00000636', NULL, '32951364553', 'self_pickup', 'online_transfer', NULL, '172.80', '0.00', NULL, '162.80', '162.80', '2.70', 'delivered', 'paid', 'completed', 0, NULL, NULL, NULL, NULL, 1, 0, '{\"payment_receipts\":[{\"filename\":\"61cee596e7181.jpg\",\"timestamp\":1640949143}]}', NULL, NULL, NULL, NULL, 1641123357, NULL, 1640949184, NULL, 1640949043, 1640949038, 1655941986, NULL),
(329514, 127, 91, 0, 91, 137005, 10973, NULL, NULL, NULL, NULL, 81, 50, NULL, 8942, 'TB00008942', 7362, 'INV00007362', NULL, '32951456863', 'self_pickup', 'online_transfer', NULL, '146.30', '0.00', NULL, '146.30', '146.30', '6.00', 'delivered', 'paid', 'completed', 0, NULL, NULL, NULL, NULL, 0, 0, '{\"payment_receipts\":[{\"filename\":\"61d1938cb7f95.jpg\",\"timestamp\":1641124749}]}', NULL, NULL, NULL, NULL, 1641176485, NULL, 1641176353, NULL, 1641124859, 1640949536, 1655941602, NULL),
(329515, 127, 97, 0, 97, 41108, 11099, NULL, NULL, NULL, NULL, 84, 87, NULL, 43166, 'FB00043166', 40277, 'INV00040277', NULL, '32951531447', 'self_pickup', 'online_transfer', NULL, '14.00', '0.00', NULL, '14.00', '14.00', '0.00', 'pending', 'paid', 'confirmed', 0, NULL, NULL, NULL, NULL, 2, 1, '{\"payment_receipts\":[{\"filename\":\"61cee87f0e9b9.jpg\",\"timestamp\":1640949887}]}', NULL, NULL, NULL, NULL, NULL, NULL, 1641028538, NULL, 1640949876, 1640949629, 1655941688, NULL),
(329516, 127, 129, 11932, 129, 98477, 11119, NULL, NULL, 112744, 8, 110, NULL, NULL, 11110, 'HA00011110', 9989, 'INV00009989', NULL, '32951673714', 'courier', 'online_transfer', NULL, '64.50', '9.00', NULL, '73.50', '73.50', '2.00', 'delivered', 'paid', 'completed', 0, '630567218809', NULL, NULL, NULL, 1, 0, '{\"payment_receipts\":{\"1\":{\"filename\":\"61d0360740dd6.png\",\"timestamp\":1641035271},\"2\":{\"filename\":\"61d0362fc923f.png\",\"timestamp\":1641035312}}}', NULL, NULL, NULL, NULL, 1641116632, NULL, 1641098725, NULL, 1641035035, 1640949658, 1655941801, NULL),
(329517, 127, 129, 4292, 129, 175524, 11119, NULL, NULL, 112745, 8, 110, NULL, NULL, 11111, 'HA00011111', 9990, 'INV00009990', NULL, '32951723487', 'courier', 'online_transfer', NULL, '117.00', '12.00', NULL, '129.00', '129.00', '3.50', 'delivered', 'paid', 'completed', 0, '630567219765', NULL, NULL, NULL, 1, 0, '{\"payment_receipts\":[{\"filename\":\"61cee96ba9508.png\",\"timestamp\":1640950124}]}', NULL, NULL, NULL, NULL, 1641116737, NULL, 1641098728, NULL, 1640949976, 1640949900, 1655941801, NULL),
(329518, 127, 34, 0, 34, 110364, 11127, NULL, NULL, 74802, 8, 442, NULL, NULL, 29631, 'EZ00029631', 29523, 'CB00029523', NULL, '32951868103', 'courier', 'online_payment', 'payex', '376.00', '0.00', NULL, '376.00', '376.00', '2.00', 'delivered', 'paid', 'completed', 0, '630572959193', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 1641539798, NULL, 1640950123, 1640950006, 1640950004, 1640949981, 1655941042, NULL),
(329519, 127, 34, 0, 34, 134089, 11129, NULL, NULL, 80432, 8, 443, NULL, NULL, 29632, 'EZ00029632', 29524, 'CB00029524', NULL, '32951911650', 'courier', 'online_payment', 'payex', '99.00', '15.00', NULL, '114.00', '114.00', '1.00', 'delivered', 'paid', 'completed', 0, '630570624141', NULL, NULL, NULL, 3, 0, NULL, NULL, NULL, NULL, NULL, 1641362341, NULL, 1640950233, 1640950115, 1640950113, 1640950108, 1655941042, NULL),
(312756, 127, 152, NULL, 0, 152, '8861843953886761', 'Onnie Annie', 'Onnie Annie', 'female', '+60135409342', '[email protected]', '1985-03-06', 'Sk. Batu Tiningkang', '', '89908', 'Tenom', '35', NULL, NULL, 1678172510, 1678191942, NULL),
(312757, 127, 213, NULL, 0, 214, '9467756996571346', 'Chloe Cy', 'Chloe Cy', 'female', '+60123923411', '[email protected]', '1986-08-15', 'No. 22 Jalan Brp 6/9a,Bukit Rahman Putra Seksyen U20', '', '47000', 'Sungai buloh', '37', NULL, NULL, 1678172697, 1681966920, NULL),
(312758, 127, 213, NULL, 0, 214, '5931400753608524', 'Jacklyn Tan', 'Jacklyn Tan', 'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1678172697, 1678172697, NULL),
(312759, 127, 152, NULL, 0, 152, '5967021590011957', 'Nani Dhuhaa', 'Nani Dhuhaa', 'female', '+601110962397', '[email protected]', '1979-12-05', 'Lot 1080 kg seligi', '', '16800', 'pasir puteh', '28', NULL, NULL, 1678172735, 1680839050, NULL),
(312760, 127, 213, NULL, 0, 214, '5872546689507137', 'Taffy Law', 'Taffy Law', 'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1678172973, 1678172973, NULL),
(312761, 127, 152, NULL, 0, 152, '8857130457690720', 'Harniza Hamid', 'Harniza Hamid', 'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1678173227, 1678173227, NULL),
(312762, 127, 152, NULL, 0, 152, '6080143718690418', 'Olyzai Latiff', 'Olyzai Latiff', 'female', '+60109169572', '[email protected]', '1980-02-13', '39J Jalan damai 1\nKampung Sri damai\nBatu 7 Jalan gambang', '', '25150', 'Kuantan', '31', NULL, NULL, 1678173234, 1678196761, NULL),
(312763, 127, 213, NULL, 0, 214, '6047338625351802', 'Yee Sann', 'Yee Sann', 'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1678173373, 1678173373, NULL),
(312764, 127, 213, NULL, 0, 214, '6199084446781742', 'Esther Sim', 'Esther Sim', 'female', '+60168869812', '[email protected]', '1984-04-22', 'Dynamic Linkage Logistics S/B, Parcel Lot A208, Lvl 2, Blk A, ICOM Square, Jln Pending', '', '93450', 'Kuching', '36', NULL, NULL, 1678173398, 1679187697, NULL),
(312765, 127, 152, NULL, 0, 152, '5926562177380214', 'Nurakma Zalia Ismail', 'Nurakma Zalia Ismail', 'female', '+60169443262', '[email protected]', '1995-10-25', '34 kmpung parit che ha,manir', '', '21200', 'Kuala terengganu', '38', NULL, NULL, 1678173427, 1679968039, NULL),
(312766, 127, 213, NULL, 0, 214, '2314734768619520', 'Kiky Teoh', 'Kiky Teoh', 'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1678173437, 1678173437, NULL),
(312767, 127, 213, NULL, 0, 214, '6321979591169071', 'Chuii Ying', 'Chuii Ying', 'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1678173675, 1678173675, NULL),
(312768, 127, 213, NULL, 0, 214, '6438817496138181', 'PM Yeop', 'PM Yeop', 'female', '+60125723498', '[email protected]', '1981-04-28', 'No.16, Lorong 4, Taman Mulia', '', '8000', 'Sungai Petani', '27', NULL, NULL, 1678173819, 1679673075, NULL),
(312769, 127, 213, NULL, 0, 214, '6521260207907530', 'Sammie Chu', 'Sammie Chu', 'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1678173891, 1678173891, NULL),
(312770, 127, 152, NULL, 0, 152, '3100665236695982', 'Mala Erul', 'Mala Erul', 'female', '+60136676489', '[email protected]', '2023-10-14', 'tkt 4-01 kuarters polis ipd tampin', '', '73000', 'tampin', '30', NULL, NULL, 1678173894, 1678252612, NULL),
(312771, 127, 213, NULL, 0, 214, '5464648766995934', 'Candy Kong', 'Candy Kong', 'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1678173966, 1678173966, NULL),
(312772, 127, 152, NULL, 0, 152, '3608648942569564', 'Rosnita Selaman', 'Rosnita Selaman', 'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1678174091, 1678174091, NULL),
(312773, 127, 152, NULL, 0, 152, '6382651858432488', 'Hasana Pengantin Hasana', 'Hasana Pengantin Hasana', 'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1678174400, 1678174400, NULL),