{"SELECT \n        `c`.`owner_id`, \n        `o`.`name`, \n        `o`.`location_name`, \n        count(1) as `total_fish`\n\n    FROM `koishow_show_contestant` `c` \n    JOIN `koishow_owner` `o` ON `o`.`id` = `c`.`owner_id` \n    WHERE `c`.`status` = 1 \n    AND `c`.`show_id` = 27 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763116802",[{"owner_id":"12493","name":"Yusuf+Yellow+Blue+","location_name":"cilacap+","total_fish":"57"},{"owner_id":"12352","name":"Alesha+Koi+","location_name":"Wonosobo","total_fish":"24"},{"owner_id":"12955","name":"Dr+Imbar+Sudarsono","location_name":"Kebumen","total_fish":"23"},{"owner_id":"12965","name":"Benji","location_name":"Kebumen","total_fish":"21"},{"owner_id":"12643","name":"Mahesa+Koi","location_name":"DI+Yogyakarta","total_fish":"16"},{"owner_id":"11976","name":"Arya+Widayana","location_name":"Semarang","total_fish":"14"},{"owner_id":"12380","name":"GLD+Shafi","location_name":"Banjarnegara","total_fish":"13"},{"owner_id":"12171","name":"Banyu+Berkah+Jaya","location_name":"Purwokerto","total_fish":"13"},{"owner_id":"11990","name":"Danar+Dwi+Anandika","location_name":"Semarang","total_fish":"12"},{"owner_id":"12688","name":"Mas+Boghel","location_name":"Kebumen","total_fish":"12"}]]}