{"SELECT `c`.`owner_location_id`, `o`.`title`, count(1) as `total` \n  FROM `koishow_show_contestant` `c`\n  JOIN `location` `o` ON `o`.`id` = `c`.`owner_location_id` \n  WHERE `c`.`status` = 1 \n  AND `c`.`show_id` IN (38, 41)\n  GROUP BY `c`.`owner_location_id` \n  ORDER BY count(1) \n  DESC LIMIT 10":["1763137634",[{"owner_location_id":"375","title":"Magelang","total":"178"},{"owner_location_id":"377","title":"Pati","total":"69"},{"owner_location_id":"403","title":"Jember","total":"60"},{"owner_location_id":"241","title":"DI+Yogyakarta","total":"59"},{"owner_location_id":"4222","title":"Wonosobo","total":"53"},{"owner_location_id":"12034","title":"Yogyakarta","total":"44"},{"owner_location_id":"398","title":"Blitar","total":"39"},{"owner_location_id":"333","title":"Bandung","total":"35"},{"owner_location_id":"360","title":"Banjarnegara","total":"32"},{"owner_location_id":"8175","title":"Purwokerto","total":"31"}]]}