Bravo Fleet
Labyrinth Test 2
Description
Test2
Criteria
- Test2
Winners
Submissions
| User | Comments Submitted |
|---|---|
| Alexandria Mitchell (#2266) | 4 |
| Roger Allen (#2443) | 3 |
| Meila Tris (#2914) | 2 |
| Callen Varro (#2063) | 1 |
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.
Load Time: 3.23 seconds
Total SQL Queries: 69
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '141270' AND wp_posts.post_type = 'competition' ORDER BY wp_posts.post_date DESC |
| 1 | SELECT * FROM wp_users WHERE ID = '2063' LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (54420) 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 = '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 * FROM wp_posts WHERE ID = 123469 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (123469) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '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_posts WHERE ID = 133657 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (133657) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 121167 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 = 'parent' AND wp_postmeta.meta_value = '121167' ) ) AND ((wp_posts.post_type = 'mission' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) 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 (127813,127156,125479,125288,125209,125159,125007,124957,124381,124378,124249,124192,124110,123593,123577,123207,123125,123099,122970,122891,122696,122659,122640,122638,122501,122490,122470,122393,122283,122215,122214,122201,122187,122184,122124,122113,121813,122104,122098,122097,122056,122025,122022,122020,122018,122015,121826,121349,121348,121334,97191,95430,89611) ORDER BY meta_id ASC |
| 1 | SELECT p.* FROM wp_posts p INNER JOIN wp_postmeta pm ON p.ID = pm.post_id WHERE p.post_type = "mission" AND pm.meta_key = "parent" AND pm.meta_value IN (127813, 127156, 125479, 125288, 125209, 125159, 125007, 124957, 124381, 124378, 124249, 124192, 124110, 123593, 123577, 123207, 123125, 123099, 122970, 122891, 122696, 122659, 122640, 122638, 122501, 122490, 122470, 122393, 122283, 122215, 122214, 122201, 122187, 122184, 122124, 122113, 121813, 122104, 122098, 122097, 122056, 122025, 122022, 122020, 122018, 122015, 121826, 121349, 121348, 121334, 97191, 95430, 89611); |
| 1 | SELECT p.* FROM wp_posts p INNER JOIN wp_postmeta pm ON p.ID = pm.post_id WHERE p.post_type = "mission" AND pm.meta_key = "parent" AND pm.meta_value IN (122895, 124099, 125047, 127226, 127352); |
| 1 | SELECT story_comment_date_pm.post_id as story_id, story_comment_date_pm.meta_value as `timestamp`, story_comment_user_pm.meta_value as user_id, story_comment_text_pm.meta_value as `text` FROM wp_posts AS story_p INNER JOIN wp_postmeta AS story_mission_pm ON story_mission_pm.post_id = story_p.id AND story_mission_pm.meta_key = "mission" INNER JOIN wp_postmeta AS story_comment_date_pm ON story_comment_date_pm.post_id = story_p.ID AND story_comment_date_pm.meta_key LIKE "comments_%_comment_date" INNER JOIN wp_postmeta AS story_comment_user_pm ON story_comment_user_pm.post_id = story_p.ID AND story_comment_user_pm.meta_key = REPLACE(story_comment_date_pm.meta_key, '_date', '_user') INNER JOIN wp_postmeta AS story_comment_text_pm ON story_comment_text_pm.post_id = story_p.ID AND story_comment_text_pm.meta_key = REPLACE(story_comment_date_pm.meta_key, '_date', '_text') WHERE story_p.post_type = "story" AND story_mission_pm.meta_value IN (121167, 127813, 127156, 125479, 125288, 125209, 125159, 125007, 124957, 124381, 124378, 124249, 124192, 124110, 123593, 123577, 123207, 123125, 123099, 122970, 122891, 122696, 122659, 122640, 122638, 122501, 122490, 122470, 122393, 122283, 122215, 122214, 122201, 122187, 122184, 122124, 122113, 121813, 122104, 122098, 122097, 122056, 122025, 122022, 122020, 122018, 122015, 121826, 121349, 121348, 121334, 97191, 95430, 89611, 122895, 124099, 125047, 127226, 127352) AND story_comment_date_pm.meta_value BETWEEN 1735569541 AND 1738334341 AND story_comment_user_pm.meta_value != 1036 |
| 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 = 'member_user' AND wp_postmeta.meta_value = '2443' ) ) 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 (140618,140922) ORDER BY meta_id ASC |
| 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 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 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 wp_posts.* FROM wp_posts WHERE ID IN (140922,140618) |
| 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 (88217) 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 (32342) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (32342) |
| 1 | SELECT * FROM wp_posts WHERE ID = 54420 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (51181) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141270) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (49387) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '1036' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1036) 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 = '141270' ) ) 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 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 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18806) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 16756 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 = '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 LIMIT 0, 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 141639 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 141414 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141639) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 141640 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141640) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16756) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 49387 LIMIT 1 |
| 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 = 141270; |
| 1 | SELECT * FROM wp_posts WHERE ID = 51181 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 138222 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (51183) 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 = '2443' ) ) 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 (138231) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 138231 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35121) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2266' 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 user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2914) ORDER BY umeta_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 (2443) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2443' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2266) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1 |