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!
A Letter Home
Complete
Cressida Brennan
Writing
Closed 23 January 2025
Action Stations
Complete
Trevenan Williams
Writing
Closed 23 January 2025
Warp Speed
Complete
Trevenan Williams
Puzzle
Closed 23 January 2025
Take Her Out
Complete
Kristina Tyelin
Puzzle
Closed 22 January 2025
Crew Refresher
Complete
Kristina Tyelin
Puzzle
Closed 22 January 2025
Pilots Needed!
Complete
Kristina Tyelin
Flash Gaming
Closed 22 January 2025
Unscramble That Ship! (Medium)
Complete
Sazra Kobahl
Puzzle
Closed 20 January 2025
Hit the Holodeck – Archer Edition
Complete
Sazra Kobahl
Flash Gaming
Closed 20 January 2025
Open Channels! Guess Who?
Complete
Sazra Kobahl
Puzzle
Closed 20 January 2025
A Special Place
Complete
Cressida Brennan
Puzzle
Closed 14 January 2025
Target Practise
Complete
Cressida Brennan
Flash Gaming
Closed 14 January 2025
LCARS update
Complete
Cressida Brennan
Flash Gaming
Closed 14 January 2025
Open Channels! Guess Who?
Complete
Sazra Kobahl
Puzzle
Closed 7 January 2025
Unscramble That Ship! Heavy Cruiser Edition (Medium)
Complete
Sazra Kobahl
Puzzle
Closed 7 January 2025
Bravo Fleet Scavenger Hunt #1
Complete
Callen Varro
Puzzles/Trivia (Hard)
Closed 6 January 2025
Final Exam: Earth History
Complete
Cressida Brennan
Trivia
Closed 4 January 2025
Cardassian Sunset
Complete
Cressida Brennan
Puzzle
Closed 3 January 2025
Crimes beyond Imagination
Complete
Cressida Brennan
Puzzle
Closed 3 January 2025
Touching Survival
Complete
Cressida Brennan
Short/Flash Fiction
Closed 3 January 2025
Shore Leave Destinations
Complete
Cressida Brennan
Graphics
Closed 25 December 2024
Time and Again
Complete
Solaris McLaren
Puzzle
Closed 22 December 2024
Showdown at Omega Draconis
Complete
Solaris McLaren
Puzzle
Closed 22 December 2024
Timetable Troubles
Complete
Cressida Brennan
Puzzle
Closed 22 December 2024
Time to reflect
Complete
Cressida Brennan
Writing
Closed 22 December 2024
ATTACK – A Truly Tempestuous And Critical Klingon
Complete
Varen Wyll
Poetry
Closed 21 December 2024
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.77 seconds
Total SQL Queries: 100
11 | 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 = '2765' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC |
5 | 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 |
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 = '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 |
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 = '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 |
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 FOUND_ROWS() |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2063) 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 = 'competition' AND wp_postmeta.meta_value = '140600' ) ) 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 (2854) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2854' 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 = '139973' ) ) 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 = '140602' ) ) 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 = '140599' ) ) 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.* 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 = '2063' ) ) 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 = '140603' ) ) 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 (102000) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (88217) 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 = '140227' ) ) 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 = 88217 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (32342) ORDER BY meta_id ASC |
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 60, 12 |
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 = '139784' ) ) 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 = 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 = 'competition' AND wp_postmeta.meta_value = '139554' ) ) 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 ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('donate') AND post_type IN ('page','attachment') |
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 (159902,159903) 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 (159902, 159903) ORDER BY t.name ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (159903,159902) |
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 (86925) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 86925 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 = '140487' ) ) 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 (49894) 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 = '2419' ) ) 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 (2419) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2419' 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 = '139825' ) ) 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 = '139824' ) ) 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 = '139785' ) ) 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 (104220) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2063' 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 = '141332' ) ) 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 = '140486' ) ) 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 = 136019 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 105004 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 user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1295) ORDER BY umeta_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 (136019) 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 = '140601' ) ) 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 (91261) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (105004) ORDER BY meta_id ASC |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2765) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2765' LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (139554,139784,139785,139824,139825,139973,140227,140486,140487,140599,140600,140601,140602,140603,140633,140635,141332,141333,141337,141842,141843,141844,141868,141870,141871) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (140601,140633,140635,141868,141870,141871,141843,141844,141842,141332,141333,141337,140486,140487,140227,140603,140599,140600,140602,139973,139784,139785,139824,139825,139554) |
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 125, 25 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (148720,148763,148764,148765,148766,148767,148768,148769,148795,148803,148805,148809) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (148763,148764,148765,148766,148767,148768,148769,148720,148805,148809,148795,148803) |
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 = '140633' ) ) 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 = '140635' ) ) 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 = '141337' ) ) 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 (2545) 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 = 'competition' AND wp_postmeta.meta_value = '141333' ) ) 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 = '141842' ) ) 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 = '141844' ) ) 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 (59349) 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 = '141843' ) ) 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 = 59349 LIMIT 1 |
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_users WHERE ID = '2545' LIMIT 1 |
1 | SELECT * FROM wp_users WHERE ID = '2622' 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 = '141871' ) ) 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 = '141870' ) ) 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 (121232) 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 = '141868' ) ) 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 = 121232 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_posts WHERE ID = 12371 LIMIT 1 |