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

USS Europa (Archive)

Delta 2400

The adventures of the Europa during her first six months in the Delta Quadrant.

Mission Description

The adventures of the Europa during her first six months in the Delta Quadrant.

About the Mission

Command
Status
Complete
Total Stories
0
Start Date
03/01/2022
End Date
31/12/2022

Load Time: 0.4 seconds

Total SQL Queries: 27

1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '45137' AND wp_posts.post_type = 'mission' ORDER BY wp_posts.post_date DESC
1 SELECT * FROM wp_posts WHERE ID = 39968 LIMIT 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 * 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 ) 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 COUNT(*) FROM wp_posts p INNER JOIN wp_postmeta pm ON p.ID = pm.post_id WHERE p.post_type = "story" AND p.post_status = "publish" AND pm.meta_key = "mission" AND pm.meta_value IN (45137);
1 SELECT * FROM wp_posts WHERE ID = 35665 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 32385 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 40872 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 21391 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (45137) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 40677 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 36393 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 44744 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 41378 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (44740) 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 = 'parent' AND wp_postmeta.meta_value = '45137' ) ) 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 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 = 'mission' AND wp_postmeta.meta_value = '45137' ) ) AND wp_posts.post_type = 'story' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 4
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 = '0' ) ) 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 = 44740 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 * FROM wp_users WHERE ID = '669' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1