{"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` = 21 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763224446",[{"owner_id":"9867","name":"Christianto","location_name":"Jakarta+Timur","total_fish":"94"},{"owner_id":"9366","name":"Mr+Debonk","location_name":"Jember","total_fish":"84"},{"owner_id":"9546","name":"Dhimas","location_name":"Malang","total_fish":"27"},{"owner_id":"9234","name":"koi+pemula","location_name":"DKI+Jakarta","total_fish":"23"},{"owner_id":"9407","name":"IKOINESIA+","location_name":"NGANJUK+","total_fish":"16"},{"owner_id":"9251","name":"PANAMA+KOI+INDONESIA","location_name":"Sidoarjo","total_fish":"15"},{"owner_id":"9681","name":"Didik+Santoso","location_name":"Magetan","total_fish":"14"},{"owner_id":"9742","name":"ASWIN+BAHAR","location_name":"PANGKALAN+BUN","total_fish":"13"},{"owner_id":"9786","name":"Khansa+","location_name":"Malang","total_fish":"9"},{"owner_id":"9859","name":"Chuuken+no+mura","location_name":"Bandung","total_fish":"9"}]]}