The arching sky is calling
Spacemen back to their trade.
ALL HANDS! STAND BY! FREE FALLING!
And the lights below us fade.
Out ride the sons of Terra,
Far drives the thundering jet,
Up leaps a race of Earthmen,
Out, far, and onward yet.
– ‘The Green Hills of Earth,’ Robert Heinlein
The USS Endeavour (NCC-91895) is a Constitution III-class starship assigned to the Fourth Fleet under the command of Karana Valance. Commissioned in early 2400, Endeavour was built from the parts of her decommissioned namesake, a Manticore-class, and reformed into something new: a symbol of Starfleet’s spirit of cooperation and exploration.
Since early 2401, she has been assigned to the Midgard Sector, on the Beta Quadrant border, and is part of Sirius Squadron, a unit responsible for maintaining the Federation’s regional interests. These interests include diplomatic outreach, with a particular focus on cooperation with the Federation’s allies in the Romulan Republic, as well as humanitarian aid for former Star Empire worlds, exploration of the vast and unknown territories of the fallen empire, and supporting the Federation’s border holdings and needs. As a powerful ship with a multi-mission profile, Endeavour’s day-to-day consists of providing necessary support to these essential operations.
Endeavour’s primary duty, however, is to act as the squadron’s expeditionary unit, the first choice to respond to emerging situations within the Midgard Sector and beyond. These duties may include humanitarian or tactical crises, but also extend to scientific mysteries or entering diplomatic hot-spots. When necessary, Endeavour can act independently for extended periods, and thus may be dispatched to regions or for durations where immediate support may be unavailable for some time.
Either duty keeps Endeavour’s crew occupied and challenged. In Midgard, Endeavour now seeks to reach out to those abandoned by the collapse of the empire, forge new friendships, and explore this newly-independent expanse. Refugees need Starfleet aid, worlds no longer under the rule of Rator or Romulus need welcoming to the galactic family, and vast stretches of the unknown must be explored. But the region is still volatile and dangerous, a breeding ground for criminals and warlords. Not everyone will look fondly on the Federation’s arrival, and many will have a right to be left alone. Walking the line between reaching out and interfering, between exploring and trespassing, between helping and imposing, is a tall challenge for Endeavour in this new era of Starfleet’s efforts to reach back out to the galaxy, and bring hope to a shrouded region.
This story is rated:
for content, which equates to roughly a 16+ rating
BF: Endeavour began in late 2019, and is over 25 missions and almost a million words long. While it is written with the hope of being accessible to new readers, some character threads and storylines are several years old. The following is a suggested reading list for people who want to catch up on old storylines, but do not necessarily wish to read all of Endeavour up to this point. An overall narrative summary can be found here and here on the wiki.
The suggested missions, in order:
Sirius Expeditionary Squadron is a unit centered around the Odyssey-class USS Sirius under the command of Commodore Matt Rourke. Sirius Squadron stands ready to deploy outside or on 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 main unit, organised around the Sirius herself, is an element of several powerful ships each able to take the lead or act independently depending on the mission’s needs. Deployed together, they are a supremely well-rounded and capable unit. Two additional divisions provide specialist support. The first, headed by the USS Redemption, acts as an operations element to provide engineering, humanitarian, or diplomatic services. The second, headed by the USS Liberty, fulfils dedicated exploratory or scientific missions. 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
Commanding Officer
Executive Officer
Chief Science Officer
Second Officer
Chief Flight Control Officer
Chief Operations Officer
Romulan Republic Exchange Officer
Chief of Security/Tactical
Chief Engineer
Chief Medical Officer
Chief Counsellor
Chief Communications Officer
Chief Intelligence Officer
Assistant Chief Operations Officer
Assistant Chief of Security/Tactical
Assistant Chief Science Officer
Black Knights Squadron Leader
Paramedic
Damage Control Specialist
Captain's Yeoman
Security Officer
Journalist
19 May 2025
Gateway Station, USS Blackbird, USS Endeavour, USS Liberty, USS Memphis, USS Mercury, USS Ranger, USS Redemption, USS Scylla, USS Sirius, USS Swiftsure and USS Tempest
The skyline of Alpha Centauri City shimmered under the rising sun, gold light catching on glass towers and reconstructed skyways to gleam anew. From the terrace atop the Starfleet Affairs Tower, the view stretched wide, from the bay where civilian transports ferried in supplies, to the scarred [...]
17 May 2025
Gateway Station, USS Blackbird, USS Endeavour, USS Liberty, USS Memphis, USS Mercury, USS Ranger, USS Redemption, USS Scylla, USS Sirius, USS Swiftsure and USS Tempest
The Blackout was down. But the battle for Alpha Centauri wasn’t over. The bridge of the Endeavour was a storm barely held at bay. Emergency lights glowed hostile red across consoles, some of them cracked and sparking. Bulkheads groaned under strain. Officers moved with practiced urgency, the [...]
16 May 2025
Gateway Station, USS Blackbird, USS Endeavour, USS Liberty, USS Memphis, USS Mercury, USS Ranger, USS Redemption, USS Scylla, USS Sirius, USS Swiftsure and USS Tempest
The lift ascended through the narrow shaft of emergency lights and vibrating metal. Beneath their feet, the pulsing hum of the outpost’s core reverberated through the station’s spine, a thudding heartbeat of engineering that made Rosewood’s teeth itch. Beside him, Ranicus checked her weapon [...]
15 May 2025
Gateway Station, USS Blackbird, USS Endeavour, USS Liberty, USS Memphis, USS Mercury, USS Ranger, USS Redemption, USS Scylla, USS Sirius, USS Swiftsure and USS Tempest
Beyond the reinforced canopy of the Blackbird’s bridge, Underspace twisted and pulsed, a copper maelstrom of compressed subspace and rippling distortions. They had traded one form of chaos for another, the dazzling spectacle of starships ablaze in the name of Alpha Centauri swapped for this. That [...]
Load Time: 1.93 seconds
Total SQL Queries: 302
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '34911' AND wp_posts.post_type = 'command' ORDER BY wp_posts.post_date DESC |
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 (19791) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (90580) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 90580 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 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48913) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19711) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (116) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 116 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 (106411) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 106411 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 = 48917 LIMIT 1 |
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 (41678) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142961) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 91252 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48927,48928,48926) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (48926,48927,48928) 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 (48925) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 48925 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19781) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 142961 LIMIT 1 |
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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48922,48923,48924) 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 (48921) 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 (19777) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (86472) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 86472 LIMIT 1 |
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 (155272) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (121978) ORDER BY meta_id ASC |
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 (143492) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (143533) 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 (72872) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 72872 LIMIT 1 |
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 (120365) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (53684) 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 (120363) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 120363 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 (143519) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 63690 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 = 53684 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 89923 LIMIT 1 |
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 (89886) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (119) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 119 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1837) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 1837 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (89887) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 89887 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 89886 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 * FROM wp_posts WHERE ID = 4134 LIMIT 1 |
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 = 41678 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 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 = 108 LIMIT 1 |
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 (91252) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 823 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 75814 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 40640 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 48962 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (66063) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (50845) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 50845 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (50841) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (40640) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (40639) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (85811,85812,85813,85814) 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 (41154) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 41154 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (41153) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (145115) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 145115 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (77688) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (58024) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48962) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (85814,85811,85812,85813) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (57995) ORDER BY meta_id ASC |
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 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 * FROM wp_posts WHERE ID = 82906 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 66064 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (82908) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 82908 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (149438) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (103701) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 103701 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (103700) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (66064) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 58024 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (145191) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (823) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 103637 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 141847 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141846) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140496) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 140496 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140495) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (103637) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19802) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (70317) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (85003) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 85003 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (84949) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (121979) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 121979 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (824) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 824 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141847) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 48933 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 145191 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 48929 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (92481) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (58031) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 58031 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48931,48932,48930) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (48930,48931,48932) 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 (48929) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (40637) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48933) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (91359) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 91359 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34300) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (70318) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 70318 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48934,48935,48936) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (48934,48935,48936) 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 (75814) ORDER BY meta_id ASC |
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 (34911) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 74506 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 76822 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 87059 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 83152 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 73054 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 136963 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 143546 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 120993 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 68948 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 30824 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 = 134987 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 134404 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 134567 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 90776 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 89925 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 68937 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 40633 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 37189 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 91355 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 74513 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 40627 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 68946 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 142382 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 40635 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 19805 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 68761 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 131092 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 84864 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 74646 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 89825 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 68943 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 131573 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 135003 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 12418 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 83573 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 19781 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 70317 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 141846 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 140495 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 19802 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 84949 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 121978 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 19777 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 40637 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 19791 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 19711 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (78360) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 78360 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 1834 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 = 34300 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 92481 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 134569 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 = 'ship_details_tour' ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 1 |
1 | SELECT * FROM wp_posts WHERE ID = 57471 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (155287,155003,154911,154871,154814,154741,154679,154006,153803,153416,153279,153188,152497,152260,151948,151831,151721,151589,151537,151356,151189,151115,150970,150917,150902,150800,150697,150585,150467,150217,149967,148836,148538,148431,148399,148271,147868,147661,147347,147196,146355,146039,145846,145229,145050,144573,144191,144008,143871,143523,143314,142864,142484,142219,141848,141700,141542,141308,135176,134571,134442,132563,132142,131656,131608,131166,127411,127373,127208,127108,126928,126842,126347,126030,125727,125413,125283,124690,124503,124351,124247,123977,123819,123602,123467,123332,123188,122928,122013,121173,120907,120806,120567,120351,106609,106540,106450,106413,106357,105965,105778,105526,105370,105071,104935,104679,104230,103996,103731,103670,103435,103142,103096,103052,103002,102843,102698,102696,102484,102389,102270,102139,101996,101660,101562,101351,101183,101009,100579,100266,99793,99264,97409,95450,95290,95223,95148,95074,95000,94945,94828,94765,94696,94638,94531,94421,94134,94026,93958,93906,93814,93746,93696,93665,93579,93542,93161,93113,93002,92912,92542,92484,92432,92360,92253,92111,91902,91629,90912,90696,90555,90449,90221,89742,89580,89467,89410,89033,87767,87485,86392,86293,86094,86022,85776,85633,85545,85361,85239,85231,85047,84918,84528,84028,83840,83710,83576,82571,82505,81434,80500,80347,80067,79964,79159,78986,78654,78341,78222,77870,77627,76825,75430,74643,74101,70019,69954,69715,69584,69537,69437,69371,68511,68435,68372,68179,68135,68043,67994,67918,67836,67807,67716,67637,67456,67415,67327,67270,67204,66884,66780,66645,66575,66444,66345,66235,66109,66026,66023,65857,64897,64624,64435,64216,63790,63430,63249,63023,60777,60524,60374,60255,60054,59916,59750,59417,59241,59155,58888,58753,57218,57152,57079,57015,56926,56891,56774,56675,56615,56556,56492,56288,56229,56109,55976,55791,55578,55150,54999,54890,54719,54577,54496,54391,54280,54059,53486,53349,53232,53160,53053,52954,52858,52769,52633,52415,52135,52041,50192,50139,50095,49968,49880,49665,49541,49364,49300,49242,48853,48804,48657,48595,48442,48402,48339,48282,48211,48147,48067,48034,47985,47925,47840,47802,47760,47705,47676,47544,47282,47070,46813,46399,45861,45753,45647,45436,45335,45176,45069,44825,44500,44207,43882,43553,43278,42961,42591,42286,41712,41362,41117,40806,40693,39941,39836,39711,39639,39581,39503,39429,39320,39215,39118,39046,39013,38977,38931,38913,38834,38766,38734,38654,38578,38467,38234,38070,37889,37449,37260,37172,37003,36854,36774,36668,36512,36344,36099,35648,35647,35269,35268,35267,35266,35264,35262,35261,35260,35259,35258,35254,35253,35252,35251,35250,35249,35248,35247,35246,35245,35242,35241,35240,35239,35238,35237,35236,35235,35234,35233,35232,35231,35230,35228,35227,35226,35225,35224,35223,35222,35221,35220,35219,35218,35216,35215,35214,35212,35211,35207,35203,35202,35201,35200,35198,35197,35196,35195,35194,35193,35192,35190,35189,35188,35187,35183,35182,35181,35180,35179,35178,35177,35176,35175,35170,35169,35168,35167,35166,35165,35164,35163,35162,35161,35160,35157,35156,35155,35154,35153,35152,35151,35150,35149,35148,35144,35143,35141,35140,35139,35138,35137,35134) 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 = 'mission' AND wp_postmeta.meta_value IN ('159344','149438','141305','131080','122015','103668','101995','96435','91313','87474','85230','83575','76845','74098','69369','64628','63021','58751','54006','50194','47527','45332','43276','40691','39116','37887','36087','35255','35204','35199','35184','35172','35158','35146','35132') ) ) AND wp_posts.post_type = 'story' 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 = 34911 ORDER BY p.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_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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (63146) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 57995 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 63146 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 103700 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 66063 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 50841 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 40639 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 41153 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 77688 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 37186 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 43339 LIMIT 1 |
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 (131453) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 120111 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 105433 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 * FROM wp_posts WHERE ID = 76220 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 = 16786 LIMIT 1 |
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 (16756) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16159) 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 (69176,39168,19422,19023) 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 = '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 * FROM wp_posts WHERE ID = 25122 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 36215 LIMIT 1 |
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 (120132) ORDER BY meta_id ASC |
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 (75816) 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 (16776) 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 (16786) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (131490) 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 (105431) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 16366 LIMIT 1 |
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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (134357) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 134357 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 * FROM wp_posts WHERE ID = 264 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 = 75816 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 * FROM wp_posts WHERE ID = 69254 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 34324 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 57996 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 31092 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 58884 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 43403 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 31606 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 40631 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 38086 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 38479 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 57964 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 36354 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 19812 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 19807 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 57650 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 70355 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 69224 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 40625 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 40629 LIMIT 1 |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (140396,105465) 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 ID IN (142670) |
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 wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (89901,143519) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142785,142784) 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 = '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 wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (131453,82965,134340) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142670) 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 ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"34911\"%' ) ) 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 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 = 34911 AND manifest_pm.meta_key LIKE "manifest_%_character" AND character_p.post_author != 1036 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18806) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (18806) |
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.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 IN ('159344','149438','141305','131080','122015','103668','101995','96435','91313','87474','85230','83575','76845','74098','69369','64628','63021','58751','54006','50194','47527','45332','43276','40691','39116','37887','36087','35255','35204','35199','35184','35172','35158','35146','35132') ) ) 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 * FROM wp_posts WHERE ID = 36362 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 19779 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1 |