Table Data

select id,wtr_plate_id,wtr_plate_province,provider_name from vehicle_wastetruck where not exists (select 1 from vehicle_currenttsinfo where crt_wtr_id_id=vehicle_wastetruck.id) order by id

102 records   62.5 ms
idwtr_plate_idwtr_plate_provinceprovider_name
161783-7561кGPS URI
161887-7867ا෾ҹSiamGPS
16192-3563ا෾ҹXsense
1620-6566ԹXsense
1621©-8625ҪXsense
1622-5143͹Xsense
1623-8190ʸXsense
1624-8915Xsense
162570-1897ӾٹXsense
162672-3996طûҡXsense
162772-3829طûҡXsense
162890-0332ûGGPS
162963-7027 ا෾ҹgpsiam
163081-4852ྪúóGGPS
163183-3400äGGPS
163282-8072ྪúóGGPS
1633-5019ԧGGPS
163482-1903ྪúóGGPS
163582-7799ྪúóGGPS
1636-7079ԧGGPS
20 of 102 Records