{"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` = 18 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763169727",[{"owner_id":"7363","name":"Emperor+koi","location_name":"Manado","total_fish":"89"},{"owner_id":"7131","name":"Mr+Debonk","location_name":"Jember","total_fish":"28"},{"owner_id":"7244","name":"Jhon+montolalu","location_name":"Manado","total_fish":"24"},{"owner_id":"7031","name":"Ahmad+zein+","location_name":"Martapura","total_fish":"19"},{"owner_id":"7216","name":"Kairagi+farm","location_name":"Manado","total_fish":"18"},{"owner_id":"7300","name":"Hana+koi","location_name":"Kakas","total_fish":"14"},{"owner_id":"7281","name":"Kai%27santi","location_name":"Tomohon","total_fish":"12"},{"owner_id":"7255","name":"JM+Koi","location_name":"Manado","total_fish":"12"},{"owner_id":"7327","name":"Clinton","location_name":"+Manado","total_fish":"12"},{"owner_id":"7340","name":"Harry+Mundung","location_name":"Manado","total_fish":"12"}]]}