{"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` = 8 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763389173",[{"owner_location_id":"374","title":"Kudus","total":"9"},{"owner_location_id":"12932","title":"Kudus+Kota%2C+Kudus%2C+Jawa+Tengah+-+Indonesia","total":"5"},{"owner_location_id":"4222","title":"Wonosobo","total":"1"},{"owner_location_id":"7871","title":"Nusantara","total":"1"},{"owner_location_id":"2899","title":"Pagu","total":"1"},{"owner_location_id":"2402","title":"Kudus+Kota","total":"1"}]]}