{"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` = 41 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763157014",[{"owner_id":"20696","name":"Koh+Jiang","location_name":"Magelang","total_fish":"84"},{"owner_id":"20896","name":"Iwak+larang+farm","location_name":"Pati","total_fish":"43"},{"owner_id":"20863","name":"Garasi+Roda+Dua","location_name":"Yogyakarta","total_fish":"42"},{"owner_id":"21132","name":"Kevin+Mahesa","location_name":"Magelang","total_fish":"39"},{"owner_id":"20823","name":"Mr+Debonk+Jekc","location_name":"Jember","total_fish":"25"},{"owner_id":"20787","name":"Jarot+Triyawan+%28+Jr%27One+%29","location_name":"Magetan","total_fish":"14"},{"owner_id":"20935","name":"Agus","location_name":"Tambun","total_fish":"14"},{"owner_id":"20681","name":"Chandra+Irawan","location_name":"Bandung","total_fish":"14"},{"owner_id":"21006","name":"Angga+prasojo","location_name":"Kebumen","total_fish":"9"},{"owner_id":"20912","name":"Sekar+Arum+Koi+","location_name":"Solo","total_fish":"7"}]]}