{"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` = 9 \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":["1763223639",[{"farm_id":"142","name":"Naga+Hitam+","total_fish":"34","total_point":"24400"},{"farm_id":"152","name":"Top+Koi+Farm","total_fish":"34","total_point":"22700"},{"farm_id":"2352","name":"Khusnul+Koi+Farm","total_fish":"18","total_point":"21450"},{"farm_id":"10574","name":"Jr+One+Koi+Farm+Magetan","total_fish":"34","total_point":"13250"},{"farm_id":"5660","name":"Keluarga+Showa+Koi+Farm","total_fish":"27","total_point":"11700"},{"farm_id":"11166","name":"Lokal","total_fish":"23","total_point":"6800"},{"farm_id":"1070","name":"Koi+kings","total_fish":"13","total_point":"6550"},{"farm_id":"3081","name":"Budi+Glagah+Koi+Farm","total_fish":"16","total_point":"5200"},{"farm_id":"690","name":"Kanigoi+koi+farm","total_fish":"10","total_point":"4050"},{"farm_id":"140","name":"Rony+Koi+Farm","total_fish":"9","total_point":"3900"}]]}