Back to Events

DTL — Down The Line

Down The Line at Bywell Shooting Ground

Bywell Shooting Ground

Saturday, 05 October 2024 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

90.9%

Field Average

99.0%

Highest Score

75.0%

Lowest Score

Top 3 Overall

🥈

George Turnes

294/300

98.00%

🥇

Tony Common

297/300

99.00%

🥉 =3

Christopher Jones

Stuart Kitchen

291/300

97.00%

Event Difficulty

90.9% This Event

vs. Bywell Shooting Ground historical average (Down The Line)

— About average difficulty

Ground avg: 91.1%

Score Distribution

90–100%

19 70.4%

80–89%

5 18.5%

70–79%

3 11.1%

60–69%

0 0.0%

50–59%

0 0.0%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

70.4%

19 / 27

80%+

88.9%

24 / 27

70%+

100.0%

27 / 27

60%+

100.0%

27 / 27

50%+

100.0%

27 / 27

Class Breakdown

Class	Count	Average	High	Low	Winner
AA	4	95.9%	99.0%	92.3%	Tony Common
A	9	93.9%	98.0%	88.7%	George Turnes
B	9	87.3%	96.0%	75.0%	Grant MacDougall
C	5	88.1%	92.0%	79.0%	David Nicholson

Class Composition

4 14.8%

9 33.3%

5 18.5%

Largest class: A — 9 competitors (33.3%)

Class Winners

AA 4 entered

297/300 — 99.00%

Tony Common

2: Ian Douglas — 96.33%

A 9 entered

294/300 — 98.00%

George Turnes

2=: Christopher Jones — 97.00%

B 9 entered

288/300 — 96.00%

Grant MacDougall

2: Andrew Jones — 94.33%

C 5 entered

276/300 — 92.00%

David Nicholson(tied) James Petty(tied)

3: Michael Ritson — 91.33%

Full Results — 27 entries

AA Tony Common

297/300

99.0%

A George Turnes

294/300

98.0%

A Christopher Jones

291/300

97.0%

A Stuart Kitchen

291/300

97.0%

AA Ian Douglas

289/300

96.3%

AA Bob Clark

288/300

96.0%

B Grant MacDougall

288/300

96.0%

A Neil Dickinson

284/300

94.7%

B Andrew Jones

283/300

94.3%

A John Wilkinson

283/300

94.3%

B David Bell

279/300

93.0%

A Cliff Pain

278/300

92.7%

AA Elliott Cutter

277/300

92.3%

14=

C David Nicholson

276/300

92.0%

14=

C James Petty

276/300

92.0%

14=

B Nicholas Simpson

276/300

92.0%

14=

A Nigel Lovatt

276/300

92.0%

C Michael Ritson

274/300

91.3%

A David Greenhowe

272/300

90.7%

A Christopher Dickinson

266/300

88.7%

B Eric Atkinson

263/300

87.7%

B Michael Wathen

260/300

86.7%

C James Steer

259/300

86.3%

B Mervyn Turkington

256/300

85.3%

C Shaun Gibson

237/300

79.0%

B Alan Coates

227/300

75.7%

B David Leslie

225/300

75.0%

#	Name	Class	Score	Score %	Class Rank
1	Tony Common	AA	297/300	99.00%	1
2	George Turnes	A	294/300	98.00%	1
3=	Christopher Jones	A	291/300	97.00%	2=
3=	Stuart Kitchen	A	291/300	97.00%	2=
5	Ian Douglas	AA	289/300	96.33%	2
6=	Bob Clark	AA	288/300	96.00%	3
6=	Grant MacDougall	B	288/300	96.00%	1
8	Neil Dickinson	A	284/300	94.67%	4
9=	Andrew Jones	B	283/300	94.33%	2
9=	John Wilkinson	A	283/300	94.33%	5
11	David Bell	B	279/300	93.00%	3
12	Cliff Pain	A	278/300	92.67%	6
13	Elliott Cutter	AA	277/300	92.33%	4
14=	David Nicholson	C	276/300	92.00%	1=
14=	James Petty	C	276/300	92.00%	1=
14=	Nicholas Simpson	B	276/300	92.00%	4
14=	Nigel Lovatt	A	276/300	92.00%	7
18	Michael Ritson	C	274/300	91.33%	3
19	David Greenhowe	A	272/300	90.67%	8
20	Christopher Dickinson	A	266/300	88.67%	9
21	Eric Atkinson	B	263/300	87.67%	5
22	Michael Wathen	B	260/300	86.67%	6
23	James Steer	C	259/300	86.33%	4
24	Mervyn Turkington	B	256/300	85.33%	7
25	Shaun Gibson	C	237/300	79.00%	5
26	Alan Coates	B	227/300	75.67%	8
27	David Leslie	B	225/300	75.00%	9

Other DTL Events at Bywell Shooting Ground

Analyzing Data...

Connecting to CPSA...

Initial Scores

History Pages

Classifications

Fixture Details

Analyzing Data...

Connecting to CPSA...

Initial Scores

History Pages

Classifications

Fixture Details

⚙ Performance Stats DRAG TO MOVE

0.035s ● FAST

DB 53% · Py 28% · Render 20%

11 queries · avg 1.7ms · max 4.3ms

Render Breakdown

DB Logic (Pre-Render) 0.0185s

Python Logic (Pre-Render) 0.0096s

Full Page Render 0.0069s

QUERY TABLES ▾

⚠ event_review 4× 0.004s

shoot_event 2× 0.003s

shoot_score 2× 0.006s

site_configuration 2× 0.004s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (11) — click to expand

#1 [22:08:12.924] 2.1ms

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:08:12.926] 1.5ms

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:08:12.932] 4.3ms

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:08:12.934] 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 [22:08:12.935] 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 [22:08:12.937] 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:08:12.938] 1.1ms

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:08:12.940] 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:08:12.942] 1.0ms

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:08:12.946] 3.2ms

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:08:12.947] 1.0ms

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

Down The Line at Bywell Shooting Ground

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?