Bravo Fleet
- Headquarters
-
Deep Space 47
Beyond the Badlands - Members
- 31
Task Force 47
Fourth Fleet Pathfinding Operations
Based out of Deep Space 47 at the gateway to the Thomar Expanse, Task Force 47 is charged with establishing and developing new opportunities for Starfleet’s primary mission of exploration. The pathfinders of the fleet, it is their duty to negotiate with local powers for access, support, and intelligence in order to explore regions previously inaccessible due to practicality or politics.
The changing status quo of the Alpha and Beta Quadrants has seen some borders collapse, others arise, and the friends and foes of the Federation change in warmth or hostility. Beyond the danger of such disruption are the opportunities born of new relationships and vanishing barriers.
These opportunities are the mission of Task Force 47. However close or far, they are charged to treat and negotiate with foreign governments to secure access to regions of space near or even within their borders. From there, Starfleet can explore areas never before available to them, whether they be on their doorstep and once locked away by politics, or on the far side of the quadrants and unavailable due to limited resources. Whether these locals offer merely begrudging acceptance of Starfleet’s proximity, open access to pass through their space, or outright support for Federation vessels, these are opportunities that cannot be missed.
This is a blend of exploration and diplomacy, for the latter is an ongoing responsibility to prove Starfleet is as good as their word, and demonstrate the value of such close scientific relationships. And the chance to go where no one could go before is beyond value.
-
Varen WyllTask Force Commanding Officer
-
Aelin MaoriTask Force Executive Officer
-
Charlotte MacColganTask Group 13 Commanding Officer
Task Force Objectives
The primary objectives of our Task Force, carried out through the stories of our members.
-
Negotiate with local powers for access to regions unexplored by the Federation
-
Explore beyond frontiers once politically-inaccessible to Starfleet
-
Maintain relationships with regional governments to secure necessary mission support
-
Build bridges with foreign powers by demonstrating the value of these ongoing, mutually-beneficial agreements
Recent Activity
Check out our latest announcements, read our latest stories, and learn about who just received a new award or promotion!
Recent Announcements
-
Posted on 2 June 2025
-
Posted on 8 February 2025
-
Posted on 7 December 2024
-
Posted on 7 September 2024
-
Posted on 8 June 2024
-
Posted on 3 February 2024
Recent Story Posts
Recent Promotions
Recent Merit & Competition Awards
Task Force Roster
A complete list of all members that are part of this Task Force, organized by Task Group.
Task Group 13
Task Group 63
Load Time: 2.15 seconds
Total SQL Queries: 480
| 4 | 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 = '3090' ) ) 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 ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('task-force-47') AND post_type IN ('group','attachment') |
| 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 = '3090' ) ) 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 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 = '3125' ) ) 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 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 (3120) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' 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 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 = '3120' ) ) 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 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 (3115) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159756) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3115' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159757) 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 = '3115' ) ) 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 = 159756 LIMIT 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 (3090) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158975,158411,157833,157321,157240,157198,157197,157116) 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 (3060) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' 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 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 = '3130' ) ) 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 (19341) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 19341 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16133) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152621) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3060' ) ) 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 * FROM wp_posts WHERE ID = 16133 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (152902,152622) 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 = '3060' ) ) 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 = 152621 LIMIT 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 (3038) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (145012) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3038' ) ) 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_posts.post_author IN (3125) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' 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 (3130) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' 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 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 = '3038' ) ) 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 = 4918 LIMIT 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 (283) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"136233\"%' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (136233) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (136233) |
| 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 (283) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (24418) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 24418 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 147863 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4918) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '283' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (23312,18217) 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 = '283' ) ) 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 = 53125 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 = '2121' ) ) 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 = 157071 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142681) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (142681) |
| 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 (2121) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"34883\"%' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34883) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (34883) |
| 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 (2121) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18507) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 18507 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16154) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 16154 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140865,85290,57548,39058,30599,26284,25017,24372,22540,22539,22538,22422,22421) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (145013) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 145012 LIMIT 1 |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (142666) |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16148) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (156185) |
| 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 (2886) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (148461,144079,131435,129667,120871,104600,104426,104399,104323) 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 = '2886' ) ) 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 = 1790 LIMIT 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 (2796) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '156100' ) ) 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 (2796) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"156100\"%' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156100) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (156100) |
| 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 (2796) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18510) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 18510 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156116) 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 (2886) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"156185\"%' ) ) 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 = 156116 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156082) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2796' ) ) 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 * FROM wp_posts WHERE ID = 16148 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156579,141792,102395,100541,99867,98550,98032,97778,97777,97616) 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 = '2796' ) ) 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 = 156082 LIMIT 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 (2233) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18514) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 18514 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16139) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (32205) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156185) 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 (2886) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '156185' ) ) 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 = 83765 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 16141 LIMIT 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 (2989) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '141317' ) ) 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 (2989) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"141317\"%' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141317) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (141317) |
| 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 (2989) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18513) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 18513 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16141) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141179) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 141179 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (137634) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2989' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (143693,142228,141219,141181,141173,141166,137635) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 1868 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 = '2989' ) ) 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 = 137634 LIMIT 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 (2929) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19340) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 19340 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16135) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (126430) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2929' ) ) 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 * FROM wp_posts WHERE ID = 16135 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159720,142214,126431) 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 = '2929' ) ) 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 = 126430 LIMIT 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 (283) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '136233' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142666) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (32159) 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 = '3027' ) ) 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 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 (3063) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (153007) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3063' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (153008) 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 = '3063' ) ) 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 = 153007 LIMIT 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 (3027) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (143298) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 143298 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142943) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3027' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (148218,146317,144651,143692,143230,142944) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 142943 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 = '3069' ) ) 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 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 (2988) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (136774) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2988' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (136968,136775) 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 = '2988' ) ) 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 = 136774 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 30074 LIMIT 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 (2980) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '136674' ) ) 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 (2980) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"136674\"%' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (136674) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (136674) |
| 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 (2980) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' 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 = 153691 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (153692) 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 = '2980' ) ) 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 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 = 'group' AND wp_postmeta.meta_value = '51302' ) ) AND wp_posts.post_type = 'game' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC |
| 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 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 1=1 AND wp_posts.post_parent = 51345 AND wp_posts.post_type = 'group' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order 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 = 'group' AND wp_postmeta.meta_value = '51345' ) ) AND wp_posts.post_type = 'game' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 51344 AND wp_posts.post_type = 'group' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order 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 = 'group' AND wp_postmeta.meta_value = '51344' ) ) AND wp_posts.post_type = 'game' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 51302 AND wp_posts.post_type = 'group' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order 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 = 'group' AND wp_postmeta.meta_value = '51302' ) ) AND wp_posts.post_type = 'game' 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 = 'member_user' AND wp_postmeta.meta_value = '3069' ) ) 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_posts.post_author IN (3131) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' 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 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 = '3131' ) ) 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 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 (3129) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' 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 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 = '3129' ) ) 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 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 (3089) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157028) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3089' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157029) 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 = '3089' ) ) 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 = 157028 LIMIT 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 (3069) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (153691) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156247,139792,138738,138052,137003,136276,136063,136061,136059,135873) 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 (2696) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' 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 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 = '2419' ) ) 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 = 60772 LIMIT 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 = 'member_user' AND wp_postmeta.meta_value = '2462' ) ) 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 * FROM wp_posts WHERE ID = 66903 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147664,97669,52244,52070,52037) 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 = '2462' ) ) 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 = 52036 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 63689 LIMIT 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 (2457) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '64764' ) ) 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 (2457) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"64764\"%' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (64764) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (64764) |
| 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 (2457) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (60772) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (51876) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (66903) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2457' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (105429,64749,55373,53639,53096,52599,52451,52397,52211,51877) 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 = '2457' ) ) 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 = 51876 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142691) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (142691) |
| 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 (2419) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '156113' ) ) 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 (2419) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"156113\"%' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156113) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (156113) |
| 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 (2419) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (129429,96471,82131,64456,57263,53220,52899,52742,52705,49893) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (52036) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 66904 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (81091) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 105868 LIMIT 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 = 'member_user' AND wp_postmeta.meta_value = '2696' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158716,158602,81252,81092) 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 = '2696' ) ) 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 = 81091 LIMIT 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 (2657) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (74335) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 74335 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (74272) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2657' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (89446,74273) 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 = '2657' ) ) 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 = 74272 LIMIT 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 (2486) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '134692' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (66904) 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 (2486) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"134692\"%' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (134692) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (134692) |
| 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 (2486) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (67917) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 67917 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (67313) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2486' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (83932,69528,58081,56581,55760,54935,54718,54627,54581,54483) 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 = '2486' ) ) 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 = 67313 LIMIT 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 (2462) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' 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 = 32205 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 16139 LIMIT 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 = 'member_user' AND wp_postmeta.meta_value = '2233' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157742,157842,158203,158320,159091,159374) 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 (98972, 106582, 131714, 139656, 144781, 157177) ORDER BY t.name ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (157177,144781,139656,131714,106582,98972) |
| 1 | SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (235) ) AND wp_posts.post_type = 'group_news' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 6 |
| 1 | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('group_news_category') AND t.name IN ('Task Force 47') |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156906,159085,159183,159381,159463,159546) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (159463,159546,159381,159183,156906,159085) |
| 1 | SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (18,73,2185,2233,2796,2886,2929,2989,3038,3060,3090,3115,3120,3125,3130,2121,283,2419,2457,2462,2486,2657,2696,2980,2988,3027,3063,3069,3089,3129,3131) AND wp_posts.post_type = 'story' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 6 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159802,159817,159854,159857,159860,159863) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (159863,159860,159857,159854,159817,159802) |
| 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 = 'promoted_user' AND wp_postmeta.meta_value IN ('18','73','2185','2233','2796','2886','2929','2989','3038','3060','3090','3115','3120','3125','3130','2121','283','2419','2457','2462','2486','2657','2696','2980','2988','3027','3063','3069','3089','3129','3131') ) ) 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 LIMIT 0, 6 |
| 1 | SELECT id, user_id, award_id, post_id, game_id, ribbon_count, word_count, approver_user_id, date, description, approved_date FROM bfms_ribbons WHERE user_id IN (18,73,2185,2233,2796,2886,2929,2989,3038,3060,3090,3115,3120,3125,3130,2121,283,2419,2457,2462,2486,2657,2696,2980,2988,3027,3063,3069,3089,3129,3131) AND approver_user_id IS NOT NULL ORDER BY `date` DESC LIMIT 0, 6 |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (159374,159091,158320,158203,157842,157742) |
| 1 | SELECT * FROM wp_posts WHERE ID = 136576 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 = 'user' AND wp_postmeta.meta_value IN ('18','73','2185','2233','2796','2886','2929','2989','3038','3060','3090','3115','3120','3125','3130','2121','283','2419','2457','2462','2486','2657','2696','2980','2988','3027','3063','3069','3089','3129','3131') ) AND ( ( ( mt1.meta_key = 'award' AND mt1.meta_value != '19281' ) AND ( mt1.meta_key = 'award' AND mt1.meta_value != '19278' ) AND ( mt1.meta_key = 'award' AND mt1.meta_value != '87926' ) AND ( mt1.meta_key = 'award' AND mt1.meta_value != '19284' ) ) ) ) AND wp_posts.post_type = 'user_award' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 6 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3131) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3131' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3129) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3129' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3089) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3089' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3069) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3069' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3063) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3063' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3027) ORDER BY umeta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (98972,106582,131714,139656,144781,157177) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (136576) ORDER BY meta_id ASC |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2988) ORDER BY umeta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147488) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 158822 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 156827 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (133516) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 133516 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147849) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 147849 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147848) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (104322) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2886' ) ) 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 * FROM wp_posts WHERE ID = 104322 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147801) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 147801 LIMIT 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 = 'member_user' AND wp_postmeta.meta_value = '2980' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (51353) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (86926) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 86926 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (150372) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 150372 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (150371) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 150371 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 147848 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 150382 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (86925) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2419' ) ) 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 * FROM wp_posts WHERE ID = 147488 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 86925 LIMIT 1 |
| 1 | SELECT * FROM wp_users WHERE ID = '3027' LIMIT 1 |
| 1 | SELECT * FROM wp_users WHERE ID = '2988' LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 155971 LIMIT 1 |
| 1 | SELECT * FROM wp_users WHERE ID = '73' LIMIT 1 |
| 1 | SELECT * FROM wp_users WHERE ID = '2989' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2929) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2929' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2886) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2886' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2796) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2796' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2233) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2233' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2185) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2185' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (73) ORDER BY umeta_id ASC |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (18) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3038' LIMIT 1 |
| 1 | SELECT * FROM wp_users WHERE ID = '18' LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18486,49894,51878,52038,54484,74274,81093,135874,136776,142945,153009,153693,157030,159858,159864) 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 = 'member_unit' AND wp_postmeta.meta_value = '51345' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18322,23382,27212,32161,97617,104324,126432,137636,145014,152623,157117,159758,159803,159818,159861,22416) 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 = 'member_unit' AND wp_postmeta.meta_value = '51344' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (51344,51345) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 51302 AND wp_posts.post_type = 'group' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.menu_order ASC |
| 1 | SELECT wp_posts.* 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 = 'ship_hq_tf' AND wp_postmeta.meta_value = '51302' ) AND ( mt1.meta_key = 'ship_hq' AND mt1.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2419) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2419' LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (51302) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND (wp_posts.ID = '51302') AND wp_posts.post_type = 'group' ORDER BY wp_posts.post_date DESC |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2989) ORDER BY umeta_id ASC |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3038) ORDER BY umeta_id ASC |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2980) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '283' LIMIT 1 |
| 1 | SELECT * FROM wp_users WHERE ID = '2980' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2696) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2696' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2657) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2657' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2486) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2486' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2462) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2462' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2457) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '2457' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (283) ORDER BY umeta_id ASC |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2121) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3060' LIMIT 1 |
| 1 | SELECT * FROM wp_users WHERE ID = '2121' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3130) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3130' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3125) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3125' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3120) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3120' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3115) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3115' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3090) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_users WHERE ID = '3090' LIMIT 1 |
| 1 | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3060) ORDER BY umeta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 156807 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 16131 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 51302 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 19245 LIMIT 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 = 'member_user' AND wp_postmeta.meta_value = '73' ) ) 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 * FROM wp_posts WHERE ID = 16150 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (33540,26306,23367,22003,18132) 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 = '73' ) ) 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 = 22951 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 76202 LIMIT 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 (18) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '156133' ) ) 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 (18) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"156133\"%' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (156133) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (156133) |
| 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 (18) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19245) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19244) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 157096 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (81798) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 81798 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (43421) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '18' ) ) 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 * FROM wp_posts WHERE ID = 19244 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (83878,55425,51943,44400,43639,17792) 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 = '18' ) ) 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 = 43421 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19284) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 19284 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19281) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 19281 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (22951) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157096) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 87926 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (32999) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (32196,32195,32194,32193,32160) 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 = '2233' ) ) 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 = 32159 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142682) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (142682) |
| 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 (2185) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '140397' ) ) 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 (2185) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"140397\"%' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140397) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (140397) |
| 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 (2185) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (33790) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 33790 LIMIT 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 = 'member_user' AND wp_postmeta.meta_value = '2185' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16150) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (98968,81194,33445,32790,30153,28455,27725,27724,27338,27211) 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 = '2185' ) ) 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 = 32999 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (155970) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (155970) |
| 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 (73) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '155961' ) ) 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 (73) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"155961\"%' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (155961) ORDER BY meta_id ASC |
| 1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (155961) |
| 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 (73) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18509) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 18509 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (87926) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (31021) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16131) ORDER BY meta_id ASC |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159856) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3125' ) ) 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 * FROM wp_posts WHERE ID = 159816 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 = '3125' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157209) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 157209 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157115) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3090' ) ) 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 * FROM wp_posts WHERE ID = 157115 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18511) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 18511 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16145) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 16145 LIMIT 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 = 'member_user' AND wp_postmeta.meta_value = '3129' ) ) 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 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 = '3120' ) ) 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 * FROM wp_posts WHERE ID = 159856 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 = '3129' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159859) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3130' ) ) 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 * FROM wp_posts WHERE ID = 159859 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 = '3130' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159862) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3131' ) ) 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 * FROM wp_posts WHERE ID = 159862 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 = '3131' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19338) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 19338 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159816) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 159801 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 31021 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 = '2121' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (150399) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 150399 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (150397) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 147856 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 150456 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 150431 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 150397 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 150386 LIMIT 1 |
| 1 | SELECT * FROM wp_posts WHERE ID = 150384 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (26791) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2121' ) ) 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 * FROM wp_posts WHERE ID = 26791 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19623) 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3120' ) ) 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 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 = '2419' ) ) 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 * FROM wp_posts WHERE ID = 19623 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19628) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 19628 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19349) 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 = 'member_user' AND wp_postmeta.meta_value = '2886' ) ) 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 * FROM wp_posts WHERE ID = 19349 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19626) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 19626 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (60014) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 60014 LIMIT 1 |
| 1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159801) ORDER BY meta_id ASC |
| 1 | SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1 |