{"SELECT \n        `c`.`farm_id`, \n        `o`.`name`,\n        count(1) as `total_fish`\n\n    FROM `koishow_show_contestant` `c` \n    JOIN `koishow_farm` `o` ON `o`.`id` = `c`.`farm_id` \n    WHERE `c`.`status` = 1 \n    AND  `c`.`show_id` = 8 \n    AND `o`.`status` = 1\n    GROUP BY `c`.`farm_id` \n    ORDER BY count(1) \n    DESC LIMIT 10":["1763389173",[{"farm_id":"2967","name":"","total_fish":"1"},{"farm_id":"2974","name":"","total_fish":"1"},{"farm_id":"2972","name":"","total_fish":"1"},{"farm_id":"2968","name":"","total_fish":"1"},{"farm_id":"2986","name":"","total_fish":"1"},{"farm_id":"2988","name":"","total_fish":"1"},{"farm_id":"2989","name":"","total_fish":"1"},{"farm_id":"4328","name":"Berdua+Breeding+Koi","total_fish":"1"},{"farm_id":"11148","name":"","total_fish":"1"},{"farm_id":"9950","name":"","total_fish":"1"}]]}