{"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` = 17 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763108367",[{"owner_id":"6674","name":"Planet+Koi","location_name":"Jl.+Glinding%2C+Kandat","total_fish":"35"},{"owner_id":"6858","name":"Ali+Topan","location_name":"bedali+ngancar+kediri","total_fish":"20"},{"owner_id":"6668","name":"Nusa+Koi","location_name":"Pranggang%2CPlosoklaten+","total_fish":"17"},{"owner_id":"6723","name":"Plat+AG+Koi+Kediri","location_name":"Rejomulyo%2C+Kras","total_fish":"14"},{"owner_id":"6769","name":"M+FADIL","location_name":"karanganyar-wates","total_fish":"10"},{"owner_id":"6931","name":"HARI","location_name":"Tales%2CNgadiluwih","total_fish":"10"},{"owner_id":"6755","name":"Ndoy","location_name":"Kediri+Kota","total_fish":"8"},{"owner_id":"6737","name":"Dt+Glee+ft+DAM","location_name":"Pagu","total_fish":"7"},{"owner_id":"6899","name":"Bintang+koi+farm+ft+Leon+koi+","location_name":"Ploso+kec+mojo+kab+kediri","total_fish":"6"},{"owner_id":"6695","name":"LENTERA+KOI","location_name":"Plosoklaten+kawedusan","total_fish":"6"}]]}