Table Data

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

194 records   12312.5 ms
tnsinfo_gps_id
022000100000000000020050130
025000300000868998036983944
008000600000000001802228354
008000600000000001802228334
001001200000010140200000045
022000100000000000003060836
001000800000011045100000016
001000800000011045100000014
002000400000000000000532304
005000600000868998031038397
00400060000000IJ3CIA8301199
047000100000359857081175846
019000000000000001010003129
002000400000000000000523096
003000500000357042060002319
001000800000011045100000030
007000000000000TE5809081119
008000600000000001902218058
001000800000010039200000010
001000100000010337200000004
20 of 194 Records