Table Data

select "pv_officialID",provider_name,pv_name from vehicle_today,vehicle_provider where create_at>to_char(current_date-7,'YYYY-MM-DD') and pv_shortname=provider_name group by "pv_officialID",provider_name,pv_name order by sum(count) desc

42 records   343.75 ms
pv_officialIDprovider_namepv_name
001DTCѷ ... ӡѴ
039Cartrackѷ ä ෤ (Ź) ӡѴ
002FORTHѷ 礡 ӡѴ
006Xsenseѷ 硫 Թ ӡѴ
013gpsiamҧǹӡѴ վ
120SiamGPSѷ վ ӡѴ
036TISѷ ྪի٫ ӡѴ
003One linkѷ ѹ駤 ෤ ӡѴ
025THAI GPSѷ ¨վ á ê ӡѴ
024BKGѷ ҧ͡䡴 ෤ (1986) ӡѴ
022NavTECHѷ ṿ ӡѴ
142GGPSѷ ѹ վ ӡѴ
017TODѷ ԨԵ ӡѴ
015MIѷ ԹǪ ӡѴ
007Thaitrackingѷ Ǫ ӡѴ
075NorthStarѷ ʵԹ෤ ҡѴ
031TYNSѷ ҫҡ ӡѴ
005MappointAsiaѷ · () ӡѴ (Ҫ)
048EyeFleetѷ ʷԹǪ ӡѴ
008Kratosѷ ҷ ä ӡѴ
20 of 42 Records