{"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` = 22 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763345113",[{"owner_location_id":"313","title":"Jakarta+Timur","total":"110"},{"owner_location_id":"403","title":"Jember","total":"98"},{"owner_location_id":"337","title":"Bekasi","total":"84"},{"owner_location_id":"237","title":"Bali","total":"42"},{"owner_location_id":"274","title":"Denpasar","total":"32"},{"owner_location_id":"396","title":"Banyuwangi","total":"29"},{"owner_location_id":"405","title":"Kediri","total":"27"},{"owner_location_id":"333","title":"Bandung","total":"26"},{"owner_location_id":"558","title":"Lombok+Timur","total":"23"},{"owner_location_id":"12936","title":"Indonesia+","total":"19"}]]}