{"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` = 21 \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":["1763224446",[{"farm_id":"10355","name":"Bagong+Nishikigoi+Farm","total_fish":"56","total_point":"43050"},{"farm_id":"142","name":"Naga+Hitam+","total_fish":"88","total_point":"38650"},{"farm_id":"912","name":"MULIA+KOI+FARM","total_fish":"16","total_point":"36850"},{"farm_id":"5660","name":"Keluarga+Showa+Koi+Farm","total_fish":"47","total_point":"30800"},{"farm_id":"3501","name":"Astro+Blitar+koi","total_fish":"14","total_point":"17450"},{"farm_id":"3134","name":"wiguna+bali","total_fish":"6","total_point":"14550"},{"farm_id":"5631","name":"Agung+Koi+Farm","total_fish":"5","total_point":"11300"},{"farm_id":"690","name":"Kanigoi+koi+farm","total_fish":"19","total_point":"8500"},{"farm_id":"3100","name":"Saiful+Aziz","total_fish":"3","total_point":"8000"},{"farm_id":"3152","name":"samudra+koi+blitar","total_fish":"1","total_point":"6200"}]]}