{"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` = 34 \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":["1763166882",[{"farm_id":"8735","name":"Bwkc+jogja","total_fish":"16","total_point":"8250"},{"farm_id":"8146","name":"MM+Koi+Tulungagung","total_fish":"8","total_point":"4900"},{"farm_id":"11300","name":"Jagoan+Koi+Blitar","total_fish":"9","total_point":"4650"},{"farm_id":"3081","name":"Budi+Glagah+Koi+Farm","total_fish":"6","total_point":"3050"},{"farm_id":"898","name":"Madina+Aziz","total_fish":"3","total_point":"2250"},{"farm_id":"8717","name":"Kanno+koi+farm","total_fish":"2","total_point":"2100"},{"farm_id":"8691","name":"R_Koi+Banjarnegara","total_fish":"4","total_point":"1600"},{"farm_id":"8729","name":"Aukiya+koi+farm","total_fish":"1","total_point":"1600"},{"farm_id":"8664","name":"Omah+koi+blitar","total_fish":"4","total_point":"1450"},{"farm_id":"8305","name":"OKOBI+KOI+FARM","total_fish":"2","total_point":"1250"}]]}