{"SELECT \n        `c`.`owner_id`, \n        `o`.`name`, \n        `o`.`location_name`, \n        count(1) as `total_fish`\n\n    FROM `koishow_show_contestant` `c` \n    JOIN `koishow_owner` `o` ON `o`.`id` = `c`.`owner_id` \n    WHERE `c`.`status` = 1 \n    AND `c`.`show_id` = 9 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763223639",[{"owner_id":"3302","name":"Herru+Santoso","location_name":"Magetan","total_fish":"141"},{"owner_id":"1901","name":"Dede+Darmawan","location_name":"JAKARTA","total_fish":"92"},{"owner_id":"1668","name":"PENGKY+S","location_name":"Bekasi","total_fish":"48"},{"owner_id":"1892","name":"DAVID+RAHARDJA+","location_name":"JAKARTA","total_fish":"43"},{"owner_id":"1593","name":"Daniel","location_name":"Solo","total_fish":"30"},{"owner_id":"1746","name":"Kampung+Ndalem","location_name":"Blitar","total_fish":"20"},{"owner_id":"2298","name":"Dam+Kotabaru+","location_name":"Banjarmasin+","total_fish":"19"},{"owner_id":"3137","name":"Johan","location_name":"Padang","total_fish":"19"},{"owner_id":"1829","name":"BEJO+MOTOR","location_name":"PALANGKARAYA+","total_fish":"19"},{"owner_id":"2089","name":"PAS+KOI+CIKARANG","location_name":"KAB.+BEKASI","total_fish":"16"}]]}