{"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` = 36 \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":["1763116148",[{"farm_id":"3029","name":"+Yamato+koi+farm","total_fish":"11","total_point":"8750"},{"farm_id":"9005","name":"nindi+koi","total_fish":"5","total_point":"4800"},{"farm_id":"690","name":"Kanigoi+koi+farm","total_fish":"15","total_point":"4500"},{"farm_id":"8960","name":"Hwc+koi+blitar","total_fish":"9","total_point":"4350"},{"farm_id":"8944","name":"NKF+KOI+FARM","total_fish":"6","total_point":"4000"},{"farm_id":"8882","name":"Syasya+Koi+Jember","total_fish":"8","total_point":"3550"},{"farm_id":"5682","name":"Jagoan+Koi+Farm","total_fish":"12","total_point":"3200"},{"farm_id":"8929","name":"Raqi+Koi+Blitar","total_fish":"7","total_point":"2750"},{"farm_id":"8854","name":"Bpk.+Hendy+F.S","total_fish":"5","total_point":"2300"},{"farm_id":"8907","name":"chindy+koi","total_fish":"3","total_point":"2300"}]]}