{"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` = 22 \n    AND `o`.`status` = 1\n    GROUP BY `c`.`farm_id` \n    ORDER BY count(1) \n    DESC LIMIT 10":["1763345113",[{"farm_id":"5660","name":"Keluarga+Showa+Koi+Farm","total_fish":"37"},{"farm_id":"3674","name":"Planet+Koi+Farm","total_fish":"17"},{"farm_id":"8882","name":"Syasya+Koi+Jember","total_fish":"14"},{"farm_id":"9020","name":"Nusa+Koi+Farm","total_fish":"11"},{"farm_id":"1603","name":"EBISU+KOI+Farm","total_fish":"10"},{"farm_id":"152","name":"Top+Koi+Farm","total_fish":"8"},{"farm_id":"142","name":"Naga+Hitam+","total_fish":"7"},{"farm_id":"11166","name":"Lokal","total_fish":"6"},{"farm_id":"3943","name":"Budiluhur","total_fish":"5"},{"farm_id":"2347","name":"Dw+koi+farm","total_fish":"4"}]]}