Back to Events

AR — AR

All Round at Clacton Gun Club

Clacton Gun Club

Saturday, 09 February 2019 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

69.0%

Field Average

89.0%

Highest Score

39.0%

Lowest Score

Top 3 Overall

🥈 =2

Adam Cocker

Robert Humphreys

82/100

82.00%

🥇

Clive Scase

89/100

89.00%

Event Difficulty

69.0% This Event

vs. Clacton Gun Club historical average (AR)

↓ -5.4% harder than usual

Ground avg: 74.4%

Score Distribution

90–100%

0 0.0%

80–89%

3 12.5%

70–79%

9 37.5%

60–69%

8 33.3%

50–59%

2 8.3%

<50%

2 8.3%

Field Achievement

% of competitors reaching each score threshold

90%+

0 / 24

80%+

12.5%

3 / 24

70%+

50.0%

12 / 24

60%+

83.3%

20 / 24

50%+

91.7%

22 / 24

Class Breakdown

Class	Count	Average	High	Low	Winner
AA	5	79.6%	89.0%	68.0%	Clive Scase
A	7	68.9%	79.0%	55.0%	Laurence Greenleaf
B	7	73.3%	79.0%	67.0%	Dave Bignell
C	2	57.0%	63.0%	51.0%	Tina Henshaw
Other	3	49.3%	69.0%	39.0%	Mark Lyes

Class Composition

5 20.8%

7 29.2%

2 8.3%

Other

3 12.5%

Largest class: A — 7 competitors (29.2%)

Class Winners

AA 5 entered

89/100 — 89.00%

Clive Scase

2=: Adam Cocker — 82.00%

A 7 entered

79/100 — 79.00%

Laurence Greenleaf

2: Paul Burrows — 77.00%

B 7 entered

79/100 — 79.00%

Dave Bignell(tied) Graham Gooday(tied)

3: David Lewzey — 74.00%

C 2 entered

63/100 — 63.00%

Tina Henshaw

2: Judith Lock — 51.00%

Other 3 entered

69/100 — 69.00%

Mark Lyes

2: Paul Bryan — 40.00%

Full Results — 24 entries

AA Clive Scase

89/100

89.0%

AA Adam Cocker

82/100

82.0%

AA Robert Humphreys

82/100

82.0%

B Dave Bignell

79/100

79.0%

B Graham Gooday

79/100

79.0%

A Laurence Greenleaf

79/100

79.0%

A Paul Burrows

77/100

77.0%

AA Sam Rattley

77/100

77.0%

B David Lewzey

74/100

74.0%

A Dennis Webb

74/100

74.0%

B Darren Coham

73/100

73.0%

B Katie Durrant

72/100

72.0%

13=

A John Henshaw

69/100

69.0%

13=

B Mark Burrows

69/100

69.0%

13=

Unknown Mark Lyes

69/100

69.0%

16=

AA Daren Parsons

68/100

68.0%

16=

A Shane Johnston

68/100

68.0%

B Martin Howard

67/100

67.0%

C Tina Henshaw

63/100

63.0%

A Peter Humphreys

60/100

60.0%

A Andy Walker

55/100

55.0%

C Judith Lock

51/100

51.0%

Unknown Paul Bryan

40/100

40.0%

Unknown John Hewitt

39/100

39.0%

#	Name	Class	Score	Score %	Class Rank
1	Clive Scase	AA	89/100	89.00%	1
2=	Adam Cocker	AA	82/100	82.00%	2=
2=	Robert Humphreys	AA	82/100	82.00%	2=
4=	Dave Bignell	B	79/100	79.00%	1=
4=	Graham Gooday	B	79/100	79.00%	1=
4=	Laurence Greenleaf	A	79/100	79.00%	1
7=	Paul Burrows	A	77/100	77.00%	2
7=	Sam Rattley	AA	77/100	77.00%	4
9=	David Lewzey	B	74/100	74.00%	3
9=	Dennis Webb	A	74/100	74.00%	3
11	Darren Coham	B	73/100	73.00%	4
12	Katie Durrant	B	72/100	72.00%	5
13=	John Henshaw	A	69/100	69.00%	4
13=	Mark Burrows	B	69/100	69.00%	6
13=	Mark Lyes	Unknown	69/100	69.00%	1
16=	Daren Parsons	AA	68/100	68.00%	5
16=	Shane Johnston	A	68/100	68.00%	5
18	Martin Howard	B	67/100	67.00%	7
19	Tina Henshaw	C	63/100	63.00%	1
20	Peter Humphreys	A	60/100	60.00%	6
21	Andy Walker	A	55/100	55.00%	7
22	Judith Lock	C	51/100	51.00%	2
23	Paul Bryan	Unknown	40/100	40.00%	2
24	John Hewitt	Unknown	39/100	39.00%	3

Other AR Events at Clacton Gun Club

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

DB 48% · Py 37% · Render 14%

11 queries · avg 1.1ms · max 2.0ms

Render Breakdown

DB Logic (Pre-Render) 0.0126s

Python Logic (Pre-Render) 0.0097s

Full Page Render 0.0037s

QUERY TABLES ▾

⚠ event_review 4× 0.004s

shoot_event 2× 0.003s

shoot_score 2× 0.003s

site_configuration 2× 0.002s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (11) — click to expand

#1 [22:12:01.844] 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:12:01.847] 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:12:01.850] 1.5ms

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:12:01.851] 1.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_…

#5 [22:12:01.853] 1.0ms

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:12:01.855] 0.9ms

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:12:01.856] 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 [22:12:01.857] 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…

#9 [22:12:01.859] 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

#10 [22:12:01.860] 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 [22:12:01.862] 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

All Round at Clacton Gun Club

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?