{"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` = 9 \n    GROUP BY `c`.`par_handler_id` \n    ORDER BY count(1) \n    DESC LIMIT 10":["1763223639",[{"par_handler_id":"1006","name":"Angga+koi+Gianyar","location_name":"Gianyar","total_fish":"127"},{"par_handler_id":"159","name":"Parahyangan+Koi","location_name":"Bandung","total_fish":"70"},{"par_handler_id":"995","name":"KKC+Saranjana","location_name":"Kotabaru","total_fish":"60"},{"par_handler_id":"243","name":"KSML+AUCTION+%28SOLARIS+X+KINKOI%29","location_name":"Bogor","total_fish":"44"},{"par_handler_id":"163","name":"2nd+RONGGOLAWE+KOI+SHOW","location_name":"Tuban","total_fish":"43"},{"par_handler_id":"358","name":"Jakarta+HIPMI+Cup","location_name":"JAKARTA","total_fish":"42"},{"par_handler_id":"227","name":"PENGKY+CREW+X+KOITORIO","location_name":"Bekasi","total_fish":"36"},{"par_handler_id":"303","name":"BALI+NIPPON+KOI","location_name":"Bali","total_fish":"35"},{"par_handler_id":"218","name":"dave_nishikigoi","location_name":"Surakarta+%28Solo%29","total_fish":"35"},{"par_handler_id":"313","name":"Ghaza+Koi+Kediri","location_name":"Semampir%2Ckec.kota+","total_fish":"35"}]]}