{"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` = 36 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763116148",[{"owner_id":"17922","name":"KO+AHU","location_name":"Bandung","total_fish":"10"},{"owner_id":"17894","name":"Taman+koi","location_name":"Blitar","total_fish":"9"},{"owner_id":"17717","name":"Yohan+budiman","location_name":"Surabaya","total_fish":"7"},{"owner_id":"17831","name":"Lumintu+Jaya+Beton","location_name":"Blitar","total_fish":"7"},{"owner_id":"17901","name":"Akrimna+fish+center","location_name":"Blitar","total_fish":"7"},{"owner_id":"17805","name":"JANITRA+FT+LEON+KOI+FARM","location_name":"Blitar+","total_fish":"7"},{"owner_id":"17878","name":"AGE+KOI+MART","location_name":"KABUPATEN+BLITAR","total_fish":"7"},{"owner_id":"17849","name":"Kafe+nishikigoi","location_name":"Wonosobo","total_fish":"6"},{"owner_id":"17748","name":"Brian","location_name":"Blitar","total_fish":"6"},{"owner_id":"17869","name":"Dino+irlan","location_name":"","total_fish":"6"}]]}