{"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` = 33 \n    AND `o`.`status` = 1\n    GROUP BY `c`.`farm_id` \n    ORDER BY count(1) \n    DESC LIMIT 10":["1763196423",[{"farm_id":"8623","name":"","total_fish":"360"},{"farm_id":"8198","name":"Djojokoesoemo","total_fish":"31"},{"farm_id":"8146","name":"MM+Koi+Tulungagung","total_fish":"9"},{"farm_id":"3081","name":"Budi+Glagah+Koi+Farm","total_fish":"9"},{"farm_id":"8206","name":"Alkafi+Koi+Centre","total_fish":"9"},{"farm_id":"8145","name":"Jagoan+Koi+Blitar","total_fish":"9"},{"farm_id":"8283","name":"Valley+koi+wonosobo+","total_fish":"7"},{"farm_id":"8417","name":"Minato+Koi+Centre","total_fish":"7"},{"farm_id":"569","name":"Irvan+iji","total_fish":"4"},{"farm_id":"1084","name":"Nanang+Furitaru","total_fish":"4"}]]}