DIV 3 SNOOKER stats by frames won (highest first)

divnidteamhcapnamenett scorednett_avgframesframes wonwin pc%
3318DLY2-5Kenny Lo129054242188%
3322DLY20Jamil Khan129454241563%
3417DLY1-15Ehsan Turkmani113357201470%
3415DLY110Muhamad Ahmed123641301343%
3391DLY20Osama Raja88044201365%
3189DLY2-10Farhan Khan134561221255%
3124RHL220Roger McLenaghan96234281139%
3407DLY10Mohammad Atif Jamail100650201155%
3383RHL110Richard Robinson89237241146%
3421WTY15Sai Ramasemy64854121192%
3371RHL220Jignesu (Jack) Desai105240261038%
3221RHL210Phil Tilbury120146261038%
3352RHL120Ken Langworthy5343814964%
3315DLY2-10Chris Dam8025714964%
3207RHL115Lee Castledine7493422941%
3416DLY110Fowad Maood4604610880%
3397WTY125Thomaso Lofaro4143512867%
3396WTY110Patrick Gilfilian5845810880%
3195WTY2-10Tony Fitzpatrick6935812758%
3238RHL10Joe Sivanila8524320735%
399RHL110Christian Perez7083520630%
3410WTY210Mohit Dhawan4114110660%
3141WTY215Tony Scibberas3863212650%
3420WTY15Pankaj Sharma4894910660%
3370RHL220Bijay Dass6902924625%
3422WTY210Joe Falzon3753810660%
3320DLY110John Poulakis6764216638%
3423DLY10Latif Hasahzadan5483914536%
3408DLY1-5Mahram Hussain4253512542%
3419WTY125Andrew Clarke3743112433%
3374RHL215Dennis Hall246318450%
3351DLY245Steven Newman180306350%
3413RHL20Vinnel Chandra158266350%
3395WTY115Daniel Jiggens213278225%
3309WTY220Ron Buhagiar3383410220%
3355RHL1-20Ben Piechocki289368113%
387RHL220John Carbines143364125%
3346WTY210Riyen Vora00200%

Records retrieved: 38

SELECT t1.`divn` , t1.`player_id` AS id, t2.`team_code` AS team, t1.`hcap_snkr` AS hcap, CONCAT( t1.`player_first` , ' ', t1.`player_surn` ) AS name, t1.`nett_snkr` AS 'nett scored', FORMAT( (t1.`nett_snkr`/t1.`mts_snkr`)/2,0) AS nett_avg, (t1.`mts_snkr` *2) AS frames, t1.`mts_won_snkr` AS 'frames won', CONCAT( FORMAT( (t1.`mts_won_snkr` / ( t1.`mts_snkr` *2 ) ) *100, 0 ) , '%') AS 'win pc%' FROM `players` AS t1, `teams` AS t2 WHERE t1.`divn` =3 AND t2.`team_id` = t1.`team_id` AND t1.`mts_snkr` >0 ORDER BY t1.`mts_won_snkr` DESC ;