Back to Events

STR — Sportrap

Sportrap at Clacton Gun Club

Clacton Gun Club

Monday, 27 May 2019 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

79.2%

Field Average

92.0%

Highest Score

60.0%

Lowest Score

Top 3 Overall

🥉

Adam Cocker

91/100

91.00%

🥇 =1

Ian Schwier

Pietro Mastroeni

AAA

92/100

92.00%

Event Difficulty

79.2% This Event

vs. Clacton Gun Club historical average (Sportrap)

↑ +2.5% easier than usual

Ground avg: 76.7%

Score Distribution

90–100%

7 17.1%

80–89%

15 36.6%

70–79%

13 31.7%

60–69%

6 14.6%

50–59%

0 0.0%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

17.1%

7 / 41

80%+

53.7%

22 / 41

70%+

85.4%

35 / 41

60%+

100.0%

41 / 41

50%+

100.0%

41 / 41

Class Breakdown

Class	Count	Average	High	Low	Winner
AAA	1	92.0%	92.0%	92.0%	Pietro Mastroeni
AA	3	88.3%	92.0%	83.0%	Ian Schwier
A	13	84.5%	91.0%	72.0%	Adam Cocker
B	8	80.9%	87.0%	71.0%	Andrew Cutter
C	15	72.3%	90.0%	60.0%	William Page
Other	1	60.0%	60.0%	60.0%	Sharon Goldsmith

Class Composition

AAA

1 2.4%

3 7.3%

13 31.7%

8 19.5%

15 36.6%

Other

1 2.4%

Largest class: C — 15 competitors (36.6%)

Class Winners

AAA 1 entered

92/100 — 92.00%

Pietro Mastroeni

AA 3 entered

92/100 — 92.00%

Ian Schwier

2: Kevin Norfolk — 90.00%

A 13 entered

91/100 — 91.00%

Adam Cocker

2=: Dave Bignell — 90.00%

B 8 entered

87/100 — 87.00%

Andrew Cutter

2: Ricardo Sloley — 85.00%

C 15 entered

90/100 — 90.00%

William Page

2=: Edward Russell — 77.00%

Other 1 entered

60/100 — 60.00%

Sharon Goldsmith

Full Results — 41 entries

AA Ian Schwier

92/100

92.0%

AAA Pietro Mastroeni

92/100

92.0%

A Adam Cocker

91/100

91.0%

A Dave Bignell

90/100

90.0%

A Jack Greenleaf

90/100

90.0%

AA Kevin Norfolk

90/100

90.0%

C William Page

90/100

90.0%

A Clint Brumbley

88/100

88.0%

B Andrew Cutter

87/100

87.0%

A Andy Walker

87/100

87.0%

A David Pointer

87/100

87.0%

A Trevor Hearn

86/100

86.0%

13=

A John Price

85/100

85.0%

13=

B Ricardo Sloley

85/100

85.0%

B Steven Willis

84/100

84.0%

16=

A Adrian Goodchild

83/100

83.0%

16=

AA Laurence Greenleaf

83/100

83.0%

B Tim Butcher

82/100

82.0%

19=

B Colin Fowler

81/100

81.0%

19=

B Mr PM Tutton

81/100

81.0%

19=

A Nadine Gilder

81/100

81.0%

A Christopher Willis

80/100

80.0%

A Jonathan Buckenham

78/100

78.0%

24=

C Edward Russell

77/100

77.0%

24=

C Richard Potter

77/100

77.0%

26=

B Ed Paine

76/100

76.0%

26=

C Paul Williams

76/100

76.0%

28=

C Darren Coham

74/100

74.0%

28=

C John Hewitt

74/100

74.0%

28=

C Martin Faint

74/100

74.0%

A Nigel Gilder

72/100

72.0%

32=

C Adrian Masterson

71/100

71.0%

32=

C David Smith

71/100

71.0%

32=

C Iain Elliott

71/100

71.0%

32=

B Michael Johnson

71/100

71.0%

36=

C Heather Pointer

69/100

69.0%

36=

C Mark Vyse

69/100

69.0%

38=

C Paul Bryan

66/100

66.0%

38=

C Stephen Root

66/100

66.0%

40=

C David Everard

60/100

60.0%

40=

Unknown Sharon Goldsmith

60/100

60.0%

#	Name	Class	Score	Score %	Class Rank
1=	Ian Schwier	AA	92/100	92.00%	1
1=	Pietro Mastroeni	AAA	92/100	92.00%	1
3	Adam Cocker	A	91/100	91.00%	1
4=	Dave Bignell	A	90/100	90.00%	2=
4=	Jack Greenleaf	A	90/100	90.00%	2=
4=	Kevin Norfolk	AA	90/100	90.00%	2
4=	William Page	C	90/100	90.00%	1
8	Clint Brumbley	A	88/100	88.00%	4
9=	Andrew Cutter	B	87/100	87.00%	1
9=	Andy Walker	A	87/100	87.00%	5=
9=	David Pointer	A	87/100	87.00%	5=
12	Trevor Hearn	A	86/100	86.00%	7
13=	John Price	A	85/100	85.00%	8
13=	Ricardo Sloley	B	85/100	85.00%	2
15	Steven Willis	B	84/100	84.00%	3
16=	Adrian Goodchild	A	83/100	83.00%	9
16=	Laurence Greenleaf	AA	83/100	83.00%	3
18	Tim Butcher	B	82/100	82.00%	4
19=	Colin Fowler	B	81/100	81.00%	5=
19=	Mr PM Tutton	B	81/100	81.00%	5=
19=	Nadine Gilder	A	81/100	81.00%	10
22	Christopher Willis	A	80/100	80.00%	11
23	Jonathan Buckenham	A	78/100	78.00%	12
24=	Edward Russell	C	77/100	77.00%	2=
24=	Richard Potter	C	77/100	77.00%	2=
26=	Ed Paine	B	76/100	76.00%	7
26=	Paul Williams	C	76/100	76.00%	4
28=	Darren Coham	C	74/100	74.00%	5=
28=	John Hewitt	C	74/100	74.00%	5=
28=	Martin Faint	C	74/100	74.00%	5=
31	Nigel Gilder	A	72/100	72.00%	13
32=	Adrian Masterson	C	71/100	71.00%	8=
32=	David Smith	C	71/100	71.00%	8=
32=	Iain Elliott	C	71/100	71.00%	8=
32=	Michael Johnson	B	71/100	71.00%	8
36=	Heather Pointer	C	69/100	69.00%	11=
36=	Mark Vyse	C	69/100	69.00%	11=
38=	Paul Bryan	C	66/100	66.00%	13=
38=	Stephen Root	C	66/100	66.00%	13=
40=	David Everard	C	60/100	60.00%	15
40=	Sharon Goldsmith	Unknown	60/100	60.00%	1

Other STR Events at Clacton Gun Club

⚙ Performance Stats DRAG TO MOVE

0.072s ● FAST

DB 22% · Py 73% · Render 5%

11 queries · avg 1.4ms · max 3.2ms

Render Breakdown

Python Logic (Pre-Render) 0.0527s

DB Logic (Pre-Render) 0.0155s

Full Page Render 0.0038s

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:02:30.366] 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:02:30.369] 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 [22:02:30.417] 3.2ms

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:02:30.419] 1.4ms

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:02:30.421] 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:02:30.423] 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:02:30.424] 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:02:30.426] 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…

#9 [22:02:30.427] 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:02:30.429] 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:02:30.430] 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

Sportrap at Clacton Gun Club

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?