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

412 records   421.875 ms
idwtr_plate_idwtr_plate_provinceprovider_name
224871-2587ҹOne link
224971-2615ҹOne link
225071-2592ҹOne link
225150-3701ا෾ҹFORTH
225297-4021ا෾ҹFORTH
225350-9775ا෾ҹFORTH
225452-2286ا෾ҹtaff
225581-4832ا෾ҹtaff
225672-7051źJSIAM
225772-6270źJSIAM
225870-9326źJSIAM
225970-9333źJSIAM
226086-7791źtaff
226185-4219źtaff
226286-5428źDTC
226386-5093źDTC
226484-7728źTOD
226586-1141źTOD
226684-6984źTOD
226786-1560źTOD
20 of 412 Records