{"SELECT \n        `c`.`par_handler_id`, \n        `o`.`name`,\n        `o`.`location_name`, \n        count(1) as `total_fish`\n\n    FROM `koishow_show_contestant` `c` \n    JOIN `koishow_handler` `o` ON `o`.`id` = `c`.`par_handler_id` \n    WHERE `c`.`status` = 1 \n    AND  `c`.`show_id` = 31 \n    GROUP BY `c`.`par_handler_id` \n    ORDER BY count(1) \n    DESC LIMIT 10":["1763144567",[{"par_handler_id":"2158","name":"Walet+Koi+Kebumen","location_name":"Kebumen","total_fish":"94"},{"par_handler_id":"2253","name":"Pesona+Jatim","location_name":"Jawa+Timur","total_fish":"77"},{"par_handler_id":"2152","name":"Semarang+Koi+Centre","location_name":"Semarang","total_fish":"55"},{"par_handler_id":"2172","name":"Yasa+Koi+X+Mahesa+Koi","location_name":"DI+Yogyakarta","total_fish":"47"},{"par_handler_id":"2268","name":"Dabs+Koi+House+x+Miwa+Koi","location_name":"Yogyakarta","total_fish":"44"},{"par_handler_id":"2178","name":"Jaring+Suwek+Koi","location_name":"Nganjuk","total_fish":"34"},{"par_handler_id":"2209","name":"Konten+Ikan+","location_name":"Wonosobo","total_fish":"33"},{"par_handler_id":"2239","name":"PASUKAN+LERENG+MURIA","location_name":"Kudus","total_fish":"32"},{"par_handler_id":"2235","name":"SKB+Koi","location_name":"Klaten","total_fish":"27"},{"par_handler_id":"2166","name":"Koi+Dawet+Ayu","location_name":"Banjarnegara","total_fish":"25"}]]}