Table Data

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

6338 records   37359.38 ms
tnsinfo_gps_id
000033300000000000000062046
000033300000000000000047353
000033300000000000000045581
000033300000000000000046058
000033300000000000000047818
000033300000000000000044709
000033300000000000000047305
000033300000000000000045516
000033300000000000000061336
000033300000000000000062182
000033300000000000000048339
000033300000000000000060733
000033300000000000000046398
000033300000000000000043286
000033300000000000000049665
000033300000000000000060831
000033300000000000000060392
000033300000000000000045398
000000100000000000000080795
000034000000000000000082853
20 of 6,338 Records