{"SELECT `c`.`owner_location_id`, `o`.`title`, count(1) as `total` FROM `koishow_show_contestant` `c` JOIN `location` `o` ON `o`.`id` = `c`.`owner_location_id` WHERE `c`.`status` = 1 AND  `c`.`show_id` = 9 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763223639",[{"owner_location_id":"398","title":"Blitar","total":"244"},{"owner_location_id":"411","title":"Magetan","total":"158"},{"owner_location_id":"8998","title":"Jakarta","total":"155"},{"owner_location_id":"450","title":"Banjarmasin","total":"68"},{"owner_location_id":"412","title":"Malang","total":"63"},{"owner_location_id":"8288","title":"Tulungagung","total":"61"},{"owner_location_id":"429","title":"Surabaya","total":"56"},{"owner_location_id":"337","title":"Bekasi","total":"55"},{"owner_location_id":"7779","title":"Solo","total":"53"},{"owner_location_id":"431","title":"Tuban","total":"44"}]]}