Compete with other members in writing, graphics, gaming, and puzzle challenges.
Write a story based on a prompt created by the competition's judge! You can even attach it to one of your current missions!
Earn as many gaming ribbons as you can, play with other members, or participate in in-game scavenger hunts!
Solve a puzzle or play in a browser game! Be warned, these are usually time-based challenges!
The great Ornithologist
Complete
Vausees Vax
Flash Gaming
Closed 18 April 2023
{Akira Squadron} Diligent Jigsaw – Medium
Complete
Vausees Vax
Puzzle
Closed 18 April 2023
Ship Size Scale
Complete
Reva Sarrik
Puzzles/Trivia (Hard)
Closed 16 April 2023
Starfleet Thriller
Complete
Reva Sarrik
Puzzle
Closed 15 April 2023
Gaming Blitz – Easter Edition!
Complete
Rob Mackenzie
Gaming
Closed 11 April 2023
{Akira Squadron} Akira Crossword – Easy
Complete
Vausees Vax
Puzzle
Closed 8 April 2023
{Akira Squadron} Akira Jigsaw – Medium
Complete
Vausees Vax
Puzzle
Closed 8 April 2023
{Akira Squadron} Akira Word Search
Complete
Vausees Vax
Puzzle
Closed 8 April 2023
Party Time – Music
Complete
Vausees Vax
Flash Gaming
Closed 4 April 2023
Unscrambling the Azure Nebula
Complete
Theo Barrington
Puzzle
Closed 3 April 2023
New Posting!
Complete
Tavek
Puzzle
Closed 2 April 2023
Dominion War History
Complete
Tavek
Puzzle
Closed 2 April 2023
First Contact Timeline
Complete
Aryanna Rigras
Puzzle
Closed 1 April 2023
The Dolmari
Complete
Reva Sarrik
Puzzle
Closed 29 March 2023
Knife Throwing Challenge
Complete
Joshua Bryant
Flash Gaming
Closed 27 March 2023
Extra Credit – Life Sciences
Complete
Joshua Bryant
Flash Gaming
Closed 27 March 2023
Lights Out!
Complete
Joshua Bryant
Flash Gaming
Closed 27 March 2023
TF17: Identify Time Rifts in the Typhon Expanse
Complete
Andreus Kohl
Puzzle
Closed 21 March 2023
Decryption Expertise
Complete
Tavek
Puzzle
Closed 19 March 2023
Salvage Operation
Complete
Tavek
Puzzle
Closed 19 March 2023
Federation Ambassadors!
Complete
Tavek
Puzzle
Closed 19 March 2023
Second Contact – Landru
Complete
Alexandra Sudari-Kravchik
Puzzle
Closed 13 March 2023
1st Contact – orienteering wiki style
Complete
Aryanna Rigras
Trivia
Closed 12 March 2023
Starship Refresher!
Complete
Tavek
Puzzle
Closed 12 March 2023
USS Sarek – The Crimes of Yuulik
Complete
Andreus Kohl
Puzzle
Closed 12 March 2023
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.
Load Time: 0.68 seconds
Total SQL Queries: 114
6 | 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 = '2622' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC |
6 | 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 |
3 | 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 |
3 | 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 = '2185' ) ) 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 = '2486' ) ) 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 FOUND_ROWS() |
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 = '2374' ) ) 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 = 'competition' AND wp_postmeta.meta_value = '73255' ) ) 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 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 = 'competition' AND wp_postmeta.meta_value = '73689' ) ) 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 LIMIT 0, 1 |
1 | SELECT * FROM wp_posts WHERE ID = 47905 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (47074) ORDER BY meta_id ASC |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2374) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2374' 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 = 'competition' AND wp_postmeta.meta_value = '73436' ) ) 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 LIMIT 0, 1 |
1 | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ((wp_posts.post_type = 'competition' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC LIMIT 192, 12 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (66848) 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 = 'competition' AND wp_postmeta.meta_value = '73245' ) ) 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 LIMIT 0, 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (47905) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (66734) ORDER BY meta_id ASC |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2586) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2586' 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 = 'competition' AND wp_postmeta.meta_value = '73994' ) ) 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 LIMIT 0, 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (67313) 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 = 'competition' AND wp_postmeta.meta_value = '74118' ) ) 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 LIMIT 0, 1 |
1 | SELECT * FROM wp_posts WHERE ID = 67313 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 66848 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 = 'competition' AND wp_postmeta.meta_value = '73707' ) ) 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 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 = 'competition' AND wp_postmeta.meta_value = '73706' ) ) 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 LIMIT 0, 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 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_posts WHERE ID = 86412 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 13085 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (122202) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (122202) |
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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140618,140922) ORDER BY meta_id ASC |
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 wp_posts.* FROM wp_posts WHERE ID IN (140922,140618) |
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 = 'competition' AND wp_postmeta.meta_value = '73227' ) ) 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 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 = 'competition' AND wp_postmeta.meta_value = '73708' ) ) 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 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 = 'competition' AND wp_postmeta.meta_value = '73028' ) ) 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 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 = 'competition' AND wp_postmeta.meta_value = '72783' ) ) 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 LIMIT 0, 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (27493) 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 = 'competition' AND wp_postmeta.meta_value = '72194' ) ) 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 LIMIT 0, 1 |
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 (22416) 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 = '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 user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2121) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2121' LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (54484) 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 = 'competition' AND wp_postmeta.meta_value = '74146' ) ) 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 LIMIT 0, 1 |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2486) ORDER BY umeta_id ASC |
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.ID 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 = '74948' ) ) 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 LIMIT 0, 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (32999) 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 = 'competition' AND wp_postmeta.meta_value = '74949' ) ) 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 LIMIT 0, 1 |
1 | SELECT * FROM wp_posts WHERE ID = 32999 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (27212) ORDER BY meta_id ASC |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2185) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2185' 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 = 'competition' AND wp_postmeta.meta_value = '75099' ) ) 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 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 = 'competition' AND wp_postmeta.meta_value = '75097' ) ) 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 LIMIT 0, 1 |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2041) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 27480 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (27204) ORDER BY meta_id ASC |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2184) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2184' LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (72194,72783,73028,73227,73245,73255,73436,73689,73706,73707,73708,73994,74118,74146,74147,74160,74163,74164,74194,74223,74694,74948,74949,75097,75099) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (75097,75099,74949,74948,74694,74160,74163,74164,74223,74194,74147,74146,74118,73994,73245,73255,73436,73689,73706,73707,73708,72194,72783,73028,73227) |
1 | SELECT SQL_CALC_FOUND_ROWS 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 ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'comp_end' AND ( ( mt1.meta_key = 'comp_start' AND mt2.meta_key = 'comp_end' ) ) ) AND ((wp_posts.post_type = 'competition' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY (CASE WHEN CAST(mt1.meta_value AS DATETIME) < NOW() AND CAST(mt2.meta_value AS DATETIME) > NOW() THEN 0 WHEN CAST(mt1.meta_value AS DATETIME) > NOW() THEN 20 WHEN CAST(mt2.meta_value AS DATETIME) < NOW() THEN 50 ELSE 75 END) ASC, wp_postmeta.meta_value+0 DESC LIMIT 400, 25 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (101000,101002,101406,101411,101535,101536,101546,101547,101566,101567,101587,102250) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (102250,101411,101587,101567,101566,101547,101546,101535,101536,101406,101000,101002) |
1 | SELECT * FROM wp_users WHERE ID = '2041' 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 = '2041' ) ) 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 = '2486' LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19389) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (99505) 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 = 'competition' AND wp_postmeta.meta_value = '74147' ) ) 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 LIMIT 0, 1 |
1 | SELECT * FROM wp_posts WHERE ID = 99505 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (69797) ORDER BY meta_id ASC |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2622) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2622' LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (66022) 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 = 'competition' AND wp_postmeta.meta_value = '74194' ) ) 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 LIMIT 0, 1 |
1 | SELECT * FROM wp_posts WHERE ID = 66022 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 = '2080' ) ) 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 (22298) ORDER BY meta_id ASC |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2080) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2080' 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 = 'competition' AND wp_postmeta.meta_value = '74223' ) ) 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 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 = 'competition' AND wp_postmeta.meta_value = '74164' ) ) 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 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 = 'competition' AND wp_postmeta.meta_value = '74163' ) ) 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 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 = 'competition' AND wp_postmeta.meta_value = '74160' ) ) 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 LIMIT 0, 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (29331) 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 = 'competition' AND wp_postmeta.meta_value = '74694' ) ) 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 LIMIT 0, 1 |
1 | SELECT * FROM wp_posts WHERE ID = 29331 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1 |