{"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` = 41 \n    AND `o`.`status` = 1\n    GROUP BY `c`.`farm_id` \n    ORDER BY count(1) \n    DESC LIMIT 10":["1763157014",[{"farm_id":"10574","name":"Jr+One+Koi+Farm+Magetan","total_fish":"23"},{"farm_id":"3081","name":"Budi+Glagah+Koi+Farm","total_fish":"13"},{"farm_id":"11300","name":"Jagoan+Koi+Blitar","total_fish":"11"},{"farm_id":"7801","name":"K%27koi+farm","total_fish":"9"},{"farm_id":"5631","name":"Agung+Koi+Farm","total_fish":"9"},{"farm_id":"4955","name":"Saka+Koi+Jogja","total_fish":"8"},{"farm_id":"3674","name":"Planet+Koi+Farm","total_fish":"7"},{"farm_id":"9461","name":"Gin+Koi+Tulungagung+","total_fish":"7"},{"farm_id":"11511","name":"Naimiya+koi+farm","total_fish":"6"},{"farm_id":"9913","name":"Tani+Maju+Koi","total_fish":"5"}]]}