Table Data

ข้อมูล Select tnsinfo_gps_id from vehicle_transportinformation where tnsinfo_created_at>'2019-12-03 00:00:00' and tnsinfo_gps_id not in (select wtr_gps_id from vehicle_wastetruck) group by tnsinfo_gps_id

222 records   6625 ms
tnsinfo_gps_id
025000300000868998036983944
001000800000010115200000106
008000600000000001802228354
008000600000000001802228334
022000100000000000020074685
001000800000010115200000108
043000100000359857080998693
002000000000000000000504747
001000800000011045100000016
001000800000011045100000014
001000800000010115200000119
002000400000000000000532304
00400060000000IJ3CIA8301199
0110003GPSASIA-181100008763
002000400000000000000533916
001000800000011045100000030
02800040000000GBNF621000096
001000800000011045100000003
008000600000000001902218058
001000800000010039200000010
20 of 222 Records