Back to Events

STR — Sportrap

Sportrap at North Wales Shooting School

North Wales Shooting School

Saturday, 02 July 2022 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

71.7%

Field Average

90.7%

Highest Score

52.0%

Lowest Score

Top 3 Overall

🥈 =2

Carl Vickers

AAA

Peter Lloyd

63/75

84.00%

🥇

Steven Randles

68/75

90.67%

Event Difficulty

71.7% This Event

vs. North Wales Shooting School historical average (Sportrap)

↓ -7.1% harder than usual

Ground avg: 78.8%

Score Distribution

90–100%

1 3.1%

80–89%

9 28.1%

70–79%

7 21.9%

60–69%

10 31.2%

50–59%

5 15.6%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

1 / 32

80%+

31.2%

10 / 32

70%+

53.1%

17 / 32

60%+

84.4%

27 / 32

50%+

100.0%

32 / 32

Class Breakdown

Class	Count	Average	High	Low	Winner
AAA	2	82.7%	84.0%	81.3%	Carl Vickers
AA	5	80.3%	90.7%	73.3%	Steven Randles
A	9	73.6%	82.7%	58.7%	Edward Wilkinson
B	6	72.0%	81.3%	57.3%	Robert Harrison
C	3	64.4%	70.7%	57.3%	Hazel Denney-Cunliffe
Other	7	62.9%	76.0%	52.0%	Andrew Gate

Class Composition

AAA

2 6.2%

5 15.6%

9 28.1%

6 18.8%

3 9.4%

Other

7 21.9%

Largest class: A — 9 competitors (28.1%)

Class Winners

AAA 2 entered

63/75 — 84.00%

Carl Vickers

2: Paul Hutchinson — 81.33%

AA 5 entered

68/75 — 90.67%

Steven Randles

2: Peter Lloyd — 84.00%

A 9 entered

62/75 — 82.67%

Edward Wilkinson(tied) Mark Oakley(tied)

3=: Ian Edwards — 80.00%

B 6 entered

61/75 — 81.33%

Robert Harrison

2: Kerry Oakley — 80.00%

C 3 entered

53/75 — 70.67%

Hazel Denney-Cunliffe

2: Colin Babcock — 65.33%

Other 7 entered

57/75 — 76.00%

Andrew Gate

2=: Ian Thomas — 68.00%

Full Results — 32 entries

AA Steven Randles

68/75

90.7%

AAA Carl Vickers

63/75

84.0%

AA Peter Lloyd

63/75

84.0%

A Edward Wilkinson

62/75

82.7%

A Mark Oakley

62/75

82.7%

AAA Paul Hutchinson

61/75

81.3%

B Robert Harrison

61/75

81.3%

A Ian Edwards

60/75

80.0%

B Kerry Oakley

60/75

80.0%

A Mike Cashmore

60/75

80.0%

A Ian Cunliffe

59/75

78.7%

12=

B Alexander Wilkinson

58/75

77.3%

12=

AA Peter Humphreys

58/75

77.3%

14=

Unknown Andrew Gate

57/75

76.0%

14=

AA Richard Jones

57/75

76.0%

AA David Walker

55/75

73.3%

C Hazel Denney-Cunliffe

53/75

70.7%

18=

B Douglas Roberts

51/75

68.0%

18=

Unknown Ian Thomas

51/75

68.0%

18=

A Jay Smith

51/75

68.0%

18=

B Mark Haley

51/75

68.0%

18=

A Robert Southwood

51/75

68.0%

18=

Unknown Tom Lowe

51/75

68.0%

C Colin Babcock

49/75

65.3%

A David Vickers

48/75

64.0%

26=

Unknown Dewi Rowlands

46/75

61.3%

26=

Unknown Stephen Lawrenson

46/75

61.3%

A Ian Hayes

44/75

58.7%

29=

B Eric Wagstaff

43/75

57.3%

29=

C James Southwood

43/75

57.3%

Unknown Andrew Shannon

40/75

53.3%

Unknown Michael Luff

39/75

52.0%

#	Name	Class	Score	Score %	Class Rank
1	Steven Randles	AA	68/75	90.67%	1
2=	Carl Vickers	AAA	63/75	84.00%	1
2=	Peter Lloyd	AA	63/75	84.00%	2
4=	Edward Wilkinson	A	62/75	82.67%	1=
4=	Mark Oakley	A	62/75	82.67%	1=
6=	Paul Hutchinson	AAA	61/75	81.33%	2
6=	Robert Harrison	B	61/75	81.33%	1
8=	Ian Edwards	A	60/75	80.00%	3=
8=	Kerry Oakley	B	60/75	80.00%	2
8=	Mike Cashmore	A	60/75	80.00%	3=
11	Ian Cunliffe	A	59/75	78.67%	5
12=	Alexander Wilkinson	B	58/75	77.33%	3
12=	Peter Humphreys	AA	58/75	77.33%	3
14=	Andrew Gate	Unknown	57/75	76.00%	1
14=	Richard Jones	AA	57/75	76.00%	4
16	David Walker	AA	55/75	73.33%	5
17	Hazel Denney-Cunliffe	C	53/75	70.67%	1
18=	Douglas Roberts	B	51/75	68.00%	4=
18=	Ian Thomas	Unknown	51/75	68.00%	2=
18=	Jay Smith	A	51/75	68.00%	6=
18=	Mark Haley	B	51/75	68.00%	4=
18=	Robert Southwood	A	51/75	68.00%	6=
18=	Tom Lowe	Unknown	51/75	68.00%	2=
24	Colin Babcock	C	49/75	65.33%	2
25	David Vickers	A	48/75	64.00%	8
26=	Dewi Rowlands	Unknown	46/75	61.33%	4=
26=	Stephen Lawrenson	Unknown	46/75	61.33%	4=
28	Ian Hayes	A	44/75	58.67%	9
29=	Eric Wagstaff	B	43/75	57.33%	6
29=	James Southwood	C	43/75	57.33%	3
31	Andrew Shannon	Unknown	40/75	53.33%	6
32	Michael Luff	Unknown	39/75	52.00%	7

Other STR Events at North Wales Shooting School

⚙ Performance Stats DRAG TO MOVE

0.056s ● FAST

DB 69% · Py 20% · Render 11%

11 queries · avg 3.5ms · max 21.2ms

Render Breakdown

DB Logic (Pre-Render) 0.0388s

Python Logic (Pre-Render) 0.0114s

Full Page Render 0.0060s

QUERY TABLES ▾

⚠ event_review 4× 0.024s

shoot_event 2× 0.003s

shoot_score 2× 0.003s

site_configuration 2× 0.008s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (11) — click to expand

#1 [00:13:13.778] 1.9ms

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 [00:13:13.780] 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 [00:13:13.783] 1.3ms

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 [00:13:13.785] 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 [00:13:13.787] 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 [00:13:13.788] 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 [00:13:13.790] 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 [00:13:13.811] 21.2ms

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 [00:13:13.814] 1.4ms

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 [00:13:13.821] 6.4ms

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 [00:13:13.823] 1.1ms

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 North Wales Shooting School

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?