{"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` IN (38, 41)\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":["1763137634",[{"farm_id":"10680","name":"Saimen+garum","total_fish":"56","total_point":"41650"},{"farm_id":"5631","name":"Agung+Koi+Farm","total_fish":"9","total_point":"14800"},{"farm_id":"8146","name":"MM+Koi+Tulungagung","total_fish":"17","total_point":"11050"},{"farm_id":"3081","name":"Budi+Glagah+Koi+Farm","total_fish":"25","total_point":"10850"},{"farm_id":"11300","name":"Jagoan+Koi+Blitar","total_fish":"22","total_point":"10550"},{"farm_id":"10574","name":"Jr+One+Koi+Farm+Magetan","total_fish":"28","total_point":"9050"},{"farm_id":"4955","name":"Saka+Koi+Jogja","total_fish":"8","total_point":"7950"},{"farm_id":"10683","name":"AKF","total_fish":"3","total_point":"4550"},{"farm_id":"8882","name":"Syasya+Koi+Jember","total_fish":"11","total_point":"3750"},{"farm_id":"9913","name":"Tani+Maju+Koi","total_fish":"5","total_point":"3500"}]]}