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

USS Cygnus (Archive)

Enigma Variations

The Cygnus discovers a ship full of high-grade illegal substance within the borders of the Federation during a response to a distress call.

Mission Description

During a routine survey of local space, the crew of the starship Cygnus detect a distress call from an independent freighter travelling through Federation space. When responding to the distress call, the Cygnus detects something that is, at best illegal, and at worst, could result in the deaths of untold millions and the destabilization of the Alpha Quadrant.

About the Mission

Command
Status
Upcoming
Total Stories
0
Start Date
01/07/2022

Load Time: 0.41 seconds

Total SQL Queries: 28

1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '48160' AND wp_posts.post_type = 'mission' ORDER BY wp_posts.post_date DESC
1 SELECT * FROM wp_posts WHERE ID = 12654 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 (48160);
1 SELECT * FROM wp_posts WHERE ID = 28573 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 46275 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 46030 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 50762 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48160) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 42586 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 43587 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 2957 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 42928 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 45716 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (45878) 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 = '48160' ) ) 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 = '48160' ) ) 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 = 45878 LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2144) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2144' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1