DEV BUILD (branch: deploy) - NOT FOR PUBLIC USE
 
Statistics
Bravo Fleet Join Date
2 March 2002

Last Login
9 July 2025

Last Promotion
22 December 2022
Word Count
1,622,797
Competitions
64 organized
12 submissions

Timezone
GMT +01:00

Announcements
124
Contact Information
Sign in to view this information.
Gaming Accounts
Sign in to view this information.
Badges
3x Raptor’s Wing Challenge Coin
Archanis Campaign Badge
13x Echoes of the Tkon Challenge Coin
10x Sundered Wings Challenge Coin
10x The Lost Fleet Challenge Coin
7x We Are The Borg Challenge Coin
7x Labyrinth Challenge Coin
7x Nightfall Challenge Coin
Brick of Latinum
Ribbons
63x Duty Ribbon
6484x Service Ribbon
3x Legacy Ribbon
Medals
Zephram Cochrane Medal of Excellence
2x Christopher Pike Medal of Valor
Rachel Garrett Order of Heroism
Legion of Merit
Star for Distinguished Service
Meritorious Service Cross
5x Action Medal with Galaxy Cluster
3x Action Medal with Planet Cluster
Starfleet Medal of Commendation

Load Time: 3.47 seconds

Total SQL Queries: 194

2 SELECT DISTINCT meta_value FROM `wp_postmeta` WHERE post_id = 34847 AND meta_key LIKE "record_%_position";
1 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC LIMIT 0, 12
1 SELECT * FROM wp_posts WHERE ID = 264 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 (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"82965\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"82908\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '82908' ) ) 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 = 1827 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 (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"69223\"%' ) ) 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.* 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 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 = '142778' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16366) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'parent' AND wp_postmeta.meta_value = '142785' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT 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 '%\"89886\"%' ) ) 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.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'parent' AND wp_postmeta.meta_value = '142784' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (264) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (105433) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 105431 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1834) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 75816 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 * FROM wp_posts WHERE ID = 16776 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (76220) ORDER BY meta_id ASC
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '89886' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"89901\"%' ) ) 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 (105933) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 16514 LIMIT 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 = 16152 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16152) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 18508 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18508) 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 '%\"143519\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"140396\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"134340\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"131453\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"131452\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"105465\"%' ) ) 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 = 15029 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 (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"131451\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"120363\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '120363' ) ) 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 = 120209 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 (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"120216\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '120216' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"120111\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '120111' ) ) 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 = 75814 LIMIT 1
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 (16154) 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 '%\"68661\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '35706' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"131450\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '131450' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"83862\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '83862' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"68729\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '68729' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"68662\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '68662' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '68661' ) ) 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 = 10790 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 (1036) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"35274\"%' ) ) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '35274' ) ) 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 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 (159903,159902)
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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159902,159903) 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 * FROM wp_posts WHERE ID = 136019 LIMIT 1
1 SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('donate') AND post_type IN ('page','attachment')
1 SELECT 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 '%\"35706\"%' ) ) 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 (35705) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (72872) ORDER BY meta_id ASC
1 SELECT 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 (143492) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 53684 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (63690) 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 (1837) 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 (119) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (41678) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 41668 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 116 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 44483 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (82906) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 134 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (134) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (15029) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 111 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16514) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 120 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1827) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 102 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (120209) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 18507 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18506) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 16154 LIMIT 1
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (48905,487,0,71,48893,48913,48921,21569,48925,48917,1113,1118,1128,1138,1216,58875,1133,48946,433,48950,48929,1220,1230,48933,1156,48962,48909,6022,48897,823,8790) AND wp_posts.post_type = 'rank' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC
1 SELECT main.id, main.post_date, main.award_id, IF(number IS NULL OR number = "",1,number) as number FROM (SELECT p.id, p_pma.meta_value as award_id, p.post_date FROM `wp_posts` p INNER JOIN `wp_postmeta` p_pmu ON p.id = p_pmu.post_id INNER JOIN `wp_postmeta` p_pma ON p.id = p_pma.post_id WHERE p.post_type = "user_award" AND p.post_status = "publish" AND p_pmu.meta_key = "user" AND p_pmu.meta_value = 1036 AND p_pma.meta_key = "award" AND p_pma.meta_value NOT IN (19281, 19278, 87926, 19284) /* service, duty, combat action, and joint action ribbons */ ) main LEFT JOIN (SELECT p.id, p_pma.meta_value as number FROM `wp_posts` p INNER JOIN `wp_postmeta` p_pmu ON p.id = p_pmu.post_id INNER JOIN `wp_postmeta` p_pma ON p.id = p_pma.post_id WHERE p.post_type = "user_award" AND p.post_status = "publish" AND p_pmu.meta_key = "user" AND p_pmu.meta_value = 1036 AND p_pma.meta_key = "number" ) counter ON counter.id = main.id ORDER BY main.post_date DESC;
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 = 1036 AND approver_user_id IS NOT NULL ORDER BY `date` DESC
1 SELECT wp_posts.ID, wp_postmeta.meta_value FROM wp_posts INNER JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID WHERE wp_posts.ID IN (155399, 33366, 33364, 128063, 19294, 19302, 95606, 83256, 19626, 57828, 19630, 40126, 32673, 30804, 13996, 19349, 19894, 21192, 13984, 19281, 19278) AND wp_postmeta.meta_key = "award_type";
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (155399,33366,33364,128063,19294,19302,95606,83256,19626,57828,19630,40126,32673,30804,13996,19349,19894,21192,13984,19281,19278) AND wp_posts.post_type = 'award' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (155399,128063,95606,83256,57828,40126,33366,33364,32673,30804,21192,19894,19630,19626,19349,19302,19294,19281,19278,13996,13984) ORDER BY meta_id ASC
1 SELECT * FROM `wp_posts` WHERE post_parent IN (155399, 33366, 33364, 128063, 19294, 19302, 95606, 83256, 19626, 57828, 19630, 40126, 32673, 30804, 13996, 19349, 19894, 21192, 13984, 19281, 19278)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (29320, 20593, 29319, 19283, 29111, 29114, 29317, 20606, 29314, 20608, 29313, 29137, 29134, 29124, 40112, 21193, 21831, 21832, 30805, 32674, 40085, 40110, 33365, 34942, 33367, 34943, 40127, 57829, 83257, 95607, 128065, 155400) ORDER BY meta_id ASC
1 SELECT wp_posts.ID, wp_postmeta.meta_value FROM wp_posts INNER JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID WHERE wp_posts.ID IN (155399, 33366, 33364, 128063, 19294, 19302, 95606, 83256, 19626, 57828, 19630, 40126, 32673, 30804, 13996, 19349, 19894, 21192, 13984, 19281, 19278) AND wp_postmeta.meta_key = "award_category";
1 SELECT DISTINCT pm.meta_value as ID FROM `wp_posts` p INNER JOIN `wp_postmeta` pm ON pm.post_id = p.ID WHERE p.post_type = "character" AND p.post_author = 1036 AND pm.meta_key = "rank"
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (58875,48962,48950,48946,48933,48929,48925,48921,48917,48913,48909,48905,48897,48893,21569,8790,6022,1230,1220,1216,1156,1138,1133,1128,1118,1113,823,487,71) 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 = 'user' AND wp_postmeta.meta_value = '1036' ) ) AND wp_posts.post_type = 'reprimands' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT * FROM `wp_posts` WHERE post_parent IN (48905, 487, 71, 48893, 48913, 48921, 21569, 48925, 48917, 1113, 1118, 1128, 1138, 1216, 58875, 1133, 48946, 433, 48950, 48929, 1220, 1230, 48933, 1156, 48962, 48909, 6022, 48897, 823, 8790)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (72, 73, 74, 75, 49098, 49099, 49100, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 49113, 49114, 49115, 824, 1114, 1115, 1116, 1117, 1119, 1120, 1121, 1122, 1129, 1130, 1131, 1132, 1134, 1135, 1136, 1137, 1139, 1140, 1141, 1142, 1157, 1158) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1159, 1160, 1217, 1221, 1231, 6023, 21666, 21667, 21668, 48894, 48895, 48896, 48898, 48899, 48900, 48906, 48907, 48908, 48910, 48911, 48912, 48914, 48915, 48916, 48918, 48919, 48920, 48922, 48923, 48924, 48926, 48927, 48928, 48930, 48931, 48932, 48934, 48935, 48936, 48937, 48947, 48948, 48949, 85819, 85820, 85821, 85822, 48951, 48952, 48953) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (85815, 85816, 85817, 85818, 48963, 48964, 48965, 85811, 85812, 85813, 85814) ORDER BY meta_id ASC
1 SELECT character_position_set.character_post_id, character_position_set.command_post_id, position_pm.meta_value as position_name FROM ( SELECT character_p.ID as character_post_id, manifest_pm.post_id as command_post_id, CONCAT(SUBSTRING(manifest_pm.meta_key, 1, LENGTH(manifest_pm.meta_key)-9), "position") as meta_key FROM wp_posts AS character_p INNER JOIN wp_postmeta AS manifest_pm ON manifest_pm.meta_value = character_p.ID WHERE character_p.post_author = 1036 AND character_p.post_type = "character" AND manifest_pm.meta_key LIKE "manifest_%" AND manifest_pm.meta_key LIKE "manifest_%_character" ) character_position_set INNER JOIN wp_postmeta AS position_pm ON ( character_position_set.command_post_id = position_pm.post_id AND character_position_set.meta_key = position_pm.meta_key )
1 SELECT * FROM wp_posts WHERE ID = 34941 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 42258 LIMIT 1
1 SELECT DISTINCT pm.meta_value as ID FROM `wp_posts` p INNER JOIN `wp_postmeta` pm ON pm.post_id = p.ID WHERE p.post_type = "character" AND p.post_author = 1036 AND pm.meta_key = "photo"
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (93548,14317,13600,14313,49387,90580,142961,43759,91252,86472,103637,49252,49669,49823,59082,58844,58828,58829,26207,58832,27037,99284,49388,58826,58834,58833,58830,91359,134471,49389,36363,37188,50157,70244,38481,58837,48884,40628,50156,40632,41149,40636,58031,40640,41154,42487,0,43404,58840,58841) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status = 'inherit')) 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 = 'user' AND wp_postmeta.meta_value = '1036' ) ) AND wp_posts.post_type = 'transfer_request' 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 (34847) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (49622,50210,58843,50845,58835,51067,135038,62891,57965,58126,58024,58028,138412,58897,60469,66064,68820,131446,69056,69813,69815,74512,134397,84033,96024,91213,73813,69235,70263,70318,70356,102695,73759,74503,74505,74507,74514,74516,74518,74520,74648,76823,145115,87353,83574,84018,84916,123423,85003,87056) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status = 'inherit')) ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157156,149742,148933,143546,142384,142382,141846,140495,136963,135114,135003,134987,134569,134567,134439,134404,131573,131092,125739,125053,121978,120993,103700,100018,98656,92481,91355,90778,90776,90774,90772,90717,90006,90005,90004,89925,89890,89825,87061,87059,87057,87055,84949,84864,84815,84016,83573,83152,77688,76822,74646,74519,74517,74515,74513,74506,74504,74502,73758,73054,70355,70317,69254,69224,68949,68948,68946,68945,68943,68942,68941,68940,68939,68937,68761,66063,60449,58884,58713,57995,57990,57964,57650,57471,50841,50655,47151,46116,45909,43458,43456,43403,43339,42447,41153,40639,40637,40635,40633,40631,40629,40627,40625,38479,38086,37189,37186,36354,34324,34300,32909,32907,32905,32903,31092,30824,27036,25640,22167,21911,21909,21251,20930,19812,19807,19805,19802,19791,19781,19779,19777,19711,16756,12418) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (14888,14883,14718,14629,14546,14537,14468,14334,14415,14318,14297,14275)
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 ('category', 'post_tag', 'post_format') AND tr.object_id IN (14275, 14297, 14318, 14334, 14415, 14468, 14537, 14546, 14629, 14718, 14883, 14888) ORDER BY t.name ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (14275,14297,14318,14334,14415,14468,14537,14546,14629,14718,14883,14888) ORDER BY meta_id ASC
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 wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '1036' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (18806)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18806) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (1036) AND wp_posts.post_type = 'character' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (1036) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (34847)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (143519,140396,134340,131453,131452,131451,131450,120363,120216,120111,105465,89901,89886,83862,82965,82908,69223,68729,68662,68661,34911,35274,35706) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (1036) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_title ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142778,142785,142784,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 = '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 = 36215 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 25122 LIMIT 1
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'promoted_user' AND wp_postmeta.meta_value = '1036' ) ) AND wp_posts.post_type = 'user_rank_assignment' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (69176,39168,19422,19023) ORDER BY meta_id ASC
1 SELECT 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 = 'user' AND wp_postmeta.meta_value = '1036' ) ) AND wp_posts.post_type = 'staff_record' 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 (142961,134471,103637,99284,93548,91359,91252,90580,86472,70244,59082,58844,58841,58840,58837,58834,58833,58832,58830,58829,58828,58826,58031,50157,50156,49823,49669,49389,49388,49387,49252,48884,43759,43404,42487,41154,41149,40640,40636,40632,40628,38481,37188,36363,27037,26207,14317,14313,13600) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (145115,138412,135038,134397,131446,123423,102695,96024,91213,87353,87056,85003,84916,84033,84018,83574,76823,74648,74520,74518,74516,74514,74512,74507,74505,74503,73813,73759,70356,70318,70263,69815,69813,69235,69056,68820,66064,62891,60469,58897,58843,58835,58126,58028,58024,57965,51067,50845,50210,49622) ORDER BY meta_id ASC
1 SELECT FOUND_ROWS()
1 SELECT * FROM wp_posts WHERE ID = 63690 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 82906 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 1834 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 105933 LIMIT 1
1 SELECT meta_value FROM wp_postmeta WHERE post_id = 120363 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 120363 AND meta_key LIKE "manifest_%_character" AND meta_value = '68946' )
1 SELECT * FROM wp_posts WHERE ID = 16786 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 105433 LIMIT 1
1 SELECT meta_value FROM wp_postmeta WHERE post_id = 34941 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 34941 AND meta_key LIKE "manifest_%_character" AND meta_value = '46116' )
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34941) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 34940 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (42258) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 1837 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 143492 LIMIT 1
1 SELECT meta_value FROM wp_postmeta WHERE post_id = 34911 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 34911 AND meta_key LIKE "manifest_%_character" AND meta_value = '91355' )
1 SELECT meta_value FROM wp_postmeta WHERE post_id = 34911 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 34911 AND meta_key LIKE "manifest_%_character" AND meta_value = '40625' )
1 SELECT meta_value FROM wp_postmeta WHERE post_id = 82965 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 82965 AND meta_key LIKE "manifest_%_character" AND meta_value = '70355' )
1 SELECT meta_value FROM wp_postmeta WHERE post_id = 120363 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 120363 AND meta_key LIKE "manifest_%_character" AND meta_value = '68937' )
1 SELECT meta_value FROM wp_postmeta WHERE post_id = 35706 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 35706 AND meta_key LIKE "manifest_%_character" AND meta_value = '47151' )
1 SELECT * FROM wp_posts WHERE ID = 16156 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16156) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 18506 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 41678 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 16366 LIMIT 1
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (87058,87060,87062,89826,90830,89926,142459,90008,142460,90718,90773,90775,90777,90779,91356,145191,98657,100019,103701,120994,121979,126126,125742,131190,144057,144058,134660,148287,134661,134991,145822,135115,156893,140496,141847,142383,142385,143547,148934,149743,157157) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status = 'inherit')) ORDER BY wp_posts.post_date DESC
1 SELECT * FROM wp_posts WHERE ID = 18504 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157157,156893,149743,148934,148287,145822,145191,144058,144057,143547,142460,142459,142385,142383,141847,140496,135115,134991,134661,134660,131190,126126,125742,121979,120994,103701,100019,98657,91356,90830,90779,90777,90775,90773,90718,90008,89926,89826,87062,87060,87058) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 147863 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 147861 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 158922 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158922) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 158923 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158923) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 16159 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16159) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18504) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 4134 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 (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 wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (34812,34844,34813,34819) AND wp_posts.post_type = 'staff_positions' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34844,34819,34813,34812) ORDER BY meta_id ASC
1 SELECT COALESCE(SUM(word_count), 0) AS word_count FROM bfms_ribbons WHERE approver_user_id IS NOT NULL AND award_id = 19281 AND user_id = 1036
1 SELECT count(id) as count FROM wp_posts WHERE post_type = "competition" AND post_status IN ("pending","publish") AND post_author = 1036
1 SELECT count(id) as count FROM wp_posts WHERE post_type = "competition_sub" AND post_status IN ("pending","publish") AND post_date <= "2024-06-01" AND post_author = 1036
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_date >= '2024-06-02 00:00:00' ) AND wp_posts.post_author IN (1036) AND ( ( wp_postmeta.meta_key = 'prestige_entry_type' AND wp_postmeta.meta_value = 'credit_competition_participant_lump_sum' ) ) AND wp_posts.post_type = 'member_prestige' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT count(id) as count FROM wp_posts WHERE post_type = "group_news" AND post_status = "publish" AND post_author = 1036
1 SELECT * FROM wp_posts WHERE ID = 35705 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 76220 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1