{"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` = 25 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763116898",[{"owner_location_id":"476","title":"Bontang","total":"287"},{"owner_location_id":"1385","title":"Kota+Baru","total":"202"},{"owner_location_id":"474","title":"Balikpapan","total":"105"},{"owner_location_id":"403","title":"Jember","total":"100"},{"owner_location_id":"449","title":"Banjarbaru","total":"38"},{"owner_location_id":"482","title":"Samarinda","total":"30"},{"owner_location_id":"450","title":"Banjarmasin","total":"10"},{"owner_location_id":"408","title":"Lumajang","total":"5"},{"owner_location_id":"11112","title":"BATULICIN","total":"4"},{"owner_location_id":"12052","title":"Palangkaraya","total":"4"}]]}