Table Data

select * from vehicle_wastetruck where wtr_gps_id not in (Select tnsinfo_gps_id from vehicle_transportinformation where tnsinfo_created_at>'2021-02-23 00:00:00' group by tnsinfo_gps_id) order by wtr_plate_province,wtr_plate_id

1100 records   31187.5 ms
idwtr_gps_idwtr_plate_idwtr_plate_provinceowner_nametruck_typeswaste_types_idowner_telephoneparking_placeprovider_nameremarkwpcreated_atupdated_at
274900100120000001086370000000270-0530ҡѷ õԸҢ ӡѴ (Ҫ)ö÷ء 10 02-501-7330-8thiti@dtc.co.thйظDTC͡03091233749629/9/2563 7:00:009/9/2563 7:00:00
168300100050000000012660012282870-0664ҡѷ õԸҢ ӡѴ (Ҫ)ö10 ҧ 10 02-501-7330service@dtc.co.thDTC28/8/2563 7:00:0028/8/2563 7:00:00
276207700050000000000000041227570-0800ҡѷõԸҢ ӡѴ (Ҫ)ö 6 ҧ 10 02-501-7330 ֧ 8طûҡGIS14/9/2563 7:00:0014/9/2563 7:00:00
275100100010000000012660011222170-2570ҡѷ õԸҢ ӡѴ (Ҫ)ö÷ء 10 02-501-7330-8thiti@dtc.co.thطûҡDTC͡03091233625629/9/2563 7:00:009/9/2563 7:00:00
275300100060000001010030000005570-3709ҡѷ õԸҢ ӡѴ (Ҫ)ö÷ء 10 02-501-7330-8thiti@dtc.co.thطûҡDTC-9/9/2563 7:00:009/9/2563 7:00:00
1711115000100000000159171064641-1742¡ԵԾѹ ෾Էö 4 ҧ 4 0807613980iServe͡030912300676220/11/2562 7:00:0020/11/2562 7:00:00
1709115000100000000159171064610-8053¡ԵԾѹ ෾Էö 4 ҧ 4 0807613980iServe͡030912300666220/11/2562 7:00:0020/11/2562 7:00:00
295500600050000086450703975604370-1912ѧѷ 硫 Թ ӡѴö 6 ҧ 10 021-150133teerapat_atta@hotmail.comѧXsense196/25608/2/2564 7:00:008/2/2564 7:00:00
295400600050000086450703972762270-1917ѧѷ 硫 Թ ӡѴö 6 ҧ 10 021-150132teerapat_atta@hotmail.comѧXsense196/25608/2/2564 7:00:008/2/2564 7:00:00
295300600050000086450703972376170-1920ѧѷ 硫 Թ ӡѴö 6 ҧ 10 021-150131teerapat_atta@hotmail.comѧXsense196/25608/2/2564 7:00:008/2/2564 7:00:00
295600600060000000000000130324470-1928ѧѷ 硫 Թ ӡѴö 6 ҧ 10 021-150134teerapat_atta@hotmail.comѧXsense196/25608/2/2564 7:00:008/2/2564 7:00:00
295800600050000086899803002002470-2082ѧѷ 硫 Թ ӡѴö 6 ҧ 10 021-150136teerapat_atta@hotmail.comѧXsense196/25608/2/2564 7:00:008/2/2564 7:00:00
295700600050000086899031044469270-2086ѧѷ 硫 Թ ӡѴö 6 ҧ 10 021-150135teerapat_atta@hotmail.comѧXsense196/25608/2/2564 7:00:008/2/2564 7:00:00
281701300010000086460604073058170-1157ҧǹӡѴ ö 6 ҧ 10 nuntarat@bergsoemetals.comgpsiam22/10/2563 7:00:0022/10/2563 7:00:00
2614006000500000868998038150989-418ʸٹ Ԫö 4 ҧ 4 082 395 7232طûҡXsense22/6/2563 7:00:0022/6/2563 7:00:00
2673060000500000359857082949256-5467ʸҧԨԵ ྪèԵö¹÷ءǹؤ0812393243 worldgpstracker.sup@gmail.comʸwgtgps24/7/2563 7:00:0024/7/2563 7:00:00
1139013000100000868998030772822-8065ʸ¸ԵԾѷ ǧ3 4 ҧ 4 089-8654960ʸgpsiam͡030912347516123/8/2562 7:00:0023/8/2562 7:00:00
1623006000500000868998037268766-8190ʸ¾þ §ʧö 4 ҧ 4 062 360 2027طûҡXsense14/11/2562 7:00:0014/11/2562 7:00:00
7701200001000000000000T1002613-6356ͧѷ () ӡѴö 4 ҧ 4 038-026124-6ͧSiamGPS͡03091234261613/12/2561 7:00:003/12/2561 7:00:00
7711200001000000000000T1002617-6357ͧѷ () ӡѴö 4 ҧ 4 038-026124-6ͧSiamGPS͡03091234263613/12/2561 7:00:003/12/2561 7:00:00
20 of 1,100 Records