{"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` = 35 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763097540",[{"owner_location_id":"353","title":"Purwakarta","total":"180"},{"owner_location_id":"374","title":"Kudus","total":"60"},{"owner_location_id":"385","title":"Semarang","total":"47"},{"owner_location_id":"377","title":"Pati","total":"36"},{"owner_location_id":"241","title":"DI+Yogyakarta","total":"34"},{"owner_location_id":"11301","title":"KOTABARU","total":"32"},{"owner_location_id":"4222","title":"Wonosobo","total":"29"},{"owner_location_id":"375","title":"Magelang","total":"26"},{"owner_location_id":"371","title":"Kebumen","total":"24"},{"owner_location_id":"153","title":"Singapore","total":"24"}]]}