{"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` = 5 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763139293",[{"owner_location_id":"312","title":"Jakarta+Selatan","total":"86"},{"owner_location_id":"385","title":"Semarang","total":"17"},{"owner_location_id":"310","title":"Jakarta+Barat","total":"14"},{"owner_location_id":"427","title":"Situbondo","total":"10"},{"owner_location_id":"401","title":"Bondowoso","total":"8"},{"owner_location_id":"429","title":"Surabaya","total":"8"},{"owner_location_id":"422","title":"Ponorogo","total":"7"},{"owner_location_id":"737","title":"Palembang","total":"7"},{"owner_location_id":"271","title":"Badung","total":"7"},{"owner_location_id":"408","title":"Lumajang","total":"6"}]]}