Back to Events

DTL — Down The Line

Down The Line at North Of England C.T.C

North Of England C.T.C

Saturday, 18 November 2023 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

91.9%

Field Average

97.7%

Highest Score

72.7%

Lowest Score

Top 3 Overall

🥈

Gerry Duffy

288/300

96.00%

🥇

Cliff Pain

293/300

97.67%

🥉 =3

David Garrett

Richard Blacker

286/300

95.33%

Event Difficulty

91.9% This Event

vs. North Of England C.T.C historical average (Down The Line)

↓ -1.7% harder than usual

Ground avg: 93.6%

Score Distribution

90–100%

20 83.3%

80–89%

3 12.5%

70–79%

1 4.2%

60–69%

0 0.0%

50–59%

0 0.0%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

83.3%

20 / 24

80%+

95.8%

23 / 24

70%+

100.0%

24 / 24

60%+

100.0%

24 / 24

50%+

100.0%

24 / 24

Class Breakdown

Class	Count	Average	High	Low	Winner
AA	4	93.8%	95.3%	91.3%	David Garrett
A	11	93.7%	97.7%	87.7%	Cliff Pain
B	6	89.8%	95.3%	72.7%	Richard Blacker
C	3	86.7%	90.0%	84.3%	Paul Worthington

Class Composition

4 16.7%

11 45.8%

6 25.0%

3 12.5%

Largest class: A — 11 competitors (45.8%)

Class Winners

AA 4 entered

286/300 — 95.33%

David Garrett

2: David Whitehead — 94.67%

A 11 entered

293/300 — 97.67%

Cliff Pain

2: Gerry Duffy — 96.00%

B 6 entered

286/300 — 95.33%

Richard Blacker

2: Brian Whitehead — 94.00%

C 3 entered

270/300 — 90.00%

Paul Worthington

2: Michael Ritson — 85.67%

Full Results — 24 entries

A Cliff Pain

293/300

97.7%

A Gerry Duffy

288/300

96.0%

AA David Garrett

286/300

95.3%

B Richard Blacker

286/300

95.3%

A David Taberner

285/300

95.0%

AA David Whitehead

284/300

94.7%

A Garry Sayles

284/300

94.7%

A David Magill

283/300

94.3%

A Paul Osborne

283/300

94.3%

B Brian Whitehead

282/300

94.0%

11=

B Caroline Whitehead

281/300

93.7%

11=

A Charlotte Kitchen

281/300

93.7%

11=

AA Stuart Kitchen

281/300

93.7%

A Mark Child

280/300

93.3%

15=

A George Turnes

278/300

92.7%

15=

B Stephen Clark

278/300

92.7%

17=

AA Christopher Jones

274/300

91.3%

17=

A Shaun Pullman

274/300

91.3%

B Eric Atkinson

272/300

90.7%

C Paul Worthington

270/300

90.0%

A John Adams

263/300

87.7%

C Michael Ritson

257/300

85.7%

C Katie Parker

253/300

84.3%

B Ellie Whitehead

218/300

72.7%

#	Name	Class	Score	Score %	Class Rank
1	Cliff Pain	A	293/300	97.67%	1
2	Gerry Duffy	A	288/300	96.00%	2
3=	David Garrett	AA	286/300	95.33%	1
3=	Richard Blacker	B	286/300	95.33%	1
5	David Taberner	A	285/300	95.00%	3
6=	David Whitehead	AA	284/300	94.67%	2
6=	Garry Sayles	A	284/300	94.67%	4
8=	David Magill	A	283/300	94.33%	5=
8=	Paul Osborne	A	283/300	94.33%	5=
10	Brian Whitehead	B	282/300	94.00%	2
11=	Caroline Whitehead	B	281/300	93.67%	3
11=	Charlotte Kitchen	A	281/300	93.67%	7
11=	Stuart Kitchen	AA	281/300	93.67%	3
14	Mark Child	A	280/300	93.33%	8
15=	George Turnes	A	278/300	92.67%	9
15=	Stephen Clark	B	278/300	92.67%	4
17=	Christopher Jones	AA	274/300	91.33%	4
17=	Shaun Pullman	A	274/300	91.33%	10
19	Eric Atkinson	B	272/300	90.67%	5
20	Paul Worthington	C	270/300	90.00%	1
21	John Adams	A	263/300	87.67%	11
22	Michael Ritson	C	257/300	85.67%	2
23	Katie Parker	C	253/300	84.33%	3
24	Ellie Whitehead	B	218/300	72.67%	6

Other DTL Events at North Of England C.T.C

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.038s ● FAST

DB 52% · Py 39% · Render 9%

11 queries · avg 1.8ms · max 5.7ms

Render Breakdown

DB Logic (Pre-Render) 0.0198s

Python Logic (Pre-Render) 0.0145s

Full Page Render 0.0033s

QUERY TABLES ▾

⚠ event_review 4× 0.006s

shoot_event 2× 0.007s

shoot_score 2× 0.004s

site_configuration 2× 0.002s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (11) — click to expand

#1 [05:24:09.120] 5.7ms

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 [05:24:09.123] 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 [05:24:09.126] 1.9ms

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 [05:24:09.128] 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 [05:24:09.133] 3.3ms

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 [05:24:09.134] 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 [05:24:09.136] 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 [05:24:09.137] 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 [05:24:09.139] 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 [05:24:09.140] 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 [05:24:09.141] 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 North Of England C.T.C

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?