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

USS Powhatan

Season 1 - The Lady in Red.

During Season one, there is a menacing threat against the crew of the ship, a figure keeps attacking them.

Mission Description

The crew is continously targeted, bullied if you would by a Female Figure in Red. She wanders the ship, taking various systems offline.

 

About the Mission

Status
In Progress
Total Stories
11
Start Date
22/05/2025

22 May 2025

Ep 1: To Dreon

USS Powhatan: Season 1 - The Lady in Red.

Beep… beep…beep…beep…beep… The haze went away, Helen blinked again, the bridge was black, few consoles were lit up and the crew… her crew. “Report!” She called out. “They are gone Captain,” came the solid voice of Lt. T’mal. She got to her feet, and steadied herself. [...]

Load Time: 0.76 seconds

Total SQL Queries: 42

1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '156041' AND wp_posts.post_type = 'mission' ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16542) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 130606 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 130614 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 156228 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 130613 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 159630 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 130604 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 16542 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 11245 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 131070 LIMIT 1
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 (156041, 158534, 156043);
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 * FROM wp_posts WHERE ID = 136019 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 = 130609 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 134222 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156041) 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 = '156041' ) ) 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 * 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 * FROM wp_posts WHERE ID = 134385 LIMIT 1
1 SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'acf-field' AND ((wp_posts.post_status = 'publish')) AND wp_posts.post_excerpt = '_validate_email' ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 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 = '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 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 = '156041' ) ) 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 WHERE ID IN (156042)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156042) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158534,156043) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 131067 LIMIT 1
1 SELECT p.*, pm.meta_value as parent_mission_id 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 (158534, 156043);
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 (158534, 156043);
1 SELECT pm.meta_value as mission_id, count(*) as total FROM wp_posts p INNER JOIN wp_postmeta pm ON p.ID = pm.post_id WHERE p.post_type = "story" AND pm.meta_key = "mission" AND pm.meta_value IN (158534, 156043) GROUP BY pm.meta_value
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (134385) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 123469 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 131125 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 131066 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 159292 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1