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

[Nightfall Phase 2]: Corrupted Vaadwaur Intelligence Report

Description

Just as the Blackout hits, Fourth Fleet Command has sent you the latest cache of Starfleet Intelligence reports on Vaadwaur starship classes. Unfortunately, the transmission was interrupted before the cipher could be completed and the file is corrupt. Using your most advanced skills, decrypt the file to reveal the image.

Criteria

  • Submissions should be a screenshot of the completed puzzle, showing the whole browser window, including the URL.
  • Placement will be based on completeness, followed by the time recorded by the BFMS competition timer. Ties broken by time elapsed based on the BFMS submission timer

Please login to participate in the competition.

Winners

Submissions

User Content Date Timer Entry
Noli Auru (#18)

Kai1701E 2 squares in wrong place :(

 2025-05-04 14:37:44 18 minutes 3 seconds
Trevenan Williams (#1295)

HARD !!!!

 2025-05-04 11:51:52 14664 minutes 10 seconds
Alexandria Mitchell (#2266)
Private Submission
 2025-05-03 05:46:36
Henry Maxwell (#2223)

Really hate sliding puzzles but this one did not load up as bad? Not sure honestly.

 2025-04-30 23:46:08 2 minutes 40 seconds
Zachary Murphy (#2080)
Private Submission
 2025-04-30 19:00:19
Callen Varro (#2063)
Private Submission
 2025-04-29 15:42:16
Vausees Vax (#2184)

Submitted: VividShado

 2025-04-27 21:32:53 6622 minutes 36 seconds
Aelin Maori (#2980)

This was very challenging and a lot of fun!

 2025-04-27 05:09:59 10 minutes 32 seconds
Cressida Brennan (#2765)

-

 2025-04-25 16:09:47 33 minutes 28 seconds
Meila Tris (#2914)

https://puzzel.org/en/slidingpuzzle/play?p=-OLfmfGvZUBW5gdSSpA6

 2025-04-24 09:27:36 15 minutes 25 seconds
Khim Samnang (#2222)
Private Submission
 2025-04-24 02:05:38
Mamof (#2848)

Compeleted

 2025-04-23 14:23:59 3 minutes 41 seconds
Zarroc Thakrass (#2652)

Feel like this one took me a good while to work out lol.

 2025-04-23 12:08:46 24 minutes 4 seconds
Solaris McLaren (#2854)
Private Submission
 2025-04-23 08:58:29
Jaya Thorne (#2970)

COmpleted

 2025-04-22 15:57:39 11 minutes 17 seconds
Brodie Lewis (#2208)

Not great at these tbh but I did an attempt

2025-04-22 14:16:55 21 minutes 24 seconds
Sazra Kobahl (#2545)

Completed

 2025-04-21 14:57:48 192 minutes 44 seconds
Varen Wyll (#2419)

Slide Puzzle - Manasa Escort

 2025-04-21 13:20:03 12 minutes 4 seconds

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: 1.82 seconds

Total SQL Queries: 214

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 = '2980' ) ) 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 = '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
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 = '148771' ) ) ) 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 = '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
1 SELECT * FROM wp_posts WHERE ID = 152472 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152501) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2222' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2222) 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 = '2222' ) ) 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 (31013) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 83715 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 = '2222' ) ) 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 (83715) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152472) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (123469) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 152400 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152400) ORDER BY meta_id ASC
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 = '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 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142620) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 152385 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 152501 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 123469 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 = '2914' ) ) 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 = '2765' 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (27480) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 152833 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152833) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 152736 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152736) 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 = '2854' 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 = '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
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (91261) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 136019 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 = '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 LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (136019) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 152630 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152630) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2914' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2914) 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 = '2914' ) ) 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 (123471) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152385) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '148771' AND wp_posts.post_type = 'competition' ORDER BY wp_posts.post_date DESC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2854) ORDER BY umeta_id ASC
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 = '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 = 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 = '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 (59349) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 152174 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152174) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2419' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2419) 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 = '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 * FROM wp_posts WHERE ID = 86925 LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '2545' 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 = '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 LIMIT 0, 1
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 = 152145 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152145) ORDER BY meta_id 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.* FROM wp_posts WHERE ID IN (159903,159902)
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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159902,159903) 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 ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('donate') AND post_type IN ('page','attachment')
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2545) ORDER BY umeta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152257) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152950) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (134179) 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 = '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 = 152375 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152375) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2970' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2970) 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 = '2970' ) ) 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 = 157741 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 152257 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 = '2970' ) ) 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 (157741) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 152269 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152269) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2208' LIMIT 1
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_users WHERE ID = '2184' 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 = '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 LIMIT 0, 1
1 SELECT * FROM wp_posts WHERE ID = 152950 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 147843 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_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 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 = 147845 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 147837 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 147856 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 158926 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147853) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 158930 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 158920 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 158914 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 158910 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147845) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 147846 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147846) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 102715 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (102715) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2980' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 45544 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 147853 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (135874) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 140308 LIMIT 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 = '148771' ) ) 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 (153411,153393,153264,153079,153038,152949,152832,152735,152629,152498,152471,152399,152384,152373,152268,152256,152173,152144) 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 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (49761) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 147863 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147852) 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 = 148771;
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (148633) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2223' 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 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 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (31802) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 147835 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 147852 LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2980) ORDER BY umeta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 147488 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (88217) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19389) 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 (138222) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 153265 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (153265) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 153080 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (153080) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2080' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2080) 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 = '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 * FROM wp_posts WHERE ID = 131107 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 = '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 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 = '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 LIMIT 0, 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (131107) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 153039 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (153039) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2063' LIMIT 1
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.* 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (32342) ORDER BY meta_id ASC
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 (148771) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35121) ORDER BY meta_id ASC
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.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 = '2980' ) ) 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 (43421) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147488) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 147801 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147801) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152104,152126,152143,152251,152262,152366,152372,152383,152398,152403,152470,152493,152499,152537,152606,152628,152708,152734,152929,152942,153036,153041,153078,153205,153408) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '18' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (18) 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 = '18' ) ) 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 (18322) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 43421 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 = '18' ) ) 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 = 153412 LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '2266' LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (153412) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '1295' 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 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
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_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 * FROM wp_posts WHERE ID = 153394 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (153394) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1