{"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` = 16 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763190954",[{"owner_location_id":"403","title":"Jember","total":"93"},{"owner_location_id":"398","title":"Blitar","total":"84"},{"owner_location_id":"274","title":"Denpasar","total":"65"},{"owner_location_id":"396","title":"Banyuwangi","total":"51"},{"owner_location_id":"9291","title":"KLUNGKUNG+","total":"45"},{"owner_location_id":"271","title":"Badung","total":"43"},{"owner_location_id":"237","title":"Bali","total":"41"},{"owner_location_id":"279","title":"Tabanan","total":"29"},{"owner_location_id":"385","title":"Semarang","total":"29"},{"owner_location_id":"420","title":"Pasuruan","total":"26"}]]}