Bravo Fleet
USS Tannhäuser
Typhoon-class • NCC-90008 • Tannhäuser Operations and Outreach Division • Sirius Expeditionary Squadron • Fourth Fleet • Managed by ADM Alexander Beckett
The USS Tannhäuser (NCC-90008) is a Typhoon-class exploratory cruiser assigned to the Fourth Fleet under the command of Fleet Captain Addison Faust. As part of Sirius Squadron, it is the flagship to the unit’s Operations and Outreach Division, responsible for assignments needing the steady Starfleet hand to help with infrastructure, humanitarian aid, and diplomatic connection. A powerful mission platform, Tannhäuser acts as the centre of operations for division missions, hosting negotiations and brokering agreements, while providing key support to the specialist ships under its command.
This story is rated:
for content, which equates to roughly a 16+ rating
Header image made by Jetfreak-7
Sirius Expeditionary Squadron
Sirius Expeditionary Squadron is a unit centered around the Odyssey-class USS Sirius under the command of Commodore Matt Rourke and oversight of Director of Squadron Operations Vice Admiral Owen Morgan. Sirius Squadron stands ready to deploy outside or at the fringes of Federation territory at short notice to respond to emerging situations across the galaxy. With multiple versatile and powerful ships at its disposal, the squadron can operate independently and without support for extended periods, and is flexible enough to face a range of missions, including under volatile circumstances where objectives and conditions can quickly change. While this profile often leads Sirius Squadron to respond to geopolitical crises, the unit’s versatility make it equally suited emergent scientific investigations.
The squadron is based out of Gateway Station, in the Midgard Sector, which provides logistical support and operational and administrative leadership.
The HQ unit is organised around the Sirius herself, supported by her attached ship Alhabor. Four additional divisions provide specialist support:
- Endeavour Division: An administrative group including allied Romulan Republic and Klingon Empire assets assigned to the Fourth Fleet. The division exists to maintain unified oversight and communication, each ship answering directly to squadron command, rather than deploying as a task group.
- Liberty Science and Exploration Division: Conducts exploratory operations primarily beyond the Federation’s borders, expanding Starfleet’s understanding of unknown regions. When deployed alongside the squadron, these ships provide support through reconnaissance and advance operations.
- Memphis Division: Advances the squadron’s knowledge through sustained research, survey missions, and integrated intelligence work. Specialises in follow-up study and the detailed analysis of squadron-priority regions, organisations, or phenomena.
- Tannhäuser Operations and Outreach Division: Provides engineering, humanitarian, or diplomatic services primarily on the Federation frontier. This division is the most likely to be deployed as a unit and can be sent to whole regions in need, giving disaster relief or building infrastructure. When deployed alongside the squadron, these ships provide logistical support.
The divisions may deploy independently or in support of one another, depending on operational needs.
To follow the main stories of Sirius Squadron, visit the USS Endeavour Command page.
Badge by user; ‘Star dog’ image element generated with Midjourney
Squadron Commands
Endeavour Explorer Division
Liberty Science and Exploration Division
Memphis Research Cruiser Division
Tannhäuser Operations and Outreach Division
Crew Manifest
-
Addison Faust
Commanding Officer
Squadron Deputy Commander -
Donal Garec
Executive Officer
-
Archer Kowalski
Captain of Engineering
-
Barin Ra-Talorei
Chief Science Officer
-
Lucor Daine
Chief of Security/Tactical
Load Time: 0.45 seconds
Total SQL Queries: 186
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '170212' AND wp_posts.post_type = 'command' ORDER BY wp_posts.post_date DESC |
| 1 | SELECT * FROM wp_posts WHERE ID = 108 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 172502 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (172502) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16355) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 112 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (112) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 89923 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (89923) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (63690) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (108) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 53684 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (82965) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 76220 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (131453) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 16786 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140126) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 131490 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (131490) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16786) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 16776 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (53684) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (143492) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 142808 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4134) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (72872) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 155272 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (155272) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (41678) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 41668 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (41668) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 162355 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (162355) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 116 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 143492 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (116) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (169723) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 16355 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (89901) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 63690 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 143519 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (143519) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 143533 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (143533) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16776) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142808) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (105933) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142460) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 48921 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48921) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (48922,48923,48924) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48922,48923,48924) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 74516 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (74516) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (90006) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 142460 LIMIT 1 |
| 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (60469) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (173993,173660) |
| 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 (173660, 173993) ORDER BY t.name ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (173660,173993) 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 IN ('fleet_action','fiction_campaign') ) ) 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 wp_posts.* FROM wp_posts WHERE ID IN (170919) |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (170919) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 32091 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 88217 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (74515) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 60469 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (76220) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (90004) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 75814 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (75814) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (89925) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 48909 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48909) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (48910,48911,48912) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48912,48910,48911) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 89926 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (89926) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 48917 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48914,48915,48916) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48917) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (48918,48919,48920) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48920,48918,48919) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 142459 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142459) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (60449) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 48913 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48913) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (48914,48915,48916) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT * FROM wp_posts WHERE ID = 72872 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 105933 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (170212) 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_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'parent' AND wp_postmeta.meta_value = '142785' ) ) AND wp_posts.post_type = 'command_unit' 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 = 120216 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_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'parent' AND wp_postmeta.meta_value = '142670' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) 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 (170698,169741,142785) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (170623,170625) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'parent' AND wp_postmeta.meta_value = '170698' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (169723,89901) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'parent' AND wp_postmeta.meta_value = '169741' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (105465,140396) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (82965,131453) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.post_date DESC |
| 1 | SELECT * FROM wp_posts WHERE ID = 142670 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_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'parent' AND wp_postmeta.meta_value = '142784' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) 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 (169978) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 140126 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 36215 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 25122 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 = 'promoted_user' AND wp_postmeta.meta_value = '1036' ) ) AND wp_posts.post_type = 'user_rank_assignment' AND ((wp_posts.post_status = 'publish')) 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 (69176,39168,19422,19023) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 16159 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16159) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142670) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142784) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16756) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 60449 LIMIT 1 |
| 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 = 169978 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 172501 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (172501) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 172510 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (172510) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 89925 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 90004 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 74515 LIMIT 1 |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (142784) |
| 1 | SELECT * FROM wp_posts WHERE ID = 90006 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 = '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 DISTINCT 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 LIKE "mission_additional_ships_%" OR pm.meta_key = "mission_ship" ) AND pm.meta_value = 170212 ORDER BY p.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 = 'member_user' AND wp_postmeta.meta_value = '1036' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (18806) |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18806) ORDER BY meta_id ASC |
| 1 | SELECT DISTINCT character_p.post_author FROM wp_postmeta manifest_pm INNER JOIN wp_posts character_p ON manifest_pm.meta_value = character_p.id WHERE manifest_pm.post_id = 170212 AND manifest_pm.meta_key LIKE "manifest_%_character" AND character_p.post_author != 1036 |
| 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_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"170212\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 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_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '170212' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 16756 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 120111 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (120365) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (172768) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 75816 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (75816) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 170704 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (170704) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (170570) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 169986 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (169986) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 172768 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (170052) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 1834 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 169993 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (169993) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (105465) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 4134 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140396) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 41678 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 120363 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (120363) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 120365 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1834) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (78360) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (120111) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (120334) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 16366 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16366) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 264 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (264) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (69453) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 120132 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (120132) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (120216) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 120334 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 120209 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 78360 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (120209) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 44483 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (44483) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (170623) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 170052 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (170625) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 170570 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 34911 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34911) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1 |