{"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` = 29 \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":["1763116865",[{"farm_id":"5683","name":"Dayana+Koi+Center","total_fish":"312","total_point":"225200"},{"farm_id":"6574","name":"Predator+Koi+Farm","total_fish":"120","total_point":"80800"},{"farm_id":"6925","name":"Mitro+Koi+Farm","total_fish":"57","total_point":"37600"},{"farm_id":"5641","name":"Astro+Blitar+Koi","total_fish":"15","total_point":"31300"},{"farm_id":"5631","name":"Agung+Koi+Farm","total_fish":"21","total_point":"27500"},{"farm_id":"5625","name":"CKK+Koi+Farm","total_fish":"2","total_point":"11900"},{"farm_id":"5657","name":"Khusnul+Koi+Farm","total_fish":"6","total_point":"9800"},{"farm_id":"5682","name":"Jagoan+Koi+Farm","total_fish":"21","total_point":"8650"},{"farm_id":"3081","name":"Budi+Glagah+Koi+Farm","total_fish":"11","total_point":"6800"},{"farm_id":"5660","name":"Keluarga+Showa+Koi+Farm","total_fish":"10","total_point":"6550"}]]}