Back to Events

ESP — English Sporting

English Sporting at Old Glossop Clay Shooting Ground

Old Glossop Clay Shooting Ground

Sunday, 17 November 2019 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

78.8%

Field Average

97.0%

Highest Score

54.0%

Lowest Score

Top 3 Overall

🥈

Eric Weston

AAA

96/100

96.00%

🥇

Brett Winstanley

97/100

97.00%

🥉

Darren Danby

91/100

91.00%

Event Difficulty

78.8% This Event

vs. Old Glossop Clay Shooting Ground historical average (English Sporting)

↑ +4.1% easier than usual

Ground avg: 74.7%

Score Distribution

90–100%

5 10.2%

80–89%

22 44.9%

70–79%

14 28.6%

60–69%

4 8.2%

50–59%

4 8.2%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

10.2%

5 / 49

80%+

55.1%

27 / 49

70%+

83.7%

41 / 49

60%+

91.8%

45 / 49

50%+

100.0%

49 / 49

Class Breakdown

Class	Count	Average	High	Low	Winner
AAA	1	96.0%	96.0%	96.0%	Eric Weston
AA	8	87.9%	97.0%	80.0%	Brett Winstanley
A	15	84.5%	91.0%	78.0%	Darren Danby
B	13	77.3%	84.0%	67.0%	Alan Barnes
C	12	65.9%	82.0%	54.0%	Craig Boddice

Class Composition

AAA

1 2.0%

8 16.3%

15 30.6%

13 26.5%

12 24.5%

Largest class: A — 15 competitors (30.6%)

Class Winners

AAA 1 entered

96/100 — 96.00%

Eric Weston

AA 8 entered

97/100 — 97.00%

Brett Winstanley

2: Mark Fisher — 90.00%

A 15 entered

91/100 — 91.00%

Darren Danby

2: James Hardy — 90.00%

B 13 entered

84/100 — 84.00%

Alan Barnes(tied) Graham Baines(tied) Paul Wilson(tied)

4: Ian Bagshawe — 83.00%

C 12 entered

82/100 — 82.00%

Craig Boddice

2: Ash Dar — 76.00%

Full Results — 49 entries

AA Brett Winstanley

97/100

97.0%

AAA Eric Weston

96/100

96.0%

A Darren Danby

91/100

91.0%

A James Hardy

90/100

90.0%

AA Mark Fisher

90/100

90.0%

AA Joe Emmott

89/100

89.0%

AA Mark Oakley

89/100

89.0%

A Richard Humphreys

89/100

89.0%

A Kerry Oakley

88/100

88.0%

10=

A Andrew Read

87/100

87.0%

10=

AA Daniel Hampson

87/100

87.0%

10=

AA Gary Armitt

87/100

87.0%

10=

A Maurice Snelling

87/100

87.0%

A David Grayson

86/100

86.0%

15=

B Alan Barnes

84/100

84.0%

15=

AA Carl Vickers

84/100

84.0%

15=

B Graham Baines

84/100

84.0%

15=

B Paul Wilson

84/100

84.0%

15=

A Robert Bailey

84/100

84.0%

20=

A Alan Bates

83/100

83.0%

20=

B Ian Bagshawe

83/100

83.0%

20=

A Peter Bate

83/100

83.0%

23=

C Craig Boddice

82/100

82.0%

23=

A Michael Wragg

82/100

82.0%

25=

B David Sutton

81/100

81.0%

25=

A Liam Camp

81/100

81.0%

AA Andrew Roe

80/100

80.0%

28=

A Jonathan Cain

79/100

79.0%

28=

B Mike Pattison

79/100

79.0%

28=

A Tim Wade

79/100

79.0%

31=

A Anthony Jones

78/100

78.0%

31=

B Jon Bowker

78/100

78.0%

33=

C Ash Dar

76/100

76.0%

33=

B Wayne Bates

76/100

76.0%

C Adrian Highley

75/100

75.0%

B Stephen Trow

74/100

74.0%

37=

C Nicholas Barnes

73/100

73.0%

37=

B Roger Ferguson

73/100

73.0%

39=

B Ian Humphreys

71/100

71.0%

39=

B Ian Newton

71/100

71.0%

C Stephen Dolby

70/100

70.0%

42=

B Glyn Farmer

67/100

67.0%

42=

C James Carass

67/100

67.0%

C Andrew Payne

63/100

63.0%

C Alan Brown

62/100

62.0%

C David Vickers

58/100

58.0%

C Benjamin Stafford

56/100

56.0%

C Martin Casswell

55/100

55.0%

C Jeffrey Pedder

54/100

54.0%

#	Name	Class	Score	Score %	Class Rank
1	Brett Winstanley	AA	97/100	97.00%	1
2	Eric Weston	AAA	96/100	96.00%	1
3	Darren Danby	A	91/100	91.00%	1
4=	James Hardy	A	90/100	90.00%	2
4=	Mark Fisher	AA	90/100	90.00%	2
6=	Joe Emmott	AA	89/100	89.00%	3=
6=	Mark Oakley	AA	89/100	89.00%	3=
6=	Richard Humphreys	A	89/100	89.00%	3
9	Kerry Oakley	A	88/100	88.00%	4
10=	Andrew Read	A	87/100	87.00%	5=
10=	Daniel Hampson	AA	87/100	87.00%	5=
10=	Gary Armitt	AA	87/100	87.00%	5=
10=	Maurice Snelling	A	87/100	87.00%	5=
14	David Grayson	A	86/100	86.00%	7
15=	Alan Barnes	B	84/100	84.00%	1=
15=	Carl Vickers	AA	84/100	84.00%	7
15=	Graham Baines	B	84/100	84.00%	1=
15=	Paul Wilson	B	84/100	84.00%	1=
15=	Robert Bailey	A	84/100	84.00%	8
20=	Alan Bates	A	83/100	83.00%	9=
20=	Ian Bagshawe	B	83/100	83.00%	4
20=	Peter Bate	A	83/100	83.00%	9=
23=	Craig Boddice	C	82/100	82.00%	1
23=	Michael Wragg	A	82/100	82.00%	11
25=	David Sutton	B	81/100	81.00%	5
25=	Liam Camp	A	81/100	81.00%	12
27	Andrew Roe	AA	80/100	80.00%	8
28=	Jonathan Cain	A	79/100	79.00%	13=
28=	Mike Pattison	B	79/100	79.00%	6
28=	Tim Wade	A	79/100	79.00%	13=
31=	Anthony Jones	A	78/100	78.00%	15
31=	Jon Bowker	B	78/100	78.00%	7
33=	Ash Dar	C	76/100	76.00%	2
33=	Wayne Bates	B	76/100	76.00%	8
35	Adrian Highley	C	75/100	75.00%	3
36	Stephen Trow	B	74/100	74.00%	9
37=	Nicholas Barnes	C	73/100	73.00%	4
37=	Roger Ferguson	B	73/100	73.00%	10
39=	Ian Humphreys	B	71/100	71.00%	11=
39=	Ian Newton	B	71/100	71.00%	11=
41	Stephen Dolby	C	70/100	70.00%	5
42=	Glyn Farmer	B	67/100	67.00%	13
42=	James Carass	C	67/100	67.00%	6
44	Andrew Payne	C	63/100	63.00%	7
45	Alan Brown	C	62/100	62.00%	8
46	David Vickers	C	58/100	58.00%	9
47	Benjamin Stafford	C	56/100	56.00%	10
48	Martin Casswell	C	55/100	55.00%	11
49	Jeffrey Pedder	C	54/100	54.00%	12

Other ESP Events at Old Glossop Clay Shooting Ground

⚙ Performance Stats DRAG TO MOVE

0.026s ● FAST

DB 52% · Py 32% · Render 16%

11 queries · avg 1.2ms · max 1.9ms

Render Breakdown

DB Logic (Pre-Render) 0.0133s

Python Logic (Pre-Render) 0.0083s

Full Page Render 0.0042s

QUERY TABLES ▾

⚠ event_review 4× 0.004s

shoot_event 2× 0.003s

shoot_score 2× 0.003s

site_configuration 2× 0.002s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (11) — click to expand

#1 [23:45:18.742] 1.9ms

shoot_event

SELECT shoot_event.id AS shoot_event_id, shoot_event.cpsa_fixture_id AS shoot_event_cpsa_fixture_id, shoot_event.name AS shoot_event_name, shoot_event.date AS shoot_event_date, shoot_event.discipline AS shoot_event_discipline, shoot_event.ground AS shoot_event_ground, shoot_event.url AS shoot_event_…

#2 [23:45:18.744] 1.6ms

shoot_score

SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, shoot_score.event_id AS shoot_score…

#3 [23:45:18.747] 1.7ms

shoot_score

SELECT avg(shoot_score.percentage) AS avg_1 
FROM shoot_score JOIN shoot_event ON shoot_score.event_id = shoot_event.id 
WHERE shoot_event.ground = %(ground_1)s AND shoot_event.discipline = %(discipline_1)s AND shoot_event.is_scraped = true AND shoot_event.admin_hidden != true AND shoot_event.id != …

#4 [23:45:18.749] 1.2ms

shoot_event

SELECT shoot_event.id AS shoot_event_id, shoot_event.cpsa_fixture_id AS shoot_event_cpsa_fixture_id, shoot_event.name AS shoot_event_name, shoot_event.date AS shoot_event_date, shoot_event.discipline AS shoot_event_discipline, shoot_event.ground AS shoot_event_ground, shoot_event.url AS shoot_event_…

#5 [23:45:18.751] 1.1ms

event_review

SELECT avg(event_review.rating) AS avg_1, count(event_review.id) AS count_1 
FROM event_review 
WHERE event_review.event_id = %(event_id_1)s

#6 [23:45:18.752] 1.0ms

event_review

SELECT count(*) AS count_1 
FROM (SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.review…

#7 [23:45:18.754] 1.0ms

event_review

SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.reviewer_hash AS event_review_reviewer_h…

#8 [23:45:18.755] 1.0ms

event_review

SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.reviewer_hash AS event_review_reviewer_h…

#9 [23:45:18.757] 0.9ms

site_configuration

SELECT site_configuration.id AS site_configuration_id, site_configuration.key AS site_configuration_key, site_configuration.value AS site_configuration_value 
FROM site_configuration 
WHERE site_configuration.key LIKE %(key_1)s OR site_configuration.key LIKE %(key_2)s

#10 [23:45:18.758] 0.9ms

site_configuration

SELECT site_configuration.id AS site_configuration_id, site_configuration.key AS site_configuration_key, site_configuration.value AS site_configuration_value 
FROM site_configuration 
WHERE site_configuration.key IN (%(key_1_1)s, %(key_1_2)s, %(key_1_3)s, %(key_1_4)s)

#11 [23:45:18.759] 0.9ms

admin_menu_item

SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab 
FROM admin_menu_item

LIVE REQUESTS (0) — click to expand

English Sporting at Old Glossop Clay Shooting Ground

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?