{"rc":0,"data":[{"id":"2433","title":"新型冠狀病毒核酸檢測登記表格","data":{"topic":"新型冠狀病毒核酸檢測登記表格","username":"Tambadoc terre merna","id_card":"P6513055B","gender":"F","real_birthday":"05\/04\/1992","userphone":"92276573","useremail":"","useraddress":"","userheight":"","userweight":"","q1":"","q2":"","q3":"","q4":"","q5":"","q6":"","q1_1":"","q1_2":"","q3_1":"","q5_7":"","referral_doctor":"Dr Lam Chi Kei","referral_agency":"","barcode":"","barcode_no":"B12101784730","real_sample_date":"25\/10\/2021","a1":"","sample_type":"6","sample_type_4":"","real_sample_time":"11:04","barcode_url":"","lab":"{\"report_no\":\"B12101784730\",\"real_report_date\":\"25\\\/10\\\/2021\",\"r1\":\"6\",\"r2\":\"2\",\"r1_4\":\"\",\"type\":\"type2\",\"real_lab_report_date\":\"25\\\/10\\\/2021\",\"real_report_time\":\"18:29\",\"real_lab_report_time\":\"11:20\"}","flag":"20211025002"},"status":"results ready","created":"2021-10-25 18:28:58","meta_value":"2","b_modified":"2021-10-25 18:29:23","url":"https:\/\/dnawecheck.com.hk\/registration-form-of-covid-19-rna-test-pdf?form_id=R99MznW1bdlu"},{"id":"2432","title":"新型冠狀病毒核酸檢測登記表格","data":{"topic":"新型冠狀病毒核酸檢測登記表格","username":"TABOR RUSSEL ENOFRE","id_card":"WX577792(3) ","gender":"F","real_birthday":"06\/11\/1990","userphone":"65395407","useremail":"","useraddress":"","userheight":"","userweight":"","q1":"","q2":"","q3":"","q4":"","q5":"","q6":"","q1_1":"","q1_2":"","q3_1":"","q5_7":"","referral_doctor":"Dr Lam Chi Kei","referral_agency":"","barcode":"","barcode_no":"A12101971237","real_sample_date":"25\/10\/2021","a1":"","sample_type":"1","sample_type_4":"","real_sample_time":"11:48","barcode_url":"","lab":"{\"report_no\":\"A12101971237\",\"real_report_date\":\"25\\\/10\\\/2021\",\"r1\":\"1\",\"r2\":\"2\",\"r1_4\":\"\",\"type\":\"type2\",\"real_lab_report_date\":\"25\\\/10\\\/2021\",\"real_report_time\":\"18:31\",\"real_lab_report_time\":\"01:17\"}","flag":"20211025001"},"status":"results ready","created":"2021-10-25 18:26:24","meta_value":"1","b_modified":"2021-10-25 18:27:17","url":"https:\/\/dnawecheck.com.hk\/registration-form-of-covid-19-rna-test-pdf?form_id=R99Mz3W+aN16"},{"id":"2431","title":"新型冠狀病毒核酸檢測登記表格","data":{"topic":"新型冠狀病毒核酸檢測登記表格","username":"Mak Ka Yee ","id_card":"Y467825(5)","gender":"F","real_birthday":"07\/08\/1995","userphone":"60993871","useremail":"","useraddress":"","userheight":"","userweight":"","q1":"","q2":"","q3":"","q4":"","q5":"","q6":"","q1_1":"","q1_2":"","q3_1":"","q5_7":"","referral_doctor":"Dr Lam Chi Kei","referral_agency":"","barcode":"","barcode_no":"B12101841108","real_sample_date":"06\/10\/2021","a1":"","sample_type":"5","sample_type_4":"","real_sample_time":"10:43","barcode_url":"","lab":"","flag":"20211015002"},"status":"received","created":"2021-10-15 13:22:28","meta_value":"2","b_modified":"2021-10-15 13:23:06","url":"https:\/\/dnawecheck.com.hk\/registration-form-of-covid-19-rna-test-pdf?form_id=R99MzGyrZMh9"},{"id":"2430","title":"新型冠狀病毒核酸檢測登記表格","data":{"topic":"新型冠狀病毒核酸檢測登記表格","username":"Ng Pui Ting","id_card":"Y5986115","gender":"F","real_birthday":"29\/12\/1996","userphone":"65753347","useremail":"","useraddress":"","userheight":"","userweight":"","q1":"","q2":"","q3":"","q4":"","q5":"","q6":"","q1_1":"","q1_2":"","q3_1":"","q5_7":"","referral_doctor":"Dr Lam Chi Kei","referral_agency":"","barcode":"","barcode_no":"B12101764775","real_sample_date":"06\/10\/2021","a1":"","sample_type":"5","sample_type_4":"","real_sample_time":"10:30","barcode_url":"","lab":"","flag":"20211015001"},"status":"received","created":"2021-10-15 13:18:47","meta_value":"1","b_modified":"2021-10-15 13:19:41","url":"https:\/\/dnawecheck.com.hk\/registration-form-of-covid-19-rna-test-pdf?form_id=R99MzW+kf8Zo"},{"id":"2429","title":"新型冠狀病毒核酸檢測登記表格","data":{"topic":"新型冠狀病毒核酸檢測登記表格","username":"Ho Ka Lok Kenneth","id_card":"Y2332637","gender":"M","real_birthday":"29\/01\/1993","userphone":"94424441","useremail":"","useraddress":"","userheight":"","userweight":"","q1":"","q2":"","q3":"","q4":"","q5":"","q6":"","q1_1":"","q1_2":"","q3_1":"","q5_7":"","referral_doctor":"Dr Lam Chi Kei","referral_agency":"","barcode":"","barcode_no":"A12101266034","real_sample_date":"06\/10\/2021","a1":"","sample_type":"5","sample_type_4":"","real_sample_time":"09:30","barcode_url":"","lab":"{\"report_no\":\"A12101266034\",\"real_report_date\":\"06\\\/10\\\/2021\",\"r1\":\"5\",\"r2\":\"2\",\"r1_4\":\"\",\"type\":\"type2\",\"real_lab_report_date\":\"06\\\/10\\\/2021\",\"real_report_time\":\"18:27\",\"real_lab_report_time\":\"12:30\"}","flag":"20211006002"},"status":"results ready","created":"2021-10-06 18:27:18","meta_value":"2","b_modified":"2021-10-06 18:27:51","url":"https:\/\/dnawecheck.com.hk\/registration-form-of-covid-19-rna-test-pdf?form_id=R99NxGSnYdds"},{"id":"2428","title":"新型冠狀病毒核酸檢測登記表格","data":{"topic":"新型冠狀病毒核酸檢測登記表格","username":"ng chit ngai","id_card":"Y5948329","gender":"M","real_birthday":"01\/05\/1996","userphone":"68936150","useremail":"","useraddress":"","userheight":"","userweight":"","q1":"","q2":"","q3":"","q4":"","q5":"","q6":"","q1_1":"","q1_2":"","q3_1":"","q5_7":"","referral_doctor":"Dr Lam Chi Kei","referral_agency":"","barcode":"","barcode_no":"B12101443906","real_sample_date":"05\/10\/2021","a1":"","sample_type":"5","sample_type_4":"","real_sample_time":"17:18","barcode_url":"","lab":"{\"report_no\":\"B12101443906\",\"real_report_date\":\"06\\\/10\\\/2021\",\"r1\":\"5\",\"r2\":\"2\",\"r1_4\":\"\",\"type\":\"type2\",\"real_lab_report_date\":\"05\\\/10\\\/2021\",\"real_report_time\":\"18:29\",\"real_lab_report_time\":\"18:30\"}","flag":"20211006001"},"status":"results ready","created":"2021-10-06 18:24:47","meta_value":"1","b_modified":"2021-10-06 18:25:22","url":"https:\/\/dnawecheck.com.hk\/registration-form-of-covid-19-rna-test-pdf?form_id=R99NxWGgbsZz"},{"id":"2427","title":"新型冠狀病毒核酸檢測登記表格","data":{"topic":"新型冠狀病毒核酸檢測登記表格","username":"Chanlapkit","id_card":"P9703644","gender":"M","real_birthday":"19\/10\/1984","userphone":"64004094","useremail":"","useraddress":"","userheight":"","userweight":"","q1":"","q2":"","q3":"","q4":"","q5":"","q6":"","q1_1":"","q1_2":"","q3_1":"","q5_7":"","referral_doctor":"Dr Lam Chi Kei","referral_agency":"","barcode":"","barcode_no":"A12101698033","real_sample_date":"23\/09\/2021","a1":"","sample_type":"5","sample_type_4":"","real_sample_time":"12:29","barcode_url":"","lab":"{\"report_no\":\"A12101698033\",\"real_report_date\":\"23\\\/09\\\/2021\",\"r1\":\"5\",\"r2\":\"2\",\"r1_4\":\"\",\"type\":\"type2\",\"real_lab_report_date\":\"23\\\/09\\\/2021\",\"real_report_time\":\"17:44\",\"real_lab_report_time\":\"13:09\"}","flag":"20210930001"},"status":"results ready","created":"2021-09-30 17:43:26","meta_value":"1","b_modified":"2021-09-30 17:43:58","url":"https:\/\/dnawecheck.com.hk\/registration-form-of-covid-19-rna-test-pdf?form_id=R99NymC\/bMlt"},{"id":"2426","title":"新型冠狀病毒核酸檢測登記表格","data":{"topic":"新型冠狀病毒核酸檢測登記表格","username":"Chi Hung Stanley Ng","id_card":"V005575(1)","gender":"M","real_birthday":"13\/12\/1975","userphone":"92359987","useremail":"","useraddress":"","userheight":"","userweight":"","q1":"","q2":"","q3":"","q4":"","q5":"","q6":"","q1_1":"","q1_2":"","q3_1":"","q5_7":"","referral_doctor":"","referral_agency":"","barcode":"","barcode_no":"A12101739736","real_sample_date":"24\/09\/2021","a1":"","sample_type":"1","sample_type_4":"","real_sample_time":"09:28","barcode_url":"","lab":"{\"report_no\":\"A12101739736\",\"real_report_date\":\"24\\\/09\\\/2021\",\"r1\":\"1\",\"r2\":\"2\",\"r1_4\":\"\",\"type\":\"type2\",\"real_lab_report_date\":\"24\\\/09\\\/2021\",\"real_report_time\":\"16:10\",\"real_lab_report_time\":\"13:06\"}","flag":"20210929008"},"status":"results ready","created":"2021-09-29 16:09:36","meta_value":"8","b_modified":"2021-09-29 16:10:16","url":"https:\/\/dnawecheck.com.hk\/registration-form-of-covid-19-rna-test-pdf?form_id=R99Ny2C1atNv"},{"id":"2425","title":"新型冠狀病毒核酸檢測登記表格","data":{"topic":"新型冠狀病毒核酸檢測登記表格","username":"HUANG SIRAN","id_card":"M253426(1) ","gender":"F","real_birthday":"19\/01\/1993","userphone":"55981891","useremail":"","useraddress":"","userheight":"","userweight":"","q1":"","q2":"","q3":"","q4":"","q5":"","q6":"","q1_1":"","q1_2":"","q3_1":"","q5_7":"","referral_doctor":"Dr Lam","referral_agency":"","barcode":"","barcode_no":"A12101998697","real_sample_date":"16\/09\/2021","a1":"","sample_type":"5","sample_type_4":"","real_sample_time":"11:45","barcode_url":"","lab":"{\"report_no\":\"A12101998697\",\"real_report_date\":\"17\\\/09\\\/2021\",\"r1\":\"5\",\"r2\":\"2\",\"r1_4\":\"\",\"type\":\"type2\",\"real_lab_report_date\":\"16\\\/09\\\/2021\",\"real_report_time\":\"15:37\",\"real_lab_report_time\":\"13:34\"}","flag":"20210929007"},"status":"results ready","created":"2021-09-29 15:35:35","meta_value":"7","b_modified":"2021-09-29 15:37:00","url":"https:\/\/dnawecheck.com.hk\/registration-form-of-covid-19-rna-test-pdf?form_id=R99NyG22fNNv"},{"id":"2424","title":"新型冠狀病毒核酸檢測登記表格","data":{"topic":"新型冠狀病毒核酸檢測登記表格","username":"Chan Sai Lun","id_card":"E674102(2)","gender":"M","real_birthday":"15\/06\/1953","userphone":"51392985","useremail":"","useraddress":"","userheight":"","userweight":"","q1":"","q2":"","q3":"","q4":"","q5":"","q6":"","q1_1":"","q1_2":"","q3_1":"","q5_7":"","referral_doctor":"Dr Lam Chi Kei","referral_agency":"","barcode":"","barcode_no":"A12101902904","real_sample_date":"16\/09\/2021","a1":"","sample_type":"5","sample_type_4":"","real_sample_time":"12:37","barcode_url":"","lab":"{\"report_no\":\"A12101902904\",\"real_report_date\":\"17\\\/09\\\/2021\",\"r1\":\"5\",\"r2\":\"2\",\"r1_4\":\"\",\"type\":\"type2\",\"real_lab_report_date\":\"16\\\/09\\\/2021\",\"real_report_time\":\"15:14\",\"real_lab_report_time\":\"13:34\"}","flag":"20210929006"},"status":"results ready","created":"2021-09-29 15:12:51","meta_value":"6","b_modified":"2021-09-29 15:14:22","url":"https:\/\/dnawecheck.com.hk\/registration-form-of-covid-19-rna-test-pdf?form_id=R99NyWehYsl9"}],"count":"7835","debug":"select a.*,b.meta_value,b.modified as b_modified from orm_questionnaire as a left join orm_questionnaire_meta as b on (a.id = b.qid and b.meta_key = 'lab_counter') where a.title = '新型冠狀病毒核酸檢測登記表格' and a.data like '{7407c8da02d8a49454ef6047a520d00ce2d8866f737f8d3e80d9a023986ebef3}{7407c8da02d8a49454ef6047a520d00ce2d8866f737f8d3e80d9a023986ebef3}'  order by b.modified desc,b.meta_value desc limit 0,10"}