{"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` = 18 GROUP BY `c`.`owner_location_id` ORDER BY count(1) DESC LIMIT 10":["1763169727",[{"owner_location_id":"699","title":"Manado","total":"208"},{"owner_location_id":"403","title":"Jember","total":"28"},{"owner_location_id":"672","title":"Palu","total":"19"},{"owner_location_id":"704","title":"Tomohon","total":"19"},{"owner_location_id":"7299","title":"Martapura","total":"19"},{"owner_location_id":"6855","title":"Kakas","total":"14"},{"owner_location_id":"6762","title":"Matuari+%28Bitung+Barat%29","total":"12"},{"owner_location_id":"9654","title":"+Manado","total":"12"},{"owner_location_id":"360","title":"Banjarnegara","total":"6"},{"owner_location_id":"6260","title":"Segeri","total":"6"}]]}