{"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` = 3 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763208838",[{"owner_id":"337","name":"bali+black+stone","location_name":"Denpasar","total_fish":"34"},{"owner_id":"384","name":"Angga","location_name":"Gianyar","total_fish":"19"},{"owner_id":"224","name":"Putra+gili","location_name":"Mataram","total_fish":"11"},{"owner_id":"217","name":"MGK","location_name":"Lombok+Timur","total_fish":"10"},{"owner_id":"249","name":"william+sutera+-+Rinjani+Koi+Farm","location_name":"Mataram","total_fish":"9"},{"owner_id":"118","name":"Sapte+lestari+farm","location_name":"Lombok+Timur","total_fish":"9"},{"owner_id":"389","name":"Fangky+Ramdani","location_name":"Mataram","total_fish":"8"},{"owner_id":"235","name":"Harmoni+Koi+Farm","location_name":"Mataram","total_fish":"8"},{"owner_id":"211","name":"Raka+Lombok","location_name":"Mataram","total_fish":"8"},{"owner_id":"132","name":"Diar+hady","location_name":"Mataram","total_fish":"7"}]]}