DEV BUILD - NOT FOR PUBLIC USE
 

USS Blackbird (Archive)

Solstice

In the aftermath of the occupation of Alpha Centauri, the Rooks find the city has more than one skeleton hidden in the closet...

Mission Description

Within weeks of the liberation of Alpha Centauri from the Vaadwaur invasion, there is a new threat to this tenuous peace. Bodies are found across the city, local government officials murdered, their bodies dumped with a threatening message. Something is rotten in the Federation heartlands – and it’s the Rooks’ job to bring it to light.

About the Mission

Command
Status
Complete
Total Stories
11
Start Date
24/05/2025
End Date
11/07/2025

11 July 2025

Solstice - 11

USS Blackbird: Solstice

Stripping the office of what scant personal marks the Rooks had left in their weeks here left behind, Rosewood thought, a lot of beige. Late afternoon sun spilling through the tall windows that blocked off most of the hum of Alpha Centauri City beyond tried to pain the carpets and walls vibrant [...]

11 July 2025

Solstice - 10

USS Blackbird: Solstice

Much of the city had changed, torn asunder by the Vaadwaur, or even just transformed over the decades as people lived, thrived, and grew. Even his family home was different; no children living there, not even his father there any more, the vast red brick house with its white trims grand and stately [...]

10 July 2025

Solstice - 9

USS Blackbird: Solstice

‘It just doesn’t sit right with me, you know?’ Nallera sprawled on the cushioned bench in the heart of the Rooks’ Alpha Centauri offices. The rhythmic thunk of her rubber ball bouncing off the walls, ceiling, or floor as she tossed it about, always to return to her hand, punctuated her [...]

7 July 2025

Solstice - 8

USS Blackbird: Solstice

‘Fascinating.’ Captain Takahashi’s reaction was positively Vulcanesque, his expression shifting no more than an eyebrow-raise as he read the report Cassidy had put before him. ‘Excellent work, Commander.’ ‘Thank you, sir.’ Cassidy’s voice was clipped, hands clasped behind his back [...]

Load Time: 0.27 seconds

Total SQL Queries: 31

1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '156325' AND wp_posts.post_type = 'mission' ORDER BY wp_posts.post_date DESC
1 SELECT * FROM wp_posts WHERE ID = 136963 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 = 16756 LIMIT 1
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 ) 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 (163230,163266) 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 (163230, 163266) ORDER BY t.name ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (163230,163266)
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 (156325);
1 SELECT * FROM wp_posts WHERE ID = 135114 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 149742 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 134439 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 148933 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 135003 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156325) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 134987 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 57471 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 134569 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (134340) 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 = '156325' ) ) 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 (159560,159772,159869,159878) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (159878,159869,159772,159560)
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 = '156325' ) ) 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 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 * FROM wp_posts WHERE ID = 134340 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 * FROM wp_users WHERE ID = '1036' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1