{"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` = 27 \n    GROUP BY `c`.`par_handler_id` \n    ORDER BY count(1) \n    DESC LIMIT 10":["1763116802",[{"par_handler_id":"1809","name":"Yellow+Blue","location_name":"Cilacap","total_fish":"83"},{"par_handler_id":"1778","name":"LENTERA+KOI","location_name":"Sidoarjo","total_fish":"55"},{"par_handler_id":"1843","name":"Konten+Ikan","location_name":"Wonosobo","total_fish":"54"},{"par_handler_id":"1855","name":"Yukiyama+Koi+Farm","location_name":"Nusantara","total_fish":"51"},{"par_handler_id":"1737","name":"Semarang+Koi+Centre","location_name":"Semarang","total_fish":"44"},{"par_handler_id":"1804","name":"Yasa+Koi+X+Botuna","location_name":"DI+Yogyakarta","total_fish":"41"},{"par_handler_id":"1743","name":"KOI+DAWET+AYU","location_name":"Banjarnegara","total_fish":"36"},{"par_handler_id":"1819","name":"LB+KOI+Jatijajar+X+DRA_KOI+Tasikmalaya","location_name":"Kebumen","total_fish":"35"},{"par_handler_id":"1815","name":"Semarang+Koi+Society+","location_name":"Semarang","total_fish":"32"},{"par_handler_id":"1830","name":"Omah+shiro","location_name":"Wonosobo","total_fish":"31"}]]}