{"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` IN (38, 41)\n    GROUP BY `c`.`par_handler_id` \n    ORDER BY count(1) \n    DESC LIMIT 10":["1763137634",[{"par_handler_id":"3216","name":"MaJoo+Koi","location_name":"Magelang","total_fish":"83"},{"par_handler_id":"3236","name":"Pesona+jatim+member+league","location_name":"Jawa+Timur","total_fish":"72"},{"par_handler_id":"2953","name":"Pesona+Jatim","location_name":"Jawa+Timur","total_fish":"66"},{"par_handler_id":"3228","name":"Jaring+Suwek+Koi","location_name":"Nganjuk","total_fish":"55"},{"par_handler_id":"3265","name":"Ikigai.+Ltd+x+Balitar+Carp.+Co","location_name":"Java+Island","total_fish":"50"},{"par_handler_id":"3279","name":"Etjo+x+Lurisae+x+Koithoru","location_name":"Indonesia+","total_fish":"44"},{"par_handler_id":"3257","name":"WONG+PAWON+NUsaTik+x+Bolo+Koi","location_name":"TULUNGAGUNG","total_fish":"39"},{"par_handler_id":"2950","name":"Jaring+Suwek+Koi","location_name":"Nganjuk","total_fish":"31"},{"par_handler_id":"3005","name":"Asako+x+RF+Gustaman+Group","location_name":"Tasikmalaya","total_fish":"30"},{"par_handler_id":"2956","name":"Ikigai.+Ltd+X+Pendopo+Koi+house+","location_name":"Java+Island","total_fish":"29"}]]}