Table Data

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

171 records   15265.63 ms
tnsinfo_gps_id
025000300000868998036983944
008000600000000001802228354
008000600000000001802228334
001001200000010140200000045
022000100000000000020074685
001000800000011045100000016
001000800000011045100000014
002000400000000000000532304
005000600000868998031038397
00400060000000IJ3CIA8301199
047000100000359857081175846
002000400000000000000523096
001000800000011045100000030
02800040000000GBNF621000096
008000600000000001902218058
001000800000010039200000010
001000100000010337200000004
001000800000011045100000018
008000600000000001802218226
001000800000011221600000006
20 of 171 Records