Back to Events

STR — Sportrap

Sportrap at E.J.Churchill at The Swinton Estate

E.J.Churchill at The Swinton Estate

Saturday, 07 May 2022 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

81.0%

Field Average

96.0%

Highest Score

60.0%

Lowest Score

Top 3 Overall

🥈

Adrian Parkin-Coates

95/100

95.00%

🥇

Paul Foster

AAA

96/100

96.00%

🥉

Martin Doughty

94/100

94.00%

Event Difficulty

81.0% This Event

vs. E.J.Churchill at The Swinton Estate historical average (Sportrap)

↑ +3.9% easier than usual

Ground avg: 77.1%

Score Distribution

90–100%

9 18.8%

80–89%

18 37.5%

70–79%

19 39.6%

60–69%

2 4.2%

50–59%

0 0.0%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

18.8%

9 / 48

80%+

56.2%

27 / 48

70%+

95.8%

46 / 48

60%+

100.0%

48 / 48

50%+

100.0%

48 / 48

Class Breakdown

Class	Count	Average	High	Low	Winner
AAA	3	93.7%	96.0%	92.0%	Paul Foster
AA	9	88.7%	95.0%	79.0%	Adrian Parkin-Coates
A	13	81.8%	91.0%	76.0%	Graham Walker
B	15	77.5%	84.0%	71.0%	Guy Watson
C	8	72.6%	85.0%	60.0%	Kerry Oakley

Class Composition

AAA

3 6.2%

9 18.8%

13 27.1%

15 31.2%

8 16.7%

Largest class: B — 15 competitors (31.2%)

Class Winners

AAA 3 entered

96/100 — 96.00%

Paul Foster

2: Mark Webster — 93.00%

AA 9 entered

95/100 — 95.00%

Adrian Parkin-Coates

2: Martin Doughty — 94.00%

A 13 entered

91/100 — 91.00%

Graham Walker

2: Neil Midgley — 88.00%

B 15 entered

84/100 — 84.00%

Guy Watson(tied) Jack Bradley(tied)

3: John Frankland — 83.00%

C 8 entered

85/100 — 85.00%

Kerry Oakley

2: Tim Gibson — 79.00%

Full Results — 48 entries

AAA Paul Foster

96/100

96.0%

AA Adrian Parkin-Coates

95/100

95.0%

AA Martin Doughty

94/100

94.0%

AA Joe Emmott

93/100

93.0%

AAA Mark Webster

93/100

93.0%

AAA Lee Jackson

92/100

92.0%

AA M Delf

92/100

92.0%

A Graham Walker

91/100

91.0%

AA Michael Foster

91/100

91.0%

A Neil Midgley

88/100

88.0%

A Scott Emmerson

87/100

87.0%

12=

AA Michael Snape

86/100

86.0%

12=

AA Tony Gradwell

86/100

86.0%

C Kerry Oakley

85/100

85.0%

15=

B Guy Watson

84/100

84.0%

15=

B Jack Bradley

84/100

84.0%

15=

A Mark Oakley

84/100

84.0%

18=

A Chris Reed

83/100

83.0%

18=

B John Frankland

83/100

83.0%

20=

A Ben Gamble

82/100

82.0%

20=

AA Ian Mullarkey

82/100

82.0%

20=

B Leslie Meynell

82/100

82.0%

23=

B Daniel Rimmer

80/100

80.0%

23=

A Ed Robinson

80/100

80.0%

23=

A Eric Warring

80/100

80.0%

23=

B Richard Dennison

80/100

80.0%

23=

B Richard Pennington

80/100

80.0%

28=

B John Harrison

79/100

79.0%

28=

A Oliver Johnson

79/100

79.0%

28=

A Stuart Walker

79/100

79.0%

28=

C Tim Gibson

79/100

79.0%

28=

AA William Pennington

79/100

79.0%

A Trevor Francis

78/100

78.0%

34=

C Andrew Wiseman

77/100

77.0%

34=

C Jamie Firn

77/100

77.0%

34=

A John Longstaff

77/100

77.0%

A Thomas Oliver

76/100

76.0%

38=

B Darren Harris

74/100

74.0%

38=

B Eric Bowe

74/100

74.0%

38=

B Keith Mattinson

74/100

74.0%

38=

B Nigel Smith

74/100

74.0%

C David Rae

73/100

73.0%

B Martin Griffiths

72/100

72.0%

44=

B Stephen Norris

71/100

71.0%

44=

B Trevor Peel

71/100

71.0%

C Oliver Kemp

70/100

70.0%

47=

C Robert Crowson

60/100

60.0%

47=

C Todd Walsh

60/100

60.0%

#	Name	Class	Score	Score %	Class Rank
1	Paul Foster	AAA	96/100	96.00%	1
2	Adrian Parkin-Coates	AA	95/100	95.00%	1
3	Martin Doughty	AA	94/100	94.00%	2
4=	Joe Emmott	AA	93/100	93.00%	3
4=	Mark Webster	AAA	93/100	93.00%	2
6=	Lee Jackson	AAA	92/100	92.00%	3
6=	M Delf	AA	92/100	92.00%	4
8=	Graham Walker	A	91/100	91.00%	1
8=	Michael Foster	AA	91/100	91.00%	5
10	Neil Midgley	A	88/100	88.00%	2
11	Scott Emmerson	A	87/100	87.00%	3
12=	Michael Snape	AA	86/100	86.00%	6=
12=	Tony Gradwell	AA	86/100	86.00%	6=
14	Kerry Oakley	C	85/100	85.00%	1
15=	Guy Watson	B	84/100	84.00%	1=
15=	Jack Bradley	B	84/100	84.00%	1=
15=	Mark Oakley	A	84/100	84.00%	4
18=	Chris Reed	A	83/100	83.00%	5
18=	John Frankland	B	83/100	83.00%	3
20=	Ben Gamble	A	82/100	82.00%	6
20=	Ian Mullarkey	AA	82/100	82.00%	8
20=	Leslie Meynell	B	82/100	82.00%	4
23=	Daniel Rimmer	B	80/100	80.00%	5=
23=	Ed Robinson	A	80/100	80.00%	7=
23=	Eric Warring	A	80/100	80.00%	7=
23=	Richard Dennison	B	80/100	80.00%	5=
23=	Richard Pennington	B	80/100	80.00%	5=
28=	John Harrison	B	79/100	79.00%	8
28=	Oliver Johnson	A	79/100	79.00%	9=
28=	Stuart Walker	A	79/100	79.00%	9=
28=	Tim Gibson	C	79/100	79.00%	2
28=	William Pennington	AA	79/100	79.00%	9
33	Trevor Francis	A	78/100	78.00%	11
34=	Andrew Wiseman	C	77/100	77.00%	3=
34=	Jamie Firn	C	77/100	77.00%	3=
34=	John Longstaff	A	77/100	77.00%	12
37	Thomas Oliver	A	76/100	76.00%	13
38=	Darren Harris	B	74/100	74.00%	9=
38=	Eric Bowe	B	74/100	74.00%	9=
38=	Keith Mattinson	B	74/100	74.00%	9=
38=	Nigel Smith	B	74/100	74.00%	9=
42	David Rae	C	73/100	73.00%	5
43	Martin Griffiths	B	72/100	72.00%	13
44=	Stephen Norris	B	71/100	71.00%	14=
44=	Trevor Peel	B	71/100	71.00%	14=
46	Oliver Kemp	C	70/100	70.00%	6
47=	Robert Crowson	C	60/100	60.00%	7=
47=	Todd Walsh	C	60/100	60.00%	7=

Other STR Events at E.J.Churchill at The Swinton Estate

⚙ Performance Stats DRAG TO MOVE

0.032s ● FAST

DB 43% · Py 37% · Render 20%

11 queries · avg 1.2ms · max 2.0ms

Render Breakdown

DB Logic (Pre-Render) 0.0135s

Python Logic (Pre-Render) 0.0116s

Full Page Render 0.0064s

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 [22:11:06.047] 2.0ms

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 [22:11:06.049] 1.7ms

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 [22:11:06.054] 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 [22:11:06.056] 1.3ms

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 [22:11:06.058] 1.0ms

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 [22:11:06.060] 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 [22:11:06.061] 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 [22:11:06.063] 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 [22:11:06.064] 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 [22:11:06.066] 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 [22:11:06.067] 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

Sportrap at E.J.Churchill at The Swinton Estate

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?