{"SELECT \n        `c`.`farm_id`, \n        `o`.`name`, \n        count(1) as `total_fish`, \n        SUM(`total_point`) as `total_point`\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` = 20 \n    AND `o`.`status` = 1\n    GROUP BY `c`.`farm_id` \n    HAVING `total_point` > 0\n    ORDER BY SUM(`total_point`) DESC, COUNT(1) DESC\n    LIMIT 10":["1763221341",[{"farm_id":"2979","name":"","total_fish":"1","total_point":"1200"},{"farm_id":"2976","name":"","total_fish":"1","total_point":"900"},{"farm_id":"2975","name":"","total_fish":"1","total_point":"550"},{"farm_id":"2977","name":"","total_fish":"1","total_point":"550"},{"farm_id":"2982","name":"","total_fish":"1","total_point":"500"},{"farm_id":"2978","name":"","total_fish":"1","total_point":"250"},{"farm_id":"2980","name":"","total_fish":"1","total_point":"200"},{"farm_id":"2981","name":"","total_fish":"1","total_point":"150"}]]}