DEV BUILD - NOT FOR PUBLIC USE
 

Archery Training

Description

In order to better understand ourselves and our own past, we look to observe and learn about primitive cultures we encounter in our explorations.  In order to hold to the Prime Directive, we cannot contaminate these cultures by revealing advanced technology if the mission requires us to go planetside and interact.  The bow is a very common tool and weapon used for hunting as well as defense in early bipedal species.  In our own more advanced society, the bow is kept around to be used as a source of recreation as we practice our aim and prowess.  In today’s exercise, we will practice our skills with the bow.  Perhaps this skill will serve you on your next away mission observing primitive cultures.

The goal here is to achieve the highest score.  The winner will be determined by the highest score, but ties will be broken by who has the lowest time as recorded by the BMFS.

It took me a second to figure out the controls of this game, as I saw no instructions.  So I will describe the mechanics here;

  • To shoot, click the mouse or tap your mobile device screen.  Releasing the mouse button or removing your finger from the mobile device screen is what shoots your arrow.
  • Drag your mouse/finger to the left to draw the string.
  • Drag your mouse/finger up or down to change the pitch of the aim.
  • Only let go of the mouse or lift your finger off your mobile screen once you are ready to shoot!

Criteria

  • Participants should submit a screenshot clearly showing their score.
  • Submissions will be judged on the Best score achieved. You can play as many times as you like before submitting. Highest score wins.
  • Ties will be broken based on the time taken between competition start and submission as recorded by the BFMS timer.

Please login to participate in the competition.

Winners

Submissions

User Content Date Timer Entry
Varyn K’lev (#3112)

One try, 11 points. Bulls-eye on opening shot, edge on second, missed just high on third. Completed on mobile.

 2025-07-14 01:18:18 2 minutes 48 seconds
Sazra Kobahl (#2545)

44

 2025-07-11 08:17:13 5 minutes 12 seconds
Thaassen Mekor (#3113)

clearly I'm not much good at this, but I tried lol

 2025-07-09 02:11:28 30 minutes 45 seconds
Joshua Bryant (#2586)

Fun little game. I scored a 63.

 2025-07-09 01:03:13 3 minutes 43 seconds
Thov th'Zeles (#1644)

Didn't work on the phone, so I switched to laptop. The time change likely cost many any competitiveness, but I enjoyed the minigame! Thanks for the opportunity. :D

 2025-07-08 16:00:12 9 minutes 29 seconds
Ludvig Traven (#3114)

That was harder than I expected!!

 2025-07-08 11:38:35 10 minutes 31 seconds
Olivia Carrillo (#2199)

41

 2025-07-07 21:28:31 4 minutes 58 seconds
Trevenan Williams (#1295)

105

 2025-07-07 04:20:07 19 minutes 19 seconds
Gray Burns (#3108)

I know its not even 100, but dear god it took me over an hour to get here XD

 2025-07-07 03:19:11 23 minutes 40 seconds
James MacLeod (#653)
Private Submission
 2025-07-06 22:47:32
Traan (#3099)

That was deceptively difficult. CHEERS

 2025-07-06 01:44:04 18 minutes 16 seconds
Mamof (#2848)

53

 2025-07-05 19:00:46 4 minutes 30 seconds
Michael Angelus (#3090)

The Arrogance of the Apples...

 2025-07-05 17:28:01 25 minutes 51 seconds
Solaris McLaren (#2854)
Private Submission
 2025-07-05 09:13:11

Managed By the

Office of the Chief of Staff

This service is managed by the Office of the Chief of Staff. If you have questions about this service, please contact an office staff member.

Visit the office

Load Time: 0.37 seconds

Total SQL Queries: 168

2 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3090' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
2 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '1295' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
2 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( ( wp_postmeta.meta_key = 'competition' AND wp_postmeta.meta_value = '158886' ) ) ) AND wp_posts.post_type = 'comp_sub_timer' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC
2 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3108' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (28677) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 102088 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2199' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (102088) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159608 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159608) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159545 LIMIT 1
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '158886' AND wp_posts.post_type = 'competition' ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159545) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159542) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '653' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (653) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '653' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18567) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 90338 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '653' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT * FROM wp_posts WHERE ID = 159542 LIMIT 1
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2199' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2199) ORDER BY umeta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159633) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1644) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '1644' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18662) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 13022 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '1644' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (13022) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159633 LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '3114' LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '2199' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3114) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3114' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159578) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159576 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3114' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159576) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159627 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159627) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (90338) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159518) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159518 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159338) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2854) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2854' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (102000) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 104220 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2854' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (104220) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159338 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'group_news' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 2
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159389) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (163230,163266)
1 SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('group_news_category') AND tr.object_id IN (163230, 163266) ORDER BY t.name ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (163230,163266) ORDER BY meta_id ASC
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'event_status' AND wp_postmeta.meta_value = 'In Progress' ) AND ( mt1.meta_key = 'event_type' AND mt1.meta_value = 'fleet_action' ) ) AND wp_posts.post_type = 'events' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title DESC LIMIT 0, 1
1 SELECT * FROM wp_posts WHERE ID = 49761 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 16756 LIMIT 1
1 SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('donate') AND post_type IN ('page','attachment')
1 SELECT * FROM wp_users WHERE ID = '2854' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 159389 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159658) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159455 LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '3099' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3099) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3099' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158360) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 158358 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3099' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158358) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159455) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159411) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2848' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2848) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2848' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (100839) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 100837 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2848' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (100837) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159411 LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '1644' LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2586' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT * FROM wp_posts WHERE ID = 159658 LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1295) ORDER BY umeta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157117) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 157115 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3090' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157115) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 160825 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (160825) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '1295' LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18746) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '3090' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 105004 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '1295' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (105004) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147850) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 147851 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147851) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 156269 LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3090) ORDER BY umeta_id ASC
1 SELECT DISTINCT p.* FROM wp_posts p INNER JOIN wp_postmeta AS pm ON pm.post_id = p.ID WHERE p.post_type = "events" AND pm.meta_key LIKE "event_comps_%_competition" AND pm.meta_value = 158886;
1 SELECT * FROM wp_users WHERE ID = '3108' LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2652' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT * FROM wp_users WHERE ID = '2652' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2652) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'competition' AND wp_postmeta.meta_value = '158886' ) ) AND wp_posts.post_type = 'competition_sub' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'pending')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (160160,159823,159661,159657,159632,159625,159607,159544,159461,159517,159454,159410,159388,159337) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2652' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (73914) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 142620 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142620) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142741) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 147863 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 147850 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 150377 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (150377) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 150378 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (150378) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 142741 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156269) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3108) ORDER BY umeta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (66848) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159505) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159824) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '3113' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3113) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3113' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159507) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159505 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3113' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT * FROM wp_posts WHERE ID = 159662 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (59349) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159662) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2586' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2586) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2586' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (66734) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 66848 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158886) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159824 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2545' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159155) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159458) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159153 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3108' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159153) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159336,159382,159409,159453,159516,159540,159543,159606,159624,159631,159656,159660,159741,159822,160159,160369) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '3112' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3112) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3112' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT * FROM wp_posts WHERE ID = 159456 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 59349 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3112' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159456) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 160161 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (160161) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2545' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2545) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2545' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (59351) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1