{"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` = 39 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763096757",[{"owner_location_id":"398","title":"Blitar","total":"187"},{"owner_location_id":"8288","title":"Tulungagung","total":"26"},{"owner_location_id":"339","title":"Bogor","total":"12"},{"owner_location_id":"9169","title":"Astro+Blitar+koi","total":"10"},{"owner_location_id":"474","title":"Balikpapan","total":"9"},{"owner_location_id":"294","title":"Tangerang+Selatan","total":"7"},{"owner_location_id":"403","title":"Jember","total":"7"},{"owner_location_id":"429","title":"Surabaya","total":"7"},{"owner_location_id":"13545","title":"Kaledo+Koi+Palu","total":"5"},{"owner_location_id":"405","title":"Kediri","total":"5"}]]}