{"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` = 30 \n    AND `o`.`status` = 1\n    GROUP BY `c`.`farm_id` \n    ORDER BY count(1) \n    DESC LIMIT 10":["1763101872",[{"farm_id":"6925","name":"Mitro+Koi+Farm","total_fish":"80"},{"farm_id":"7103","name":"Babasahan+Fish+Farm","total_fish":"49"},{"farm_id":"6775","name":"BPBAT+MANDIANGIN+","total_fish":"18"},{"farm_id":"5631","name":"Agung+Koi+Farm","total_fish":"7"},{"farm_id":"152","name":"Top+Koi+Farm","total_fish":"4"},{"farm_id":"6801","name":"Kankoi","total_fish":"3"},{"farm_id":"2352","name":"Khusnul+Koi+Farm","total_fish":"1"},{"farm_id":"3081","name":"Budi+Glagah+Koi+Farm","total_fish":"1"},{"farm_id":"5625","name":"CKK+Koi+Farm","total_fish":"1"},{"farm_id":"5630","name":"Good+One+Koi+Farm","total_fish":"1"}]]}