{"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` = 33 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763196423",[{"owner_location_id":"371","title":"Kebumen","total":"81"},{"owner_location_id":"4222","title":"Wonosobo","total":"43"},{"owner_location_id":"374","title":"Kudus","total":"37"},{"owner_location_id":"375","title":"Magelang","total":"29"},{"owner_location_id":"403","title":"Jember","total":"27"},{"owner_location_id":"12034","title":"Yogyakarta","total":"22"},{"owner_location_id":"373","title":"Klaten","total":"21"},{"owner_location_id":"358","title":"Tasikmalaya","total":"20"},{"owner_location_id":"12281","title":"Sidoarjo","total":"19"},{"owner_location_id":"360","title":"Banjarnegara","total":"17"}]]}