Back to Events

STR — Sportrap

Sportrap at Southdown Gun Club Ltd

Southdown Gun Club Ltd

Sunday, 23 February 2014 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

70.9%

Field Average

89.0%

Highest Score

51.0%

Lowest Score

Top 3 Overall

🥈

Gary Robins

0/0

84.00%

🥇

Neil Lockton

0/0

89.00%

🥉

Nigel Frampton

0/0

82.00%

Event Difficulty

70.9% This Event

vs. Southdown Gun Club Ltd historical average (Sportrap)

↓ -8.5% harder than usual

Ground avg: 79.4%

Score Distribution

90–100%

0 0.0%

80–89%

5 20.0%

70–79%

10 40.0%

60–69%

5 20.0%

50–59%

5 20.0%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

0 / 25

80%+

20.0%

5 / 25

70%+

60.0%

15 / 25

60%+

80.0%

20 / 25

50%+

100.0%

25 / 25

Class Breakdown

Class	Count	Average	High	Low	Winner
AAA	2	76.0%	77.0%	75.0%	Sean Gamblen
AA	4	77.0%	89.0%	71.0%	Neil Lockton
A	8	77.6%	84.0%	67.0%	Gary Robins
B	4	66.5%	74.0%	55.0%	Mark Webb
C	6	57.8%	69.0%	51.0%	Douglas Millard
Other	1	78.0%	78.0%	78.0%	Andrew Vine

Class Composition

AAA

2 8.0%

4 16.0%

8 32.0%

4 16.0%

6 24.0%

Other

1 4.0%

Largest class: A — 8 competitors (32.0%)

Class Winners

AAA 2 entered

0/0 — 77.00%

Sean Gamblen

2: Trevor Bell — 75.00%

AA 4 entered

0/0 — 89.00%

Neil Lockton

2: Adrian Balham — 75.00%

A 8 entered

0/0 — 84.00%

Gary Robins

2: Nigel Frampton — 82.00%

B 4 entered

0/0 — 74.00%

Mark Webb

2: Jeffrey Dix — 69.00%

C 6 entered

0/0 — 69.00%

Douglas Millard

2: Leslie Christy — 65.00%

Other 1 entered

0/0 — 78.00%

Andrew Vine

Full Results — 25 entries

AA Neil Lockton

0/0

89.0%

A Gary Robins

0/0

84.0%

A Nigel Frampton

0/0

82.0%

A Stephen Attwood

0/0

81.0%

A Matt Watling

0/0

80.0%

Unknown Andrew Vine

0/0

78.0%

A Martin Goldie

0/0

77.0%

AAA Sean Gamblen

0/0

77.0%

A Matt Bell

0/0

76.0%

10=

AA Adrian Balham

0/0

75.0%

10=

AAA Trevor Bell

0/0

75.0%

12=

B Mark Webb

0/0

74.0%

12=

A Philip Buxton

0/0

74.0%

AA James Attwood

0/0

73.0%

AA Ron King

0/0

71.0%

16=

C Douglas Millard

0/0

69.0%

16=

B Jeffrey Dix

0/0

69.0%

B Stuart Clements

0/0

68.0%

A Antony Burt

0/0

67.0%

C Leslie Christy

0/0

65.0%

C Massimo Pani

0/0

59.0%

B George Keys

0/0

55.0%

C Glenn Dryer

0/0

52.0%

24=

C Jonathan Howe

0/0

51.0%

24=

C Shaun Miller

0/0

51.0%

#	Name	Class	Score	Score %	Class Rank
1	Neil Lockton	AA	0/0	89.00%	1
2	Gary Robins	A	0/0	84.00%	1
3	Nigel Frampton	A	0/0	82.00%	2
4	Stephen Attwood	A	0/0	81.00%	3
5	Matt Watling	A	0/0	80.00%	4
6	Andrew Vine	Unknown	0/0	78.00%	1
7=	Martin Goldie	A	0/0	77.00%	5
7=	Sean Gamblen	AAA	0/0	77.00%	1
9	Matt Bell	A	0/0	76.00%	6
10=	Adrian Balham	AA	0/0	75.00%	2
10=	Trevor Bell	AAA	0/0	75.00%	2
12=	Mark Webb	B	0/0	74.00%	1
12=	Philip Buxton	A	0/0	74.00%	7
14	James Attwood	AA	0/0	73.00%	3
15	Ron King	AA	0/0	71.00%	4
16=	Douglas Millard	C	0/0	69.00%	1
16=	Jeffrey Dix	B	0/0	69.00%	2
18	Stuart Clements	B	0/0	68.00%	3
19	Antony Burt	A	0/0	67.00%	8
20	Leslie Christy	C	0/0	65.00%	2
21	Massimo Pani	C	0/0	59.00%	3
22	George Keys	B	0/0	55.00%	4
23	Glenn Dryer	C	0/0	52.00%	4
24=	Jonathan Howe	C	0/0	51.00%	5=
24=	Shaun Miller	C	0/0	51.00%	5=

Other STR Events at Southdown Gun Club Ltd

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

DB 52% · Py 38% · Render 10%

11 queries · avg 1.4ms · max 3.1ms

Render Breakdown

DB Logic (Pre-Render) 0.0152s

Python Logic (Pre-Render) 0.0112s

Full Page Render 0.0030s

QUERY TABLES ▾

⚠ event_review 4× 0.004s

shoot_event 2× 0.003s

shoot_score 2× 0.005s

site_configuration 2× 0.002s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (11) — click to expand

#1 [22:09:08.509] 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:09:08.511] 1.4ms

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:09:08.516] 3.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:09:08.519] 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:09:08.521] 1.4ms

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:09:08.523] 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:09:08.524] 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:09:08.526] 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:09:08.527] 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:09:08.529] 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:09:08.530] 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 Southdown Gun Club Ltd

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?