{"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` = 10 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763168311",[{"owner_location_id":"402","title":"Gresik","total":"102"},{"owner_location_id":"398","title":"Blitar","total":"63"},{"owner_location_id":"431","title":"Tuban","total":"62"},{"owner_location_id":"429","title":"Surabaya","total":"31"},{"owner_location_id":"420","title":"Pasuruan","total":"14"},{"owner_location_id":"407","title":"Lamongan","total":"11"},{"owner_location_id":"408","title":"Lumajang","total":"8"},{"owner_location_id":"12281","title":"Sidoarjo","total":"6"},{"owner_location_id":"385","title":"Semarang","total":"6"},{"owner_location_id":"237","title":"Bali","total":"5"}]]}