{"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` = 12 \n    GROUP BY `c`.`par_handler_id` \n    ORDER BY count(1) \n    DESC LIMIT 10":["1763110950",[{"par_handler_id":"561","name":"Astro+Blitar+koi","location_name":"KABUPATEN+BLITAR","total_fish":"61"},{"par_handler_id":"179","name":"Senkoi.","location_name":"Blitar","total_fish":"48"},{"par_handler_id":"937","name":"Raqi+Koi","location_name":"Blitar+","total_fish":"30"},{"par_handler_id":"95","name":"SYASYA+KOI","location_name":"Jember","total_fish":"29"},{"par_handler_id":"611","name":"Blantik+Koi+Mubeng+%28BKM%29","location_name":"Blitar","total_fish":"20"},{"par_handler_id":"141","name":"Petarung+ukur+ukur","location_name":"Blitar","total_fish":"17"},{"par_handler_id":"598","name":"Beringin+Koi","location_name":"KABUPATEN+BLITAR","total_fish":"16"},{"par_handler_id":"378","name":"UDAN+MAS+KOI+FARM+","location_name":"Blitar","total_fish":"16"},{"par_handler_id":"1006","name":"Angga+koi+Gianyar","location_name":"Gianyar","total_fish":"15"},{"par_handler_id":"123","name":"YAMATO+KOI+INDONESIA","location_name":"Blitar","total_fish":"15"}]]}