{"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` = 34 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763166882",[{"owner_id":"17618","name":"Walet+Koi+Kebumen","location_name":"Kebumen","total_fish":"34"},{"owner_id":"17469","name":"Mr+Debonk+Jekc","location_name":"Jember","total_fish":"19"},{"owner_id":"17437","name":"Akmal+Abiyoso","location_name":"Singapore","total_fish":"17"},{"owner_id":"17319","name":"Bale+wukir","location_name":"DI+Yogyakarta","total_fish":"16"},{"owner_id":"17201","name":"Tanimbako","location_name":"Temanggung","total_fish":"16"},{"owner_id":"17495","name":"Danar+Dwi+Anandika","location_name":"Semarang","total_fish":"14"},{"owner_id":"17152","name":"Aswin+Bahar","location_name":"PANGKALAN+BUN%2C+Kalimantan+Tengah","total_fish":"10"},{"owner_id":"17375","name":"Djams+1%25","location_name":"Bogor","total_fish":"8"},{"owner_id":"17177","name":"Iwak+Larang+Farm","location_name":"Pati","total_fish":"8"},{"owner_id":"17162","name":"NAOMI","location_name":"Temanggung","total_fish":"8"}]]}