{"SELECT \n        `c`.`farm_id`, \n        `o`.`name`,\n        count(1) as `total_fish`\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` = 39 \n    AND `o`.`status` = 1\n    GROUP BY `c`.`farm_id` \n    ORDER BY count(1) \n    DESC LIMIT 10":["1763096757",[{"farm_id":"11061","name":"","total_fish":"165"},{"farm_id":"3029","name":"+Yamato+koi+farm","total_fish":"20"},{"farm_id":"8875","name":"Pumada+Koi+Farm","total_fish":"13"},{"farm_id":"1132","name":"Bojas+nishikigoi","total_fish":"12"},{"farm_id":"8853","name":"Bpk.+Hendy+Fahruroji+ST","total_fish":"11"},{"farm_id":"11300","name":"Jagoan+Koi+Blitar","total_fish":"8"},{"farm_id":"10892","name":"+DKf","total_fish":"8"},{"farm_id":"10936","name":"Gemah+koi+indonesia","total_fish":"7"},{"farm_id":"11023","name":"Mina+Muda+Abadi","total_fish":"5"},{"farm_id":"10841","name":"Mahdina+Ajiz+","total_fish":"5"}]]}