{"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` = 12 \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":["1763110950",[{"farm_id":"5660","name":"Keluarga+Showa+Koi+Farm","total_fish":"14","total_point":"10800"},{"farm_id":"1732","name":"LDY+Koi+farm","total_fish":"18","total_point":"8050"},{"farm_id":"620","name":"TAMAN+KOI","total_fish":"7","total_point":"3750"},{"farm_id":"1719","name":"DINO+KOI","total_fish":"10","total_point":"3700"},{"farm_id":"673","name":"Via+koi","total_fish":"7","total_point":"3450"},{"farm_id":"1711","name":"parama+fish+koi","total_fish":"6","total_point":"3350"},{"farm_id":"142","name":"Naga+Hitam+","total_fish":"10","total_point":"3150"},{"farm_id":"898","name":"Madina+Aziz","total_fish":"9","total_point":"2400"},{"farm_id":"1710","name":"Nura+koi+blitar","total_fish":"3","total_point":"2400"},{"farm_id":"1902","name":"Sinar+koi","total_fish":"6","total_point":"2300"}]]}