{"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` = 10 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763168311",[{"owner_id":"3758","name":"Udan+mas+koi","location_name":"Blitar","total_fish":"29"},{"owner_id":"3666","name":"EDO+NISHIKIGOI","location_name":"Tuban","total_fish":"22"},{"owner_id":"3630","name":"Dony+ved","location_name":"Surabaya","total_fish":"19"},{"owner_id":"3537","name":"Galaxi+midori+koi+","location_name":"Gresik","total_fish":"17"},{"owner_id":"3611","name":"Hamdan+KOIOKI","location_name":"Gresik","total_fish":"10"},{"owner_id":"3835","name":"BUCHORI","location_name":"Blitar","total_fish":"9"},{"owner_id":"3513","name":"Isma","location_name":"Gresik","total_fish":"8"},{"owner_id":"3555","name":"Hartono+King+","location_name":"Gresik","total_fish":"8"},{"owner_id":"3631","name":"ALBANY","location_name":"Tuban","total_fish":"6"},{"owner_id":"3625","name":"Yudi+Arif+Safar","location_name":"Tuban","total_fish":"6"}]]}