{"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` = 12 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763110950",[{"owner_location_id":"398","title":"Blitar","total":"362"},{"owner_location_id":"403","title":"Jember","total":"59"},{"owner_location_id":"12281","title":"Sidoarjo","total":"18"},{"owner_location_id":"375","title":"Magelang","total":"16"},{"owner_location_id":"385","title":"Semarang","total":"15"},{"owner_location_id":"333","title":"Bandung","total":"15"},{"owner_location_id":"1385","title":"Kota+Baru","total":"14"},{"owner_location_id":"8288","title":"Tulungagung","total":"13"},{"owner_location_id":"450","title":"Banjarmasin","total":"12"},{"owner_location_id":"346","title":"Depok","total":"12"}]]}