{
    "rc": 0,
    "msg": "success",
    "data": [
        {
            "id": "542",
            "username": "Ronny Tang ",
            "phone": "90901965",
            "live_area": "",
            "other_live_area": "",
            "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
            "address": "",
            "promotion": "",
            "extra": {
                "real_booking_date": "22\/01\/2025",
                "booking_time": "10:00-11:00",
                "booking_address": "\u9285\u947c\u7063\u670d\u52d9\u4e2d\u5fc3",
                "vaccine_number": "2 \u4f4d"
            },
            "statement": "1",
            "gender": "",
            "age_range": "",
            "remark": "Kelley",
            "created": "2025-01-17 21:31:00"
        },
        {
            "id": "541",
            "username": "Chan Ching Yi",
            "phone": "92591936",
            "live_area": "",
            "other_live_area": "",
            "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
            "address": "",
            "promotion": "",
            "extra": {
                "real_booking_date": "20\/01\/2025",
                "booking_time": "16:00-17:00",
                "booking_address": "\u9285\u947c\u7063\u670d\u52d9\u4e2d\u5fc3",
                "vaccine_number": "1 \u4f4d"
            },
            "statement": "1",
            "gender": "",
            "age_range": "",
            "remark": "Kelley",
            "created": "2025-01-17 18:09:09"
        },
        {
            "id": "540",
            "username": "Foo Wing Ming Stephen ",
            "phone": "92228919",
            "live_area": "",
            "other_live_area": "",
            "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
            "address": "",
            "promotion": "",
            "extra": {
                "real_booking_date": "18\/01\/2025",
                "booking_time": "15:00-16:00",
                "booking_address": "\u8354\u679d\u89d2\u670d\u52d9\u4e2d\u5fc3",
                "vaccine_number": "1 \u4f4d"
            },
            "statement": "1",
            "gender": "",
            "age_range": "",
            "remark": "Kelley\n\u9810\u7d04\u65e5\u671f: 18\/01\/2025 \u661f\u671f\u516d\n\u9810\u7d04\u6642\u9593: 16:00\nLCK",
            "created": "2025-01-17 17:56:42"
        },
        {
            "id": "539",
            "username": "\u738b\u5a77",
            "phone": "67910811",
            "live_area": "",
            "other_live_area": "",
            "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
            "address": "",
            "promotion": "",
            "extra": {
                "real_booking_date": "17\/01\/2025",
                "booking_time": "11:00-12:00",
                "booking_address": "\u9285\u947c\u7063\u670d\u52d9\u4e2d\u5fc3",
                "vaccine_number": "1 \u4f4d"
            },
            "statement": "1",
            "gender": "",
            "age_range": "",
            "remark": "Kelley",
            "created": "2025-01-16 17:26:38"
        },
        {
            "id": "538",
            "username": "TEST",
            "phone": "21582148",
            "live_area": "",
            "other_live_area": "",
            "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
            "address": "",
            "promotion": "",
            "extra": {
                "real_booking_date": "17\/01\/2025",
                "booking_time": "10:00-11:00",
                "booking_address": "\u8584\u6276\u6797\u670d\u52d9\u4e2d\u5fc3",
                "vaccine_number": "1 \u4f4d"
            },
            "statement": "1",
            "gender": "",
            "age_range": "",
            "remark": "",
            "created": "2025-01-14 18:32:06",
            "children": [
                {
                    "id": "538",
                    "username": "TEST",
                    "phone": "21582148",
                    "live_area": "",
                    "other_live_area": "",
                    "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
                    "address": "",
                    "promotion": "",
                    "extra": "{\"real_booking_date\":\"17\\\/01\\\/2025\",\"booking_time\":\"10:00-11:00\",\"booking_address\":\"\\u8584\\u6276\\u6797\\u670d\\u52d9\\u4e2d\\u5fc3\",\"vaccine_number\":\"1 \\u4f4d\"}",
                    "statement": "1",
                    "gender": "",
                    "age_range": "",
                    "remark": "",
                    "created": "2025-01-14 18:32:06"
                },
                {
                    "id": "268",
                    "username": "Test Fung",
                    "phone": "21582148",
                    "live_area": "",
                    "other_live_area": "",
                    "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
                    "address": "",
                    "promotion": "",
                    "extra": "{\"real_booking_date\":\"12\\\/12\\\/2023\",\"booking_time\":\"09:00-10:00\",\"booking_address\":\"\\u8584\\u6276\\u6797\\u670d\\u52d9\\u4e2d\\u5fc3\",\"vaccine_number\":\"1 \\u4f4d\"}",
                    "statement": "1",
                    "gender": "",
                    "age_range": "",
                    "remark": "N\/A",
                    "created": "2023-12-11 18:09:06"
                }
            ]
        },
        {
            "id": "537",
            "username": "LO Wai Wah Ken",
            "phone": "94351031",
            "live_area": "",
            "other_live_area": "",
            "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
            "address": "",
            "promotion": "",
            "extra": {
                "real_booking_date": "15\/01\/2025",
                "booking_time": "16:00-17:00",
                "booking_address": "\u8354\u679d\u89d2\u670d\u52d9\u4e2d\u5fc3",
                "vaccine_number": "1 \u4f4d"
            },
            "statement": "1",
            "gender": "",
            "age_range": "",
            "remark": "Kelley\n\u9810\u7d04\u65e5\u671f: 15\/01\/2025 \u661f\u671f\u4e09\n\u9810\u7d04\u6642\u9593: 16:00\nLCK",
            "created": "2025-01-14 17:40:05",
            "children": [
                {
                    "id": "537",
                    "username": "LO Wai Wah Ken",
                    "phone": "94351031",
                    "live_area": "",
                    "other_live_area": "",
                    "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
                    "address": "",
                    "promotion": "",
                    "extra": "{\"real_booking_date\":\"15\\\/01\\\/2025\",\"booking_time\":\"16:00-17:00\",\"booking_address\":\"\\u8354\\u679d\\u89d2\\u670d\\u52d9\\u4e2d\\u5fc3\",\"vaccine_number\":\"1 \\u4f4d\"}",
                    "statement": "1",
                    "gender": "",
                    "age_range": "",
                    "remark": "Kelley\n\u9810\u7d04\u65e5\u671f: 15\/01\/2025 \u661f\u671f\u4e09\n\u9810\u7d04\u6642\u9593: 16:00\nLCK",
                    "created": "2025-01-14 17:40:05"
                },
                {
                    "id": "253",
                    "username": "LO Wai Wah Ken",
                    "phone": "94351031",
                    "live_area": "",
                    "other_live_area": "",
                    "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
                    "address": "",
                    "promotion": "",
                    "extra": "{\"real_booking_date\":\"22\\\/11\\\/2023\",\"booking_time\":\"14:00-15:00\",\"booking_address\":\"\\u8354\\u679d\\u89d2\\u670d\\u52d9\\u4e2d\\u5fc3\",\"vaccine_number\":\"1 \\u4f4d\"}",
                    "statement": "1",
                    "gender": "",
                    "age_range": "",
                    "remark": "attended",
                    "created": "2023-11-22 09:35:29"
                }
            ]
        },
        {
            "id": "536",
            "username": "\u4e18\u570b\u5049",
            "phone": "92790323",
            "live_area": "",
            "other_live_area": "",
            "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
            "address": "",
            "promotion": "",
            "extra": {
                "real_booking_date": "16\/01\/2025",
                "booking_time": "13:00-14:00",
                "booking_address": "\u9285\u947c\u7063\u670d\u52d9\u4e2d\u5fc3",
                "vaccine_number": "1 \u4f4d"
            },
            "statement": "1",
            "gender": "",
            "age_range": "",
            "remark": "Kelley\n\u9810\u7d04\u65e5\u671f: 16\/01\/2025 \u661f\u671f\u56db\n\u9810\u7d04\u6642\u9593: 12:00nn\nCWB",
            "created": "2025-01-13 18:20:45",
            "children": [
                {
                    "id": "536",
                    "username": "\u4e18\u570b\u5049",
                    "phone": "92790323",
                    "live_area": "",
                    "other_live_area": "",
                    "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
                    "address": "",
                    "promotion": "",
                    "extra": "{\"real_booking_date\":\"16\\\/01\\\/2025\",\"booking_time\":\"13:00-14:00\",\"booking_address\":\"\\u9285\\u947c\\u7063\\u670d\\u52d9\\u4e2d\\u5fc3\",\"vaccine_number\":\"1 \\u4f4d\"}",
                    "statement": "1",
                    "gender": "",
                    "age_range": "",
                    "remark": "Kelley\n\u9810\u7d04\u65e5\u671f: 16\/01\/2025 \u661f\u671f\u56db\n\u9810\u7d04\u6642\u9593: 12:00nn\nCWB",
                    "created": "2025-01-13 18:20:45"
                },
                {
                    "id": "535",
                    "username": "\u4e18\u570b\u5049",
                    "phone": "92790323",
                    "live_area": "",
                    "other_live_area": "",
                    "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
                    "address": "",
                    "promotion": "",
                    "extra": "{\"real_booking_date\":\"16\\\/01\\\/2025\",\"booking_time\":\"12:00-13:00\",\"booking_address\":\"\\u9285\\u947c\\u7063\\u670d\\u52d9\\u4e2d\\u5fc3\",\"vaccine_number\":\"1 \\u4f4d\"}",
                    "statement": "1",
                    "gender": "",
                    "age_range": "",
                    "remark": "",
                    "created": "2025-01-13 18:14:21"
                }
            ]
        },
        {
            "id": "534",
            "username": "FOONG YING OI",
            "phone": "55437233",
            "live_area": "",
            "other_live_area": "",
            "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
            "address": "",
            "promotion": "",
            "extra": {
                "real_booking_date": "16\/01\/2025",
                "booking_time": "12:00-13:00",
                "booking_address": "\u9285\u947c\u7063\u670d\u52d9\u4e2d\u5fc3",
                "vaccine_number": "1 \u4f4d"
            },
            "statement": "1",
            "gender": "",
            "age_range": "",
            "remark": "Kelley\n\u9810\u7d04\u65e5\u671f: 16\/01\/2025 \u661f\u671f\u56db\n\u9810\u7d04\u6642\u9593: 12:30pm\nCWB",
            "created": "2025-01-13 12:47:48",
            "children": [
                {
                    "id": "534",
                    "username": "FOONG YING OI",
                    "phone": "55437233",
                    "live_area": "",
                    "other_live_area": "",
                    "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
                    "address": "",
                    "promotion": "",
                    "extra": "{\"real_booking_date\":\"16\\\/01\\\/2025\",\"booking_time\":\"12:00-13:00\",\"booking_address\":\"\\u9285\\u947c\\u7063\\u670d\\u52d9\\u4e2d\\u5fc3\",\"vaccine_number\":\"1 \\u4f4d\"}",
                    "statement": "1",
                    "gender": "",
                    "age_range": "",
                    "remark": "Kelley\n\u9810\u7d04\u65e5\u671f: 16\/01\/2025 \u661f\u671f\u56db\n\u9810\u7d04\u6642\u9593: 12:30pm\nCWB",
                    "created": "2025-01-13 12:47:48"
                },
                {
                    "id": "493",
                    "username": "\u674e\u9054\u5149",
                    "phone": "55437233",
                    "live_area": "",
                    "other_live_area": "",
                    "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
                    "address": "",
                    "promotion": "",
                    "extra": "{\"real_booking_date\":\"31\\\/12\\\/2024\",\"booking_time\":\"12:00-13:00\",\"booking_address\":\"\\u9285\\u947c\\u7063\\u670d\\u52d9\\u4e2d\\u5fc3\",\"vaccine_number\":\"1 \\u4f4d\"}",
                    "statement": "1",
                    "gender": "",
                    "age_range": "",
                    "remark": "Julius\n\u9810\u7d04\u65e5\u671f: 31\/12\/2024 \u661f\u671f\u4e8c\n\u9810\u7d04\u6642\u9593: 12:40pm\nCWB",
                    "created": "2024-12-30 11:28:21"
                },
                {
                    "id": "492",
                    "username": "Li Tat Kwong",
                    "phone": "55437233",
                    "live_area": "",
                    "other_live_area": "",
                    "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
                    "address": "",
                    "promotion": "",
                    "extra": "{\"real_booking_date\":\"31\\\/12\\\/2024\",\"booking_time\":\"12:00-13:00\",\"booking_address\":\"\\u9285\\u947c\\u7063\\u670d\\u52d9\\u4e2d\\u5fc3\",\"vaccine_number\":\"1 \\u4f4d\"}",
                    "statement": "1",
                    "gender": "",
                    "age_range": "",
                    "remark": "",
                    "created": "2024-12-30 10:04:56"
                }
            ]
        },
        {
            "id": "533",
            "username": "\u8cc0\u8ce2\u4fca",
            "phone": "92383223",
            "live_area": "",
            "other_live_area": "",
            "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
            "address": "",
            "promotion": "",
            "extra": {
                "real_booking_date": "13\/01\/2025",
                "booking_time": "11:00-12:00",
                "booking_address": "\u9285\u947c\u7063\u670d\u52d9\u4e2d\u5fc3",
                "vaccine_number": "2 \u4f4d"
            },
            "statement": "1",
            "gender": "",
            "age_range": "",
            "remark": "Kelley",
            "created": "2025-01-12 22:09:10"
        },
        {
            "id": "532",
            "username": "\u674e\u6625\u79c0",
            "phone": "95365256",
            "live_area": "",
            "other_live_area": "",
            "origin": "\u6d41\u611f\u75ab\u82d7\u63a5\u7a2e\u670d\u52d9",
            "address": "",
            "promotion": "",
            "extra": {
                "real_booking_date": "16\/01\/2025",
                "booking_time": "15:00-16:00",
                "booking_address": "\u8584\u6276\u6797\u670d\u52d9\u4e2d\u5fc3",
                "vaccine_number": "1 \u4f4d"
            },
            "statement": "1",
            "gender": "",
            "age_range": "",
            "remark": "Kelley",
            "created": "2025-01-12 14:40:45"
        }
    ],
    "debug": "SELECT * FROM `orm_promote_reg` where id in (SELECT max(id) FROM `orm_promote_reg` where (username like '{17b241f0197f800c504f41c743da6866e822e528e2747f4ea5ef94120da82a73}{17b241f0197f800c504f41c743da6866e822e528e2747f4ea5ef94120da82a73}'  or phone like '{17b241f0197f800c504f41c743da6866e822e528e2747f4ea5ef94120da82a73}{17b241f0197f800c504f41c743da6866e822e528e2747f4ea5ef94120da82a73}') and origin like '{17b241f0197f800c504f41c743da6866e822e528e2747f4ea5ef94120da82a73}{17b241f0197f800c504f41c743da6866e822e528e2747f4ea5ef94120da82a73}' group by phone) order by created desc limit 0,10",
    "count": 415
}