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

USS Blackbird

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

Status
In Progress
Total Stories
8
Start Date
24/05/2025

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 [...]

2 July 2025

Solstice - 7

USS Blackbird: Solstice

The interrogation room in the Starfleet Liaison Tower was small, cold, and plain, smelling of recycled air and antiseptic; the textbook definition of impersonal. Cassidy entered first, silent and taking up position against the far wall. Arms folded across his chest, he stood with squared shoulders, [...]

28 June 2025

Solstice - 6

USS Blackbird: Solstice

The requisitioned data came in overnight. In dribs and drabs, civilian owners of warehouses and processing facilities cooperated with Starfleet orders to hand over their precious records, all of them lodging protests that it wasn’t the Rooks’ problem to field. Cassidy could kick that upstairs [...]

24 June 2025

Solstice - 5

USS Blackbird: Solstice

They tried four different clubs before settling on Embassy. Q’ira had insisted on venues outside the centre of AC City, convinced the fringe would have more bite. But the occupation had gutted everything, and the city’s nightlife hadn’t so much bounced back as been curated for visiting [...]

Load Time: 0.39 seconds

Total SQL Queries: 34

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 = 134439 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 * FROM wp_posts WHERE ID = 84168 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 (159053,159212) 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 (159053, 159212) ORDER BY t.name ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (159212,159053)
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 = 105431 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (105433) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 105433 LIMIT 1
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 = 148933 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 wp_posts.* FROM wp_posts WHERE ID IN (159560,159203,158989,158747)
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 * FROM wp_posts WHERE ID = 134340 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 = '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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158747,158989,159203,159560) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 136963 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 = '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 (134340) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 134569 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 57471 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 134987 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 135003 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1