{"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` = 29 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763116865",[{"owner_id":"14565","name":"DNA+BORNEO+","location_name":"PALANGKARAYA","total_fish":"397"},{"owner_id":"13354","name":"Arjuna+koi+","location_name":"Banjarmasin","total_fish":"178"},{"owner_id":"13668","name":"Dr.+dr+HARAPAN+PARLINDUNGAN+RINGORINGO.+Sp.A%28K%29","location_name":"Banjarbaru","total_fish":"120"},{"owner_id":"14371","name":"THE+LAST+DANCE","location_name":"KOTABARU","total_fish":"66"},{"owner_id":"14158","name":"Meilki+bharata","location_name":"Banjarbaru","total_fish":"38"},{"owner_id":"13870","name":"S%26A","location_name":"Banjarmasin","total_fish":"29"},{"owner_id":"14182","name":"Mitro+Koi+Farm","location_name":"Blitar","total_fish":"21"},{"owner_id":"13939","name":"Mr+Debonk","location_name":"Jember","total_fish":"19"},{"owner_id":"13708","name":"Leon+Borneo","location_name":"Balikpapan","total_fish":"15"},{"owner_id":"13406","name":"DM+BANJARBARU","location_name":"Banjarbaru","total_fish":"13"}]]}