{"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` = 33 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763196423",[{"owner_id":"16820","name":"Benji","location_name":"Kebumen","total_fish":"42"},{"owner_id":"17063","name":"Mr+Debonk+JeKC","location_name":"Jember","total_fish":"27"},{"owner_id":"17053","name":"Garasi+Roda+Dua","location_name":"Yogyakarta","total_fish":"22"},{"owner_id":"16988","name":"Edi+RJ","location_name":"Klaten+","total_fish":"21"},{"owner_id":"17101","name":"One+day+muria+kudus","location_name":"Kudus","total_fish":"20"},{"owner_id":"16737","name":"RF+Gustaman","location_name":"Tasikmalaya","total_fish":"19"},{"owner_id":"16844","name":"Unjare+Nyong","location_name":"Wonosobo","total_fish":"13"},{"owner_id":"16521","name":"Mas+Boghel","location_name":"Kebumen","total_fish":"12"},{"owner_id":"16590","name":"Sakti+Hutama","location_name":"SIDOARJO","total_fish":"11"},{"owner_id":"16613","name":"Littlerock","location_name":"Banyuwangi","total_fish":"8"}]]}