{"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` = 8 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763389173",[{"owner_id":"8987","name":"Noor","location_name":"Kudus","total_fish":"8"},{"owner_id":"19045","name":"adit","location_name":"Kudus+Kota%2C+Kudus%2C+Jawa+Tengah+-+Indonesia","total_fish":"2"},{"owner_id":"887","name":"Wachid","location_name":"Kudus","total_fish":"1"},{"owner_id":"435","name":"azzimar","location_name":"Wonosobo","total_fish":"1"},{"owner_id":"19042","name":"Ko+Lie+Min+%2F+adit","location_name":"Kudus+Kota","total_fish":"1"},{"owner_id":"19044","name":"Vanty+%2F+diganti","location_name":"Pati","total_fish":"1"},{"owner_id":"19046","name":"adit","location_name":"Kudus+Kota%2C+Kudus%2C+Jawa+Tengah+-+Indonesia","total_fish":"1"},{"owner_id":"19047","name":"aditya","location_name":"Kudus+Kota%2C+Kudus%2C+Jawa+Tengah+-+Indonesia","total_fish":"1"},{"owner_id":"19578","name":"adit","location_name":"Kudus+Kota","total_fish":"1"},{"owner_id":"19579","name":"adit","location_name":"Kudus+Kota%2C+Kudus%2C+Jawa+Tengah+-+Indonesia","total_fish":"1"}]]}