Back to Events

ESP — English Sporting

English Sporting at Horne CPC (Gatton Bottom)

Horne CPC (Gatton Bottom)

Sunday, 16 October 2011 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

79.0%

Field Average

96.0%

Highest Score

53.0%

Lowest Score

Top 3 Overall

🥈

Mark Marshall

AAA

0/0

95.00%

🥇

Ross Straker

AAA

0/0

96.00%

🥉 =3

David Tagg

Martin Goldie

William Steyn

AAA

0/0

90.00%

Event Difficulty

79.0% This Event

vs. Horne CPC (Gatton Bottom) historical average (English Sporting)

↑ +0.7% easier than usual

Ground avg: 78.3%

Score Distribution

90–100%

5 15.2%

80–89%

14 42.4%

70–79%

7 21.2%

60–69%

5 15.2%

50–59%

2 6.1%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

15.2%

5 / 33

80%+

57.6%

19 / 33

70%+

78.8%

26 / 33

60%+

93.9%

31 / 33

50%+

100.0%

33 / 33

Class Breakdown

Class	Count	Average	High	Low	Winner
AAA	5	90.2%	96.0%	84.0%	Ross Straker
AA	4	89.0%	90.0%	88.0%	David Tagg
A	7	83.1%	89.0%	76.0%	Anthony Hoskins
B	6	77.8%	83.0%	65.0%	Sam King
C	7	71.4%	80.0%	63.0%	Jon Anderson
Other	4	63.0%	78.0%	53.0%	David Brown

Class Composition

AAA

5 15.2%

4 12.1%

7 21.2%

6 18.2%

7 21.2%

Other

4 12.1%

Largest class: A — 7 competitors (21.2%)

Class Winners

AAA 5 entered

0/0 — 96.00%

Ross Straker

2: Mark Marshall — 95.00%

AA 4 entered

0/0 — 90.00%

David Tagg(tied) Martin Goldie(tied)

3=: Graham Peck — 88.00%

A 7 entered

0/0 — 89.00%

Anthony Hoskins

2: Salvatore Dimaria — 88.00%

B 6 entered

0/0 — 83.00%

Sam King

2=: Paul Curtis — 82.00%

C 7 entered

0/0 — 80.00%

Jon Anderson

2: Barry Taylor — 78.00%

Other 4 entered

0/0 — 78.00%

David Brown

2: Russell Humphries — 66.00%

Full Results — 33 entries

AAA Ross Straker

0/0

96.0%

AAA Mark Marshall

0/0

95.0%

AA David Tagg

0/0

90.0%

AA Martin Goldie

0/0

90.0%

AAA William Steyn

0/0

90.0%

A Anthony Hoskins

0/0

89.0%

AA Graham Peck

0/0

88.0%

AA Kevin Johnston

0/0

88.0%

A Salvatore Dimaria

0/0

88.0%

AAA Jeffrey Russell

0/0

86.0%

A Paul Poulter

0/0

85.0%

12=

AAA James Attwood

0/0

84.0%

12=

A Stephen Attwood

0/0

84.0%

B Sam King

0/0

83.0%

15=

A Anthony Brown

0/0

82.0%

15=

B Paul Curtis

0/0

82.0%

15=

B Steve Warren

0/0

82.0%

B John Reynolds

0/0

81.0%

C Jon Anderson

0/0

80.0%

20=

C Barry Taylor

0/0

78.0%

20=

Unknown David Brown

0/0

78.0%

20=

A Nigel Kent

0/0

78.0%

23=

C LG Millard

0/0

76.0%

23=

A Melvyn Austin

0/0

76.0%

25=

C Paul Payne

0/0

74.0%

25=

B Shaun Miller

0/0

74.0%

27=

C Caroline Hebard

0/0

66.0%

27=

Unknown Russell Humphries

0/0

66.0%

B Frank Dean

0/0

65.0%

30=

C Mr RM Hamilton

0/0

63.0%

30=

C Norma Curtis

0/0

63.0%

Unknown David Spackman

0/0

55.0%

Unknown David Lovell

0/0

53.0%

#	Name	Class	Score	Score %	Class Rank
1	Ross Straker	AAA	0/0	96.00%	1
2	Mark Marshall	AAA	0/0	95.00%	2
3=	David Tagg	AA	0/0	90.00%	1=
3=	Martin Goldie	AA	0/0	90.00%	1=
3=	William Steyn	AAA	0/0	90.00%	3
6	Anthony Hoskins	A	0/0	89.00%	1
7=	Graham Peck	AA	0/0	88.00%	3=
7=	Kevin Johnston	AA	0/0	88.00%	3=
7=	Salvatore Dimaria	A	0/0	88.00%	2
10	Jeffrey Russell	AAA	0/0	86.00%	4
11	Paul Poulter	A	0/0	85.00%	3
12=	James Attwood	AAA	0/0	84.00%	5
12=	Stephen Attwood	A	0/0	84.00%	4
14	Sam King	B	0/0	83.00%	1
15=	Anthony Brown	A	0/0	82.00%	5
15=	Paul Curtis	B	0/0	82.00%	2=
15=	Steve Warren	B	0/0	82.00%	2=
18	John Reynolds	B	0/0	81.00%	4
19	Jon Anderson	C	0/0	80.00%	1
20=	Barry Taylor	C	0/0	78.00%	2
20=	David Brown	Unknown	0/0	78.00%	1
20=	Nigel Kent	A	0/0	78.00%	6
23=	LG Millard	C	0/0	76.00%	3
23=	Melvyn Austin	A	0/0	76.00%	7
25=	Paul Payne	C	0/0	74.00%	4
25=	Shaun Miller	B	0/0	74.00%	5
27=	Caroline Hebard	C	0/0	66.00%	5
27=	Russell Humphries	Unknown	0/0	66.00%	2
29	Frank Dean	B	0/0	65.00%	6
30=	Mr RM Hamilton	C	0/0	63.00%	6=
30=	Norma Curtis	C	0/0	63.00%	6=
32	David Spackman	Unknown	0/0	55.00%	3
33	David Lovell	Unknown	0/0	53.00%	4

Other ESP Events at Horne CPC (Gatton Bottom)

⚙ Performance Stats DRAG TO MOVE

0.040s ● FAST

DB 37% · Py 48% · Render 16%

11 queries · avg 1.3ms · max 2.2ms

Render Breakdown

Python Logic (Pre-Render) 0.0188s

DB Logic (Pre-Render) 0.0146s

Full Page Render 0.0063s

QUERY TABLES ▾

⚠ event_review 4× 0.004s

shoot_event 2× 0.003s

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 [22:10:25.365] 2.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_…

#2 [22:10:25.367] 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 [22:10:25.376] 2.1ms

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:10:25.378] 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:10:25.380] 1.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 [22:10:25.382] 1.1ms

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:10:25.384] 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:10:25.385] 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:10:25.387] 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:10:25.388] 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 IN (%(key_1_1)s, %(key_1_2)s, %(key_1_3)s, %(key_1_4)s)

#11 [22:10:25.390] 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

English Sporting at Horne CPC (Gatton Bottom)

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?