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

83 records   15.625 ms
idwtr_plate_idwtr_plate_provinceprovider_nameowner_name
270386-0491źGPS TECHѷ 䴡 Թʷ () ӡѴ
270485-4879źGPS TECHѷ 䴡 Թʷ () ӡѴ
270581-2663طûҡDistarѷ ᷹ ӡѴ
270671-9081кOne link³ç
270770-6786кDTCѷ չҷҹʻ ӡѴ
270870-6790кDTCѷ չҷҹʻ ӡѴ
270971-6712кDTCѷ չҷҹʻ ӡѴ
271073-2623źCartrackѷ .èѴǴ ӡѴ
271170-6818кWeGlobalѷ ӡѴ
271270-1302طʧMappointAsiaѷ ɳҺا ӡѴ
271373-1140طûҡEyeFleetѷ ⪤ҹʻ ӡѴ
271486-4008źSiamGPSѷ ... ӡѴ
271585-1877źSiamGPSѷ ... ӡѴ
271685-7818źSiamGPSѷ ... ӡѴ
271786-4307źSiamGPSѷ ... ӡѴ
271886-4306źSiamGPSѷ ... ӡѴ
271984-5772źSiamGPSѷ ... ӡѴ
272084-9122źTODѷ աҭҶѧ 2002 ӡѴ
272165-8934ا෾ҹOne linkѷ Ѫ ӡѴ
272265-8979ا෾ҹOne linkѷ Ѫ ӡѴ
20 of 83 Records