{"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` = 3 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763208838",[{"owner_location_id":"12153","title":"Mataram","total":"145"},{"owner_location_id":"558","title":"Lombok+Timur","total":"25"},{"owner_location_id":"275","title":"Gianyar","total":"24"},{"owner_location_id":"556","title":"Lombok+Barat","total":"16"},{"owner_location_id":"557","title":"Lombok+Tengah","total":"13"},{"owner_location_id":"559","title":"Lombok+Utara","total":"8"},{"owner_location_id":"274","title":"Denpasar","total":"3"},{"owner_location_id":"4222","title":"Wonosobo","total":"1"}]]}