{"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` = 31 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763144567",[{"owner_id":"16452","name":"GARASI+RODA+DUA","location_name":"Yogyakarta","total_fish":"101"},{"owner_id":"16396","name":"Kebumen+Koi+Show+Part+2","location_name":"Kebumen","total_fish":"70"},{"owner_id":"16295","name":"Mr+Debonk","location_name":"Jember","total_fish":"32"},{"owner_id":"15980","name":"DF+GROUP","location_name":"Semarang","total_fish":"27"},{"owner_id":"15583","name":"PANAMA+KOI+INDONESIA","location_name":"SIDOARJO","total_fish":"19"},{"owner_id":"15515","name":"LOPE+KOI","location_name":"Semarang+Barat","total_fish":"19"},{"owner_id":"15769","name":"Benji","location_name":"Kebumen","total_fish":"18"},{"owner_id":"15327","name":"Danar+Dwi+Anandika","location_name":"Semarang","total_fish":"18"},{"owner_id":"15802","name":"Alesha+Koi","location_name":"Wonosobo","total_fish":"15"},{"owner_id":"16454","name":"Imam+Mustofa+SJD+KOI","location_name":"Magelang","total_fish":"14"}]]}