{"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` = 21 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763224446",[{"owner_location_id":"412","title":"Malang","total":"116"},{"owner_location_id":"313","title":"Jakarta+Timur","total":"94"},{"owner_location_id":"403","title":"Jember","total":"94"},{"owner_location_id":"398","title":"Blitar","total":"73"},{"owner_location_id":"242","title":"DKI+Jakarta","total":"35"},{"owner_location_id":"12281","title":"Sidoarjo","total":"34"},{"owner_location_id":"333","title":"Bandung","total":"26"},{"owner_location_id":"411","title":"Magetan","total":"25"},{"owner_location_id":"429","title":"Surabaya","total":"24"},{"owner_location_id":"416","title":"Nganjuk","total":"20"}]]}