| 1 |
SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '35731' AND wp_posts.post_type = 'mission' ORDER BY wp_posts.post_date DESC |
| 1 |
SELECT * FROM wp_posts WHERE ID = 132001 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 27493 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 84168 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 88217 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 86925 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 41378 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 88325 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 136019 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 100837 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 66022 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 105004 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 138229 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 35705 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 104985 LIMIT 1 |
| 1 |
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35705) ORDER BY meta_id ASC |
| 1 |
SELECT * FROM wp_posts WHERE ID = 10790 LIMIT 1 |
| 1 |
SELECT COUNT(*)
FROM wp_posts p
INNER JOIN wp_postmeta pm
ON p.ID = pm.post_id
WHERE p.post_type = "story"
AND p.post_status = "publish"
AND pm.meta_key = "mission"
AND pm.meta_value IN (35731, 38980, 37455, 35734, 36060, 36073, 36087, 36155, 36186, 36212, 36288, 36292, 36300, 36351, 36413, 36436, 36482, 36527, 36691, 36795, 36883, 36893, 36897, 36920, 37024, 37263, 37333, 37383, 37521, 37529, 37783, 37873, 37887, 37934, 37936, 37992, 38072, 38117, 38403, 38477, 38865, 38885, 39025, 39043, 39049, 39116, 39125, 39163, 39183, 39208, 39228, 39250, 39384, 39565, 39614, 40062, 140343);
|
| 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 ID IN (140922,140618) |
| 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 (140618, 140922) ORDER BY t.name ASC |
| 1 |
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140618,140922) ORDER BY meta_id ASC |
| 1 |
SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND (
( wp_postmeta.meta_key = 'event_status' AND wp_postmeta.meta_value = 'In Progress' )
AND
( mt1.meta_key = 'event_type' AND mt1.meta_value = '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 wp_posts.* FROM wp_posts WHERE ID IN (122202) |
| 1 |
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (122202) ORDER BY meta_id 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 = 47905 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 13193 LIMIT 1 |
| 1 |
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35731) ORDER BY meta_id ASC |
| 1 |
SELECT p.*, pm.meta_value as parent_mission_id
FROM wp_posts p
INNER JOIN wp_postmeta pm
ON p.ID = pm.post_id
WHERE p.post_type = "mission"
AND pm.meta_key = "parent"
AND pm.meta_value IN (38980, 37455, 35734);
|
| 1 |
SELECT * FROM wp_users WHERE ID = '1036' LIMIT 1 |
| 1 |
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1036) ORDER BY umeta_id ASC |
| 1 |
SELECT * FROM wp_posts WHERE ID = 35706 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 35732 LIMIT 1 |
| 1 |
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35732) 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 = '0' )
) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC |
| 1 |
SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (
( wp_postmeta.meta_key = 'mission' AND wp_postmeta.meta_value = '35731' )
) AND wp_posts.post_type = 'story' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 4 |
| 1 |
SELECT wp_posts.* FROM wp_posts WHERE ID IN (40453,37454,35733) |
| 1 |
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35733,37454,40453) ORDER BY meta_id ASC |
| 1 |
SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND (
( wp_postmeta.meta_key = 'parent' AND wp_postmeta.meta_value = '35731' )
) AND ((wp_posts.post_type = 'mission' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC |
| 1 |
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (38980,37455,35734) ORDER BY meta_id ASC |
| 1 |
SELECT p.*, pm.meta_value as parent_mission_id
FROM wp_posts p
INNER JOIN wp_postmeta pm
ON p.ID = pm.post_id
WHERE p.post_type = "mission"
AND pm.meta_key = "parent"
AND pm.meta_value IN (36060, 36073, 36087, 36155, 36186, 36212, 36288, 36292, 36300, 36351, 36413, 36436, 36482, 36527, 36691, 36795, 36883, 36893, 36897, 36920, 37024, 37263, 37333, 37383, 37521, 37529, 37783, 37873, 37887, 37934, 37936, 37992, 38072, 38117, 38403, 38477, 38865, 38885, 39025, 39043, 39049, 39116, 39125, 39163, 39183, 39208, 39228, 39250, 39384, 39565, 39614, 40062);
|
| 1 |
SELECT * FROM wp_posts WHERE ID = 25776 LIMIT 1 |
| 1 |
SELECT p.*, pm.meta_value as parent_mission_id
FROM wp_posts p
INNER JOIN wp_postmeta pm
ON p.ID = pm.post_id
WHERE p.post_type = "mission"
AND pm.meta_key = "parent"
AND pm.meta_value IN (140343);
|
| 1 |
SELECT 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 = "parent"
AND pm.meta_value IN (38980, 37455, 35734);
|
| 1 |
SELECT 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 = "parent"
AND pm.meta_value IN (36060, 36073, 36087, 36155, 36186, 36212, 36288, 36292, 36300, 36351, 36413, 36436, 36482, 36527, 36691, 36795, 36883, 36893, 36897, 36920, 37024, 37263, 37333, 37383, 37521, 37529, 37783, 37873, 37887, 37934, 37936, 37992, 38072, 38117, 38403, 38477, 38865, 38885, 39025, 39043, 39049, 39116, 39125, 39163, 39183, 39208, 39228, 39250, 39384, 39565, 39614, 40062);
|
| 1 |
SELECT 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 = "parent"
AND pm.meta_value IN (140343);
|
| 1 |
SELECT pm.meta_value as mission_id, count(*) as total
FROM wp_posts p
INNER JOIN wp_postmeta pm
ON p.ID = pm.post_id
WHERE p.post_type = "story"
AND pm.meta_key = "mission"
AND pm.meta_value IN (38980, 37455, 35734, 36060, 36073, 36087, 36155, 36186, 36212, 36288, 36292, 36300, 36351, 36413, 36436, 36482, 36527, 36691, 36795, 36883, 36893, 36897, 36920, 37024, 37263, 37333, 37383, 37521, 37529, 37783, 37873, 37887, 37934, 37936, 37992, 38072, 38117, 38403, 38477, 38865, 38885, 39025, 39043, 39049, 39116, 39125, 39163, 39183, 39208, 39228, 39250, 39384, 39565, 39614, 40062, 140343)
GROUP BY pm.meta_value
|
| 1 |
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35706) ORDER BY meta_id ASC |
| 1 |
SELECT * FROM wp_posts WHERE ID = 13085 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 49761 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 16756 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 24691 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 94767 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 86412 LIMIT 1 |
| 1 |
SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1 |
Bravo Fleet
