DIV 2 SNOOKER stats by frames won (highest first)

divnidteamhcapnamenett scorednett_avgframesframes wonwin pc%
2198MAR0Phillip Walda117754221777%
2341GLD5Dennis Sharpe120655221464%
2387CHL15Stefano Fazio104347221359%
2380GLD5Steve Whitehead66856121192%
2381RHL215Darren James87637241146%
2262MAR5Sam Youakim91551181161%
2349GLD5Yahya Hakimi76448161063%
2402BLK0Bob Marsh79149161063%
2338BLK5Isaac Epere78249161063%
2366MAR5George Isaacs8925018950%
2207RHL120Lee Castledine6093418950%
2221RHL120Phil Tilbury7484218950%
2383RHL115Richard Robinson7833622836%
2386CHL-5Nima Alizadeh8805516850%
2360MAR-10Brian Mills6474614750%
2124RHL115Roger McLenaghan5193714750%
2390DLY-20Muhammad Hassan8135814750%
2384CHL20Louis Minihan5153714643%
2199GLD25Monica Brettle3913312542%
2189DLY0Farhan Khan7394616531%
2389BLK0Steven Fabian364616583%
2406CHL0Sean Gong431548563%
2388CHL25Mohammed Shahmaleki3613610440%
26BLK-15Dave Vassallo322546467%
2369DLY15Usman Sheikhi302388338%
2413RHL215Vinnel Chandra346438338%
259BLK-10Eddie Chew4284310330%
2339BLK-10Alan Crouch367468338%
2352RHL230Kenny Langworthy2632212217%
2185DLY0Franco Di Matteo1376922100%
2235BLK20Gordon Alexander1065322100%
2298GLD15Danny Ngeru289368225%
2340GLD10Ron Vidler1266322100%
2302BLK10Garry Arlidge91462150%
2385CHL10Jason Hastings80402150%
2269DLY-20Clarence Ho107542150%
2315DLY0Chris Dam139702150%
2210RHL210John Burns115294125%
297RHL230Paul Hibbard2762810110%
294RHL215Raymond Farage127324125%
287RHL225John Carbines245318113%
2350DLY-10Roy Rahmani191484125%
2391DLY10Osama Raja5729200%

Records retrieved: 43

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` =2 AND t2.`team_id` = t1.`team_id` AND t1.`mts_snkr` >0 ORDER BY t1.`mts_won_snkr` DESC ;