Back to Events

DTL — Down The Line

Down The Line at Holmes Chapel Shooting Ground

Holmes Chapel Shooting Ground

Sunday, 22 June 2025 · CPSA Results →

Weather loading...

Event Rating

Latest Visitor Reviews

No written reviews yet.

112

Entries

90.8%

Field Average

98.7%

Highest Score

72.3%

Lowest Score

Top 3 Overall

🥈 =2

Alan Evans

Colin Heathcote

David Whitehead

Michael Turner

Tom Devaney

294/300

98.00%

🥇

Robert Collins

296/300

98.67%

Event Difficulty

90.8% This Event

vs. Holmes Chapel Shooting Ground historical average (Down The Line)

— About average difficulty

Ground avg: 91.3%

Class Winners

AA 26 entered

294/300 — 98.00%

Alan Evans(tied) Colin Heathcote(tied) David Whitehead(tied) Michael Turner(tied)

5=: John Stafford — 97.33%

A 38 entered

296/300 — 98.67%

Robert Collins

2: Tom Devaney — 98.00%

B 27 entered

290/300 — 96.67%

Dudley Coward

2: David Owen — 95.00%

C 21 entered

281/300 — 93.67%

Jeremy West

2: Nigel Farebrother — 90.67%

Field Shape

90.8%

Field avg

Down The Line at Holmes Chapel Shooting Ground had a 26.4 point scoring spread across 112 entries.

Spread 26.4 pts

Front 98.7%

Largest class A

A compact read of how the field performed: average, spread and where most shooters sat.

Score Distribution

90–100%

76 67.9%

80–89%

30 26.8%

70–79%

6 5.4%

60–69%

0 0.0%

50–59%

0 0.0%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

67.9%

76 / 112

80%+

94.6%

106 / 112

70%+

100.0%

112 / 112

60%+

100.0%

112 / 112

50%+

100.0%

112 / 112

Unlock the full event analysis

Register free for historical ground trends, class averages and spread, score charts, class composition and a detailed classification breakdown.

Historical Trends at Holmes Chapel Shooting Ground

Down The Line performance across events held at this ground.

Last 12 months

Overall Average Trend

Classification Trend Comparison

Classification Deep Dive

4 active classifications

—

Member insight

Typical —

Best —

Lowest —

Middle 50% score range

vs Ground Avg (12m)—

—

Member insight

Typical —

Best —

Lowest —

Middle 50% score range

vs Ground Avg (12m)—

—

Member insight

Typical —

Best —

Lowest —

Middle 50% score range

vs Ground Avg (12m)—

—

Member insight

Typical —

Best —

Lowest —

Middle 50% score range

vs Ground Avg (12m)—

Event Performance Analysis

Registered insight

Average by Class

Class averages make it easier to see where the event played hardest across the field.

Field Spread by Class

88.3-98.0%

79.7-98.7%

79.0-96.7%

72.3-93.7%

Boxes show the middle 50% of each class. Orange line is the median.

Top 10 Score Lollipop

A quick visual read of how far the front of the field separated itself.

Score Histogram

High gun: 98.7%. The high-gun band is outlined.

Class Breakdown

Rotate your device to see High/Low scores and the class winner

Class	Count	Average	High	Low	Winner
AA	26	94.8%	98.0%	88.3%	Alan Evans
A	38	92.7%	98.7%	79.7%	Robert Collins
B	27	88.7%	96.7%	79.0%	Dudley Coward
C	21	85.0%	93.7%	72.3%	Jeremy West

Class Composition

26 23.2%

38 33.9%

27 24.1%

21 18.8%

Largest class: A — 38 competitors (33.9%)

Full Results — 112 entries

🔒 The Class Rank and vs Class Avg columns are hidden — register free to unlock both insights.

Class A

Score 296/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 294/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 294/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 294/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 294/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 294/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 292/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 292/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 292/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 292/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 291/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 291/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 290/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 290/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 290/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 289/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 289/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 289/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 288/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 288/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 287/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 286/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 286/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 286/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 285/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 285/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 285/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 285/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 284/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 283/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 283/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 283/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 283/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 283/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 281/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 281/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 280/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 280/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 280/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 280/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 280/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 279/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 279/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 279/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 278/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 278/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 278/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 278/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 277/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 277/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 277/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 277/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 276/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 276/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 276/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 276/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 276/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 276/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 276/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 275/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 275/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 275/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 274/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 274/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 273/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 273/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 273/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 272/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 272/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 272/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 271/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 271/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 270/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 270/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 270/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 269/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 268/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 267/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 266/300

vs Class Avg +0.0%

Profile Open →

Class AA

Score 265/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 265/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 264/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 264/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 263/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 263/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 262/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 262/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 262/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 261/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 258/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 257/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 254/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 253/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 253/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 252/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 252/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 250/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 250/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 250/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 248/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 247/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 244/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 243/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 242/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 240/300

vs Class Avg +0.0%

Profile Open →

Class A

Score 239/300

vs Class Avg +0.0%

Profile Open →

Class B

Score 237/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 237/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 236/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 232/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 217/300

vs Class Avg +0.0%

Profile Open →

Class C

Score 93/100

vs Class Avg +0.0%

Profile Open →

#	Name	Class	Score	Score %	Class Rank 🔒	vs Class Avg
1	Robert Collins	A	296/300	98.67%	🔒 1	🔒 +0.0%
2=	Alan Evans	AA	294/300	98.00%	🔒 1	🔒 +0.0%
2=	Colin Heathcote	AA	294/300	98.00%	🔒 1	🔒 +0.0%
2=	David Whitehead	AA	294/300	98.00%	🔒 1	🔒 +0.0%
2=	Michael Turner	AA	294/300	98.00%	🔒 1	🔒 +0.0%
2=	Tom Devaney	A	294/300	98.00%	🔒 1	🔒 +0.0%
7=	Bernard Hutchinson	A	292/300	97.33%	🔒 1	🔒 +0.0%
7=	John Stafford	AA	292/300	97.33%	🔒 1	🔒 +0.0%
7=	Shaun Gardener	AA	292/300	97.33%	🔒 1	🔒 +0.0%
7=	Steven Janes	AA	292/300	97.33%	🔒 1	🔒 +0.0%
11=	Curtis Woolley	AA	291/300	97.00%	🔒 1	🔒 +0.0%
11=	Lewis Holden	A	291/300	97.00%	🔒 1	🔒 +0.0%
13=	Andy Leak	A	290/300	96.67%	🔒 1	🔒 +0.0%
13=	Dudley Coward	B	290/300	96.67%	🔒 1	🔒 +0.0%
13=	Iwan Mills	AA	290/300	96.67%	🔒 1	🔒 +0.0%
16=	Daniel Price	AA	289/300	96.33%	🔒 1	🔒 +0.0%
16=	Garry Sayles	A	289/300	96.33%	🔒 1	🔒 +0.0%
16=	Thomas Shaw	A	289/300	96.33%	🔒 1	🔒 +0.0%
19=	Paul Turner	AA	288/300	96.00%	🔒 1	🔒 +0.0%
19=	Will Palmer	A	288/300	96.00%	🔒 1	🔒 +0.0%
21	Peter Relph	AA	287/300	95.67%	🔒 1	🔒 +0.0%
22=	Keith Bond	AA	286/300	95.33%	🔒 1	🔒 +0.0%
22=	Mark Shaw	A	286/300	95.33%	🔒 1	🔒 +0.0%
22=	Nigel Chapman	AA	286/300	95.33%	🔒 1	🔒 +0.0%
25=	David Owen	B	285/300	95.00%	🔒 1	🔒 +0.0%
25=	Keith Waters	A	285/300	95.00%	🔒 1	🔒 +0.0%
25=	Paul Neal	AA	285/300	95.00%	🔒 1	🔒 +0.0%
25=	Stewart Wakefield	A	285/300	95.00%	🔒 1	🔒 +0.0%
29	John Titterington	B	284/300	94.67%	🔒 1	🔒 +0.0%
30=	David Priestman	AA	283/300	94.33%	🔒 1	🔒 +0.0%
30=	John Simmons	A	283/300	94.33%	🔒 1	🔒 +0.0%
30=	Lee Wilcoxson	AA	283/300	94.33%	🔒 1	🔒 +0.0%
30=	Paul Meakin	AA	283/300	94.33%	🔒 1	🔒 +0.0%
30=	Stephen Eley	AA	283/300	94.33%	🔒 1	🔒 +0.0%
35=	Jeremy West	C	281/300	93.67%	🔒 1	🔒 +0.0%
35=	Philip Mills	A	281/300	93.67%	🔒 1	🔒 +0.0%
37=	Andrew Laverack	B	280/300	93.33%	🔒 1	🔒 +0.0%
37=	Jason Linnell	A	280/300	93.33%	🔒 1	🔒 +0.0%
37=	Mike Hartley	A	280/300	93.33%	🔒 1	🔒 +0.0%
37=	Rodney Dalton	B	280/300	93.33%	🔒 1	🔒 +0.0%
37=	Russell Holden	A	280/300	93.33%	🔒 1	🔒 +0.0%
42=	Brian Whitehead	B	279/300	93.00%	🔒 1	🔒 +0.0%
42=	John Bailey	A	279/300	93.00%	🔒 1	🔒 +0.0%
42=	Rhys Evans	B	279/300	93.00%	🔒 1	🔒 +0.0%
45=	Ellie Whitehead	A	278/300	92.67%	🔒 1	🔒 +0.0%
45=	Geoffrey Nutter	A	278/300	92.67%	🔒 1	🔒 +0.0%
45=	John Tennison	A	278/300	92.67%	🔒 1	🔒 +0.0%
45=	Steven Dutton	A	278/300	92.67%	🔒 1	🔒 +0.0%
49=	Chris Holden	B	277/300	92.33%	🔒 1	🔒 +0.0%
49=	Joanna Fairclough	A	277/300	92.33%	🔒 1	🔒 +0.0%
49=	Norman Scott	A	277/300	92.33%	🔒 1	🔒 +0.0%
49=	Paul Sant	A	277/300	92.33%	🔒 1	🔒 +0.0%
53=	David Garrett	AA	276/300	92.00%	🔒 1	🔒 +0.0%
53=	David Waring	B	276/300	92.00%	🔒 1	🔒 +0.0%
53=	Joshua Kind	A	276/300	92.00%	🔒 1	🔒 +0.0%
53=	Mark Child	A	276/300	92.00%	🔒 1	🔒 +0.0%
53=	Paul Osborne	B	276/300	92.00%	🔒 1	🔒 +0.0%
53=	Peter Thomas	AA	276/300	92.00%	🔒 1	🔒 +0.0%
53=	Sarah Milroy	B	276/300	92.00%	🔒 1	🔒 +0.0%
60=	Grant MacDougall	A	275/300	91.67%	🔒 1	🔒 +0.0%
60=	Harry Lufflum	AA	275/300	91.67%	🔒 1	🔒 +0.0%
60=	John Barnett	A	275/300	91.67%	🔒 1	🔒 +0.0%
63=	David Bell	A	274/300	91.33%	🔒 1	🔒 +0.0%
63=	Russell Thomas	B	274/300	91.33%	🔒 1	🔒 +0.0%
65=	Allan Hilton	A	273/300	91.00%	🔒 1	🔒 +0.0%
65=	Edward Armett	AA	273/300	91.00%	🔒 1	🔒 +0.0%
65=	Ian Douglas	AA	273/300	91.00%	🔒 1	🔒 +0.0%
68=	Bob Singleton	A	272/300	90.67%	🔒 1	🔒 +0.0%
68=	David Stanbrook	B	272/300	90.67%	🔒 1	🔒 +0.0%
68=	Nigel Farebrother	C	272/300	90.67%	🔒 1	🔒 +0.0%
71=	Alan Davies	A	271/300	90.33%	🔒 1	🔒 +0.0%
71=	Jane Hitchmough	C	271/300	90.33%	🔒 1	🔒 +0.0%
73=	Alan Hall	B	270/300	90.00%	🔒 1	🔒 +0.0%
73=	John Hindle	C	270/300	90.00%	🔒 1	🔒 +0.0%
73=	John Owen	B	270/300	90.00%	🔒 1	🔒 +0.0%
76	Tom Robinson	AA	269/300	89.67%	🔒 1	🔒 +0.0%
77	Michael Dale	B	268/300	89.33%	🔒 1	🔒 +0.0%
78	Neil Farnsworth	A	267/300	89.00%	🔒 1	🔒 +0.0%
79	Diana Barnett	C	266/300	88.67%	🔒 1	🔒 +0.0%
80=	Christopher Moule	AA	265/300	88.33%	🔒 1	🔒 +0.0%
80=	Nigel Lovatt	A	265/300	88.33%	🔒 1	🔒 +0.0%
82=	Caroline Stanbrook	A	264/300	88.00%	🔒 1	🔒 +0.0%
82=	Grahame Mitchell	C	264/300	88.00%	🔒 1	🔒 +0.0%
84=	Barry Randall	A	263/300	87.67%	🔒 1	🔒 +0.0%
84=	Neil Passey	B	263/300	87.67%	🔒 1	🔒 +0.0%
86=	John Mackin	A	262/300	87.33%	🔒 1	🔒 +0.0%
86=	Michael Hartley	B	262/300	87.33%	🔒 1	🔒 +0.0%
86=	Paul Harrison	C	262/300	87.33%	🔒 1	🔒 +0.0%
89	Jerry Czachar	C	261/300	87.00%	🔒 1	🔒 +0.0%
90	Stuart Burgess	B	258/300	86.00%	🔒 1	🔒 +0.0%
91	Katie Parker	C	257/300	85.67%	🔒 1	🔒 +0.0%
92	John Jones	C	254/300	84.67%	🔒 1	🔒 +0.0%
93=	David Wallbank	C	253/300	84.33%	🔒 1	🔒 +0.0%
93=	Eric Cottrell	C	253/300	84.33%	🔒 1	🔒 +0.0%
95=	Andrew Milroy	C	252/300	84.00%	🔒 1	🔒 +0.0%
95=	John Mason	B	252/300	84.00%	🔒 1	🔒 +0.0%
97=	Angus MacDonald	B	250/300	83.33%	🔒 1	🔒 +0.0%
97=	Paul Kelly	B	250/300	83.33%	🔒 1	🔒 +0.0%
97=	Robin Dennis	C	250/300	83.33%	🔒 1	🔒 +0.0%
100	Emrys Roberts	B	248/300	82.67%	🔒 1	🔒 +0.0%
101	Roy McGovern	B	247/300	82.33%	🔒 1	🔒 +0.0%
102	Paul Worthington	B	244/300	81.33%	🔒 1	🔒 +0.0%
103	Emlyn Davies	C	243/300	81.00%	🔒 1	🔒 +0.0%
104	S Vella	C	242/300	80.67%	🔒 1	🔒 +0.0%
105	Mick Abrams	B	240/300	80.00%	🔒 1	🔒 +0.0%
106	Julie Burton	A	239/300	79.67%	🔒 1	🔒 +0.0%
107=	Stephen Scudder	B	237/300	79.00%	🔒 1	🔒 +0.0%
107=	Steven Pape	C	237/300	79.00%	🔒 1	🔒 +0.0%
109	Keith Jones	C	236/300	78.67%	🔒 1	🔒 +0.0%
110	Mr CK Hollowell	C	232/300	77.33%	🔒 1	🔒 +0.0%
111	Sheila Oliver	C	217/300	72.33%	🔒 1	🔒 +0.0%
112	Ian Palmer	C	93/100	93.00%	🔒 1	🔒 +0.0%

Other DTL Events at Holmes Chapel Shooting Ground

⚙ Performance Stats DRAG TO MOVE

0.037s ● FAST

DB 35% · Py 36% · Render 28%

12 queries · avg 1.1ms · max 1.7ms

Render Breakdown

Python Logic (Pre-Render) 0.0132s

DB Logic (Pre-Render) 0.0129s

Full Page Render 0.0104s

QUERY TABLES ▾

⚠ event_review 4× 0.003s

shoot_event 2× 0.003s

shoot_score 2× 0.003s

site_configuration 2× 0.002s

ground 1× 0.001s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (12) — click to expand

#1 [02:23:19.145] 1.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 [02:23:19.147] 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 [02:23:19.153] 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 [02:23:19.155] 1.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_…

#5 [02:23:19.156] 0.9ms

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 [02:23:19.158] 0.8ms

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 [02:23:19.159] 0.9ms

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 [02:23:19.160] 0.8ms

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 [02:23:19.162] 0.8ms

ground

SELECT ground.id AS ground_id, ground.name AS ground_name, ground.url AS ground_url, ground.postcode AS ground_postcode, ground.what3words AS ground_what3words, ground.email AS ground_email, ground.website AS ground_website, ground.num_events_cpsa AS ground_num_events_cpsa, ground.num_events_cpsa_la…

#10 [02:23:19.163] 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

#11 [02:23:19.165] 0.8ms

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)

#12 [02:23:19.166] 0.8ms

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 Holmes Chapel Shooting Ground

Unlock the full event analysis

Historical Trends at Holmes Chapel Shooting Ground

Classification Deep Dive

Event Performance Analysis

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?