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!
[Phase 3]: Meme Me Up, Scotty
Complete
Teylas Ramar
Graphics
Closed 17 September 2021
[Phase 3]: Slimekeep
Complete
Alexander Beckett
Gaming
Closed 17 September 2021
[Phase 3]: Leviathan
Complete
Liam Dahlgren
Writing
Closed 17 September 2021
[Phase 3]: Towers of Tkon
Complete
Alexander Beckett
Gaming
Closed 17 September 2021
[Phase 3]: Twitter: 2399
Complete
Robert Dowd
Graphics
Closed 17 September 2021
Echoes of the Tkon: Action Ribbon Race
Complete
Rob Mackenzie
Gaming
Closed 17 September 2021
[Phase 2]: Horizon
Complete
Alexander Beckett
Writing
Closed 27 August 2021
[Phase 2]: Action Ribbon Race
Complete
Rob Mackenzie
Gaming
Closed 27 August 2021
[Phase 2]: Ancient History Crossword
Complete
Liam Dahlgren
Puzzle
Closed 27 August 2021
[Phase 2]: Service Ribbon Race
Complete
Alexander Beckett
Writing
Closed 27 August 2021
[Phase 2]: Planet Puzzle
Complete
Teylas Ramar
Puzzle
Closed 27 August 2021
[Phase 2]: Crisis Trivia
Complete
Liam Dahlgren
Writing
Closed 27 August 2021
[Phase 2]: Tkon Tiles
Complete
Alexander Beckett
Puzzle
Closed 27 August 2021
[Phase 2]: BFMS Scavenger Hunt
Complete
Ezel Virem
Puzzle
Closed 27 August 2021
[Phase 2]: Garbled Transmissions
Complete
Teylas Ramar
Puzzle
Closed 27 August 2021
[Phase 2]: Outpost Records
Complete
Alexander Beckett
Puzzle
Closed 27 August 2021
[Phase 2]: Alien Swarm
Complete
Teylas Ramar
Gaming
Closed 27 August 2021
[Phase 2]: Battleship
Complete
Teylas Ramar
Puzzle
Closed 27 August 2021
[Phase 1]: Omega
Complete
Alexander Beckett
Writing
Closed 6 August 2021
[Phase 1]: Service Ribbon Race
Complete
Alexander Beckett
Writing
Closed 6 August 2021
[Phase 1]: Incoming Transmission
Complete
Liam Dahlgren
Puzzle
Closed 6 August 2021
[Phase 1]: Number One
Complete
Liam Dahlgren
Writing
Closed 6 August 2021
[Phase 1]: LCARS Search
Complete
Robert Dowd
Puzzle
Closed 6 August 2021
[Phase 1]: Isolinear Solitare
Complete
Robert Dowd
Gaming
Closed 6 August 2021
[Phase 1]: Ship Identification
Complete
Teylas Ramar
Puzzle
Closed 6 August 2021
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.85 seconds
Total SQL Queries: 98
8 | 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 = '1036' ) ) 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 = '1356' ) ) 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 = '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 |
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 = '1679' ) ) 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 = '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 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 = '35' ) ) 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 = '37680' ) ) 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 (47967) 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 = '37679' ) ) 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 = 47967 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18333) 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 324, 12 |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (35) 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 = '37681' ) ) 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 = '37678' ) ) 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 = '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 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 = '37676' ) ) 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 = '37686' ) ) 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 = '37675' ) ) 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_users WHERE ID = '35' 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 = '37683' ) ) 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 = '37682' ) ) 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 WHERE ID IN (140922,140618) |
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 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.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 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 = '37684' ) ) 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 = '35976' ) ) 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 = '35952' ) ) 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 = '35948' ) ) 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 = '35947' ) ) 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 = '35945' ) ) 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 = '35941' ) ) 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 = '35940' ) ) 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 = '37685' ) ) 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 (22298) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (29331) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18279) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18806) ORDER BY meta_id ASC |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1036) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '1036' LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (13085) 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 = '38988' ) ) 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 = 13085 LIMIT 1 |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1356) 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 = '38989' ) ) 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_users WHERE ID = '1356' LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35940,35941,35945,35947,35948,35952,35976,35985,37675,37676,37677,37678,37679,37680,37681,37682,37683,37684,37685,37686,38988,38989,38990,38992,38993) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (38988,38989,38990,38992,38993,35985,37684,37685,37675,37686,37676,37677,37678,37679,37680,37681,37682,37683,35940,35941,35945,35947,35948,35952,35976) |
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 675, 25 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (84757,85166,85167,85170,85382,85588,85998,86286,86287,86288,86334,86432) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (86432,86286,86288,86287,86334,85998,85588,85382,85166,85167,85170,84757) |
1 | SELECT * FROM wp_posts WHERE ID = 16756 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16756) 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 = '35985' ) ) 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 (18652) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 29331 LIMIT 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_users WHERE ID = '2041' LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (13193) 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 = '38993' ) ) 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 = 13193 LIMIT 1 |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1679) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '669' LIMIT 1 |
1 | SELECT * FROM wp_users WHERE ID = '1679' 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 = '38992' ) ) 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 (49761) 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 = '38990' ) ) 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 = 49761 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18572) ORDER BY meta_id ASC |
1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (669) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1 |