{ "rc": 0, "msg": "success", "data": [ { "id": "162", "username": "Fung Ka Kea", "phone": "63300085", "live_area": "", "other_live_area": "", "origin": "2021\u9ad4\u6aa2\u5ba2\u6236", "address": "", "promotion": "", "statement": "1", "remark": "", "created": "2022-10-01 14:31:40" }, { "id": "161", "username": "Test 2 Julian", "phone": "91908632", "live_area": "", "other_live_area": "", "origin": "\u5c1a\u91ab\u67032022", "address": "", "promotion": "", "statement": "1", "remark": "", "created": "2022-09-26 08:22:03", "children": [ { "id": "161", "username": "Test 2 Julian", "phone": "91908632", "live_area": "", "other_live_area": "", "origin": "\u5c1a\u91ab\u67032022", "address": "", "promotion": "", "statement": "1", "remark": "", "created": "2022-09-26 08:22:03" }, { "id": "160", "username": "TestJulian", "phone": "91908632", "live_area": "", "other_live_area": "", "origin": "\u5c1a\u91ab\u67032022", "address": "", "promotion": "", "statement": "1", "remark": "", "created": "2022-09-25 14:29:06" }, { "id": "159", "username": "Test Julian", "phone": "91908632", "live_area": "", "other_live_area": "", "origin": "2021\u9ad4\u6aa2\u5ba2\u6236", "address": "", "promotion": "", "statement": "1", "remark": "", "created": "2022-09-25 14:21:32" }, { "id": "158", "username": "Wong Julian", "phone": "91908632", "live_area": "", "other_live_area": "", "origin": "\u5c1a\u91ab\u67032022", "address": "", "promotion": "", "statement": "1", "remark": "", "created": "2022-09-23 11:28:41" }, { "id": "157", "username": "Julian Wong", "phone": "91908632", "live_area": "", "other_live_area": "", "origin": "\u5c1a\u91ab\u67032022", "address": "", "promotion": "", "statement": "1", "remark": "", "created": "2022-09-23 11:26:43" }, { "id": "149", "username": "\u9ec3\u9e92\u5c55", "phone": "91908632", "live_area": "", "other_live_area": "", "origin": "CWB\u63a8\u5ee3", "address": "", "promotion": "\u9aa8\u8cea\u5bc6\u5ea6\u8d85\u8072\u6ce2\u6aa2\u67e5", "statement": "1", "remark": "", "created": "2022-09-02 13:34:04" }, { "id": "148", "username": "\u9ec3\u9e92\u5c55", "phone": "91908632", "live_area": "", "other_live_area": "", "origin": "CWB\u63a8\u5ee3", "address": "", "promotion": "\u81bd\u56fa\u9187\u6aa2\u67e5", "statement": "1", "remark": "", "created": "2022-09-02 13:33:49" }, { "id": "147", "username": "Julian Wong", "phone": "91908632", "live_area": "", "other_live_area": "", "origin": "CWB\u63a8\u5ee3", "address": "", "promotion": "\u5fc3\u8840\u7ba1\u786c\u5316\u6aa2\u67e5", "statement": "1", "remark": "", "created": "2022-09-02 13:33:29" }, { "id": "146", "username": "Julian Wong", "phone": "91908632", "live_area": "", "other_live_area": "", "origin": "CWB\u63a8\u5ee3", "address": "", "promotion": "200\u5143\u9ad4\u6aa2\u8a08\u5283\u73fe\u91d1\u5238", "statement": "1", "remark": "", "created": "2022-09-02 13:33:14" }, { "id": "49", "username": "Julian Wong", "phone": "91908632", "live_area": "", "other_live_area": "", "origin": "\u5f8c\u75ab\u60c5\u63a8\u5ee3", "address": "", "promotion": "", "statement": "1", "remark": "", "created": "2022-07-13 09:58:42" } ] }, { "id": "156", "username": "\u9673\u82ac", "phone": "62408324", "live_area": "", "other_live_area": "", "origin": "CWB\u63a8\u5ee3", "address": "", "promotion": "\u9aa8\u8cea\u5bc6\u5ea6\u8d85\u8072\u6ce2\u6aa2\u67e5", "statement": "1", "remark": "", "created": "2022-09-22 19:47:17" }, { "id": "154", "username": "\u9ea5\u9d3b\u83ef", "phone": "60136347", "live_area": "", "other_live_area": "", "origin": "CWB\u63a8\u5ee3", "address": "", "promotion": "\u5fc3\u8840\u7ba1\u786c\u5316\u6aa2\u67e5", "statement": "1", "remark": "", "created": "2022-09-12 11:17:43" }, { "id": "153", "username": "\u5f35\u5c0f\u7434", "phone": "54997890", "live_area": "", "other_live_area": "", "origin": "CWB\u63a8\u5ee3", "address": "", "promotion": "200\u5143\u9ad4\u6aa2\u8a08\u5283\u73fe\u91d1\u5238", "statement": "1", "remark": "", "created": "2022-09-11 13:12:35" }, { "id": "152", "username": "\u5289\u9e97\u73e0", "phone": "98270380", "live_area": "", "other_live_area": "", "origin": "CWB\u63a8\u5ee3", "address": "", "promotion": "\u9aa8\u8cea\u5bc6\u5ea6\u8d85\u8072\u6ce2\u6aa2\u67e5", "statement": "1", "remark": "", "created": "2022-09-10 16:46:34" }, { "id": "151", "username": "Ho miss", "phone": "69932987", "live_area": "", "other_live_area": "", "origin": "CWB\u63a8\u5ee3", "address": "", "promotion": "\u5fc3\u8840\u7ba1\u786c\u5316\u6aa2\u67e5", "statement": "1", "remark": "", "created": "2022-09-10 11:33:44" }, { "id": "150", "username": "Fung Test", "phone": "21582148", "live_area": "", "other_live_area": "", "origin": "CWB\u63a8\u5ee3", "address": "", "promotion": "200\u5143\u9ad4\u6aa2\u8a08\u5283\u73fe\u91d1\u5238", "statement": "1", "remark": "", "created": "2022-09-08 17:53:06" }, { "id": "142", "username": "\u5eb7\u4e1a", "phone": "91408686", "live_area": "", "other_live_area": "", "origin": "\u5f8c\u75ab\u60c5\u63a8\u5ee3", "address": "", "promotion": "", "statement": "1", "remark": "\u5ba2\u4eba\u4ee5\u70ba\u4fc2CT\u503c\u6aa2\u6e2c, \u5df2\u9810\u7d04\u5230LCK\u505aCT\u503c40\u6aa2\u6e2c\n", "created": "2022-08-25 22:08:11" }, { "id": "141", "username": "Ms Ng", "phone": "55829804", "live_area": "", "other_live_area": "", "origin": "\u5f8c\u75ab\u60c5\u63a8\u5ee3", "address": "", "promotion": "", "statement": "1", "remark": "no whatsapp", "created": "2022-08-24 23:56:24" } ], "debug": "SELECT * FROM `orm_promote_reg` where id in (SELECT max(id) FROM `orm_promote_reg` where (username like '{4704fec9bf5608a2c261163e1fcfe322dcac2219c16f968e2e52e29619d3764c}{4704fec9bf5608a2c261163e1fcfe322dcac2219c16f968e2e52e29619d3764c}' or phone like '{4704fec9bf5608a2c261163e1fcfe322dcac2219c16f968e2e52e29619d3764c}{4704fec9bf5608a2c261163e1fcfe322dcac2219c16f968e2e52e29619d3764c}') and origin like '{4704fec9bf5608a2c261163e1fcfe322dcac2219c16f968e2e52e29619d3764c}{4704fec9bf5608a2c261163e1fcfe322dcac2219c16f968e2e52e29619d3764c}' group by phone) order by created desc limit 0,10", "count": 130 }