DIV 2 BILLIARDS stats by handicap (lowest first)

Excludes players who have not played billiards this season
Using database: 2200425_icb17
divnteamidhcapnamescoredavgframesframes wondrawnwin pc%
2BLK166-30Mark Harper2101191118073%
2RHL1295-30Mika Vaifale2252161147050%
2CHL385-30Jason Hastings2060158136046%
2MAR1-30Mario Agius154919486075%
2RHL279-20Jim Morrison2397171145036%
2BLK59-10Eddie Chew1690141124033%
2RHL1382-10Vince Deguara2023145146043%
2CHL293-10Jeff Middleton2440163159060%
2MAR3600Brian Mills2097150146043%
2MAR3650Eddie Cantor1977141146043%
2RHL12330Neville Moore111313985063%
2GLD20010Wayne Brettle2118141159060%
2BLK38910Steve Fabian2022135159060%
2RHL228210Terry Hunter2180156145036%
2CHL26410Peter Mathers1988124167044%
2GLD45210Dave Bowen1875144138062%
2MAR26220Sam Youakim1951139148057%
2RHL121020John Burns23931601510067%
2MAR36620George Isaacs1372137105150%
2RHL29420Raymond Farage1933121168050%
2RHL28720John Carbines59211852040%
2BLK30230Garry Arlidge1298130103130%
2GLD34930Yahya Hakimi43514532067%
2GLD34130Dennis Sharpe1561120133023%
2BLK33830Isaac Epere1390139108080%
2RHL237450Dennis Hall61611000%
2GLD29850Danny Ngeru2408031033%
2BLK45050Paul Hayes165832000%
2CHL45150Mohammad Shahmalecki18191220100%
2RHL29750Paul Hibbard1206121102020%
2CHL45450Pat Gauci30510231033%
2RHL135260Kenny Langworthy103811597078%
2CHL38460Louis Minihan1119102113027%
2GLD19960Monica Brettle1482114139069%

Records retrieved: 34

SELECT t1.`divn` , t2.`team_code` AS team , t1.`player_id` AS id, t1.`hcap_blds` AS hcap, CONCAT(t1.`player_first` ,' ',t1.`player_surn`) AS name, t1.`nett_blds` AS scored, CAST( (t1.`nett_blds`/t1.`mts_blds`) AS UNSIGNED) AS avg, t1.`mts_blds` AS frames , t1.`mts_won_blds` AS 'frames won' , t1.`mts_draw_blds` AS drawn, CONCAT(FORMAT((t1.`mts_won_blds`/(t1.`mts_blds`))*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_blds` > 0 ORDER BY hcap ASC;