{"SELECT \n        `c`.`owner_id`, \n        `o`.`name`, \n        `o`.`location_name`, \n        count(1) as `total_fish`\n\n    FROM `koishow_show_contestant` `c` \n    JOIN `koishow_owner` `o` ON `o`.`id` = `c`.`owner_id` \n    WHERE `c`.`status` = 1 \n    AND `c`.`show_id` = 30 \n    GROUP BY `c`.`owner_id` \n    ORDER BY COUNT(1) \n    DESC LIMIT 10":["1763101872",[{"owner_id":"15036","name":"Meilki+Bharata","location_name":"Banjarbaru%2CKalimantan+Selatan","total_fish":"26"},{"owner_id":"15193","name":"Ahmad+Zein","location_name":"Martapura","total_fish":"26"},{"owner_id":"15259","name":"Leon+Borneo","location_name":"Balikpapan","total_fish":"24"},{"owner_id":"15315","name":"Putu+Palguna+","location_name":"Singaraja+Bali+","total_fish":"23"},{"owner_id":"14981","name":"BOKK","location_name":"Bontang","total_fish":"20"},{"owner_id":"14925","name":"BPBAT+MANDIANGIN+","location_name":"Mandiangin+","total_fish":"18"},{"owner_id":"15265","name":"RKB","location_name":"Balikpapan","total_fish":"14"},{"owner_id":"14915","name":"Andrian","location_name":"Banjarbaru","total_fish":"12"},{"owner_id":"14812","name":"Bobby+dreGs","location_name":"Banjarbaru%2CKalimantan+Selatan","total_fish":"11"},{"owner_id":"14909","name":"Imam+TBPKC","location_name":"PALANGKARAYA+%28+KALIMANTAN+TENGAH+%29","total_fish":"10"}]]}