DEV BUILD (branch: deploy) - NOT FOR PUBLIC USE
 

Check out our latest Fleet Action!

Learn More
 

[Phase 2]: Crisis Trivia

Description

Starfleet trains its personnel to respond effectively to hundreds of different kinds of emergencies. Much of this training has been created from careful study of captains’ logs and incident reports from over the years. This quiz will test you on your knowledge about how various captains managed to get their ships out of crises—or what happened when they didn’t!

View Quiz

Criteria

  • Submit your response to the quiz directly at the attached link. You should also submit a screenshot of your submission confirmation as an entry to the competition. Make a note if your email is different there than what you use on the BFMS.
  • This competition will be placed first by score, and then on time of submission.

Winners

Submissions

User Content Date Entry
Jonathan Ransom (#2022)

16/20

 2021-08-27 21:56:38
Walter Jones (#1659)

13/20 It didn't like the way that I put in the free form answers.. lol

 2021-08-27 12:54:49
Orila Karai (#2263)

Score: 18/20

 2021-08-27 12:32:36
Micah Mendoza (#25)

0/20 Turned out that I was the disaster. Wow, I didn't realize how much I'd forgotten. I guess I have a new task, rewatching Star Trek.

 2021-08-26 21:36:29
Erill'Yun Mek (#2187)

Final score 14/20

 2021-08-26 01:48:03
Acker Kather (#763)

Capt Acker Kather, USS Ascension, TF93

The one answer was marked wrong because I answered Kim. It said I needed to have his full name or rank to be correct. I disagree.

 2021-08-22 19:00:21
Struan MacLeod (#2197)

User: bri.whyte
TF: 93
e-mail: bri.whyte@gmail.com
Score: 19/20

 2021-08-22 10:35:26
Javin Kile (#113)

Score 15/20

 2021-08-19 01:56:40
Luke Duncan (#1759)

Sorry David, my system froze up before I had a chance to take a screen shot of my confirmation of entry. Hope these screenshots are valid.

 2021-08-14 16:35:53
Th'lora Vehl (#2240)

Entry for Treylana Hess

 2021-08-14 09:44:09
Vausees Vax (#2184)

scored a 17/20

 2021-08-14 07:55:17
Henry Maxwell (#2223)

Boomies

 2021-08-14 07:21:49
Alexandra Sudari-Kravchik (#2121)

14/20

 2021-08-14 02:19:25
Alexandria Mitchell (#2266)

Score 18/20

 2021-08-14 01:56:12
Brodie Lewis (#2208)

I got one wrong because I put the correct abbreviation which I do not think is counted right.

 2021-08-14 01:31:01

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.95 seconds

Total SQL Queries: 171

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 = '37677' ) ) ) 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 = '2197' ) ) 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 = '2223' ) ) 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 = '2240' ) ) 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 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 = '763' ) ) 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 = 37902 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18640) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 86412 LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (763) ORDER BY umeta_id ASC
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 = '1759' ) ) 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 (86412) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (37940,37941) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (37941,37940) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (37902) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1759) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '763' LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '2184' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2184) 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 = '2184' ) ) 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 (27204) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 27480 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 = '2184' ) ) 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 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 = '1759' ) ) 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_users WHERE ID = '1759' LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18745) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '113' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 6122 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 = '763' ) ) 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 (6122) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 38607 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (38607) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 38573 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (38573) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (113) ORDER BY umeta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (38263,38262) 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 = '113' ) ) 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 (18390) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 19418 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 = '113' ) ) 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 (19418) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (38262,38263) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.post_date DESC
1 SELECT * FROM wp_posts WHERE ID = 37880 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (27480) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '37677' 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 (37880) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (37795) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2208) 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 = '2208' ) ) 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 (29604) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 39959 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 = '2208' ) ) 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 (39959) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 37795 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 (37805) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (140922,140618)
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 (140618, 140922) ORDER BY t.name ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140618,140922) 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 wp_posts.* FROM wp_posts WHERE ID IN (122202)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (122202) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 13085 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 = '2208' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 37805 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 37875 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 = '2121' ) ) 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 wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (38751,38752) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (37875) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2121' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2121) 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 = '2121' ) ) 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 (22416) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 27493 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (27493) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (138222) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 37815 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (37815) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2266' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2266) 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 = '2266' ) ) 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 (35121) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 138222 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 = '2266' ) ) 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 (38752,38751) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 34461 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34461) 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 ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2197' ) ) 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 (33287) 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 ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2240' ) ) 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 = 39638 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (39638) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (28309) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 34700 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34700) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 34710 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (33203) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34710) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (31032) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 31802 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (31802) 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 ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2223' ) ) 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 = 45544 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (45544) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 33287 LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2223) ORDER BY umeta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2022) ORDER BY umeta_id ASC
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 = '669' ) ) 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 = '669' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (669) 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 = '37677' ) ) 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 (38861,38830,38828,38779,38750,38606,38572,38261,37939,37901,37879,37874,37814,37804,37794) 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 = '669' ) ) 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 (18572) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 49761 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (49761) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2223' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 140308 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140308) ORDER BY meta_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 = 37677;
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35600) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2240' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2240) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2197' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2197) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2022' 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 = '2022' ) ) 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 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 = '2187' ) ) 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 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 = '25' ) ) 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 = 38829 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (38829) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '25' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (25) 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 = '25' ) ) 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 (18328) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 27965 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (27965) 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 ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2263' ) ) 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 = 38780 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (38780) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2187' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2187) 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 = '2187' ) ) 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 (27384) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (37677) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34638) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 34638 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18619) 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 = '1659' ) ) 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 = 17551 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 = '2022' ) ) 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 (17551) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 38862 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (38862) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '1659' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1659) ORDER BY umeta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18658) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34640) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 12924 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 = '1659' ) ) 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 (12924) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 38831 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (38831) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2263' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2263) 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 = '2263' ) ) 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 = 12371 LIMIT 1