Table Data

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

261 records   31.25 ms
idwtr_plate_idwtr_plate_provinceprovider_nameowner_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 261 Records