DEV BUILD (branch: master) - NOT FOR PUBLIC USE
 

Check out our latest Fleet Action!

 
Statistics
Bravo Fleet Join Date
4 January 2003

Last Login
7 May 2025

Last Promotion
7 April 2020
Word Count
372,622
Competitions
6 organized
63 submissions

Announcements
7
Contact Information
Sign in to view this information.
Mentorships
This user has no mentors or students.
Gaming Accounts
Sign in to view this information.
Badges
Raptor’s Wing Challenge Coin
Echoes of the Tkon Challenge Coin
New Member Program Badge
Character Creation Program Badge
Fiction Writing Program Badge
17x The Lost Fleet Challenge Coin
41x We Are The Borg Challenge Coin
3x Labyrinth Challenge Coin
Ribbons
15x Duty Ribbon
1500x Service Ribbon
125x Joint Action Ribbon
152x Campaign Ribbon (Legacy)
61x Combat Action Ribbon
Legacy Ribbon
Medals
Zephram Cochrane Medal of Excellence
Christopher Pike Medal of Valor
Rachel Garrett Order of Heroism
Jonathan Archer Order of Merit
Legion of Merit
Star Cross
Meritorious Service Cross
Medal of Achievement
11x Starfleet Gold Star
7x Starfleet Silver Star
8x Starfleet Bronze Star
2x Action Medal with Planet Cluster
2x Starfleet Medal of Commendation

Load Time: 1.87 seconds

Total SQL Queries: 140

2 SELECT DISTINCT meta_value FROM `wp_postmeta` WHERE post_id = 35402 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 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 (1) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"121708\"%' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '141153' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"132531\"%' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '132531' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"124230\"%' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '124230' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"112724\"%' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '121708' ) ) 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 = 140143 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 (1) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '112724' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"95520\"%' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '95520' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"78660\"%' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"78659\"%' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"141153\"%' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '141161' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'parent' AND wp_postmeta.meta_value = '141120' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"141161\"%' ) ) 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 = 76131 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 11 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 18472 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 30168 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 51344 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 51302 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 83763 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 1874 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 53727 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 16501 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 63688 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 76350 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 76231 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 (1) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"78658\"%' ) ) 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 (16365) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 16365 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 111 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 * FROM wp_posts WHERE ID = 86412 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 13085 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (122202) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (122202)
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 (140618,140922) 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 (140618, 140922) ORDER BY t.name ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (140922,140618)
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 * FROM wp_posts WHERE ID = 82907 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (95492) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 26356 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (83763) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1874) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 264 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 75813 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (264) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (76350) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 75817 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (63688) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 63684 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (76231) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (76131) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 53685 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 53688 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140143) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 140125 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16501) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 261 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (53727) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 95492 LIMIT 1
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 = 35705 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 25122 LIMIT 1
1 SELECT * FROM `wp_posts` WHERE post_parent IN (33366, 19626, 60014, 43812, 43810, 19287, 128063, 13996, 33364, 19296, 14135, 14133, 14131, 95606, 13984, 19298, 83256, 19349, 1937, 40126, 19894, 19302, 21192, 87926, 19281, 19284, 19278)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (128063,95606,87926,83256,60014,43812,43810,40126,33366,33364,21192,19894,19626,19349,19302,19298,19296,19287,19284,19281,19278,14135,14133,14131,13996,13984,1937) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (33366,19626,60014,43812,43810,19287,128063,13996,33364,19296,14135,14133,14131,95606,13984,19298,83256,19349,1937,40126,19894,19302,21192,87926,19281,19284,19278) AND wp_posts.post_type = 'award' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_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 (33366, 19626, 60014, 43812, 43810, 19287, 128063, 13996, 33364, 19296, 14135, 14133, 14131, 95606, 13984, 19298, 83256, 19349, 1937, 40126, 19894, 19302, 21192, 87926, 19281, 19284, 19278) AND wp_postmeta.meta_key = "award_type";
1 SELECT id, user_id, award_id, post_id, game_id, ribbon_count, word_count, approver_user_id, date, description FROM bfms_ribbons WHERE user_id = 1 AND approver_user_id IS NOT NULL ORDER BY `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 = 1 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 = 1 AND p_pma.meta_key = "number" ) counter ON counter.id = main.id ORDER BY main.post_date DESC;
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (83696,53474) 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 = '1' ) ) 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 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 = '1' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (35402) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (35402)
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 = '1' ) ) 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 (17777) 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 = '1' ) ) 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 = 36215 LIMIT 1
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 (33366, 19626, 60014, 43812, 43810, 19287, 128063, 13996, 33364, 19296, 14135, 14133, 14131, 95606, 13984, 19298, 83256, 19349, 1937, 40126, 19894, 19302, 21192, 87926, 19281, 19284, 19278) AND wp_postmeta.meta_key = "award_category";
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (18311)
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 = '1' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) 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 = '1' ) ) 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 (18311) 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 (1) 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 WHERE 1=1 AND wp_posts.post_author IN (1) AND wp_posts.post_type = 'character' 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 (140894,140216,140217,138280,137935,136195,136151,136130,136128,136123,136124,135973,135949,135947,135945,135943,135941,135939,135922,135786,135770,135768,135766,135765,135763,135623,135620,135397,135498,135472,135464,135462,135459,135457,135454,135452,135402,135398,135393,135391,135389,135387,135385,135354,135352,135349,135347,135345,135342,135340,135338,135335,135030,134839,134837,134833,134826,134821,134816,134814,134809,134807,134805,134803,132627,129729,125962,125714,125709,125704,125321,125222,124314,122909,122120,122116,121929,121723,103387,98042,97556,95441,94854,94767,92817,91379,91374,91373,87749,86591,83697,82800,82799,82314,79710,78734,78732,77980,77981,77976,76895,76892,76882,29336,12738,12201,10120,10118,3790,2899,2897,272,255,69,4368) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (1) AND wp_posts.post_type = 'command' 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 (141161,141153,132531,124230,121708,112724,95520,78660,78659,78658,35496) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (1) 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 (141120) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (29321, 29320, 20593, 29319, 16731, 29152, 29154, 15837, 29153, 19283, 29111, 29114, 29116, 87924, 87925, 19293, 29117, 20607, 29316, 29315, 20606, 29314, 20608, 29313, 29137, 29124, 40112, 21193, 21831, 21832, 33365, 34942, 33367, 34943, 40127, 43811, 43813, 60015, 83257, 87927, 95607, 128065) ORDER BY meta_id ASC
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 = 1 AND pm.meta_key = "rank"
1 SELECT FOUND_ROWS()
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141631) ORDER BY meta_id ASC
1 SELECT count(id) as count FROM wp_posts WHERE post_type = "group_news" AND post_status = "publish" AND post_author = 1
1 SELECT count(id) as count FROM wp_posts WHERE post_type = "competition_sub" AND post_status IN ("pending","publish") AND post_author = 1
1 SELECT count(id) as count FROM wp_posts WHERE post_type = "competition" AND post_status IN ("pending","publish") AND post_author = 1
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 = 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (76594,51368,51367,35407,34843,34821,34819,34817,34811,34810) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (34811,51367,51368,34810,34843,76594,34821,35407,34819,34817) AND wp_posts.post_type = 'staff_positions' AND ((wp_posts.post_status = 'publish')) 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 (1) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '35496' ) ) 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 (1) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"35496\"%' ) ) 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 (18503) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 18503 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16161) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 16161 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141632) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141632 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141740 LIMIT 1
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (48891,48913,48917,48925,3201,48946,48909,21718,48933,48929,48921,58875,48901,48893,48905,21733) AND wp_posts.post_type = 'rank' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC
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 = 1 AND pm.meta_key = "photo"
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (58875,48946,48933,48929,48925,48921,48917,48913,48909,48905,48901,48893,48891,21733,21718,3201) ORDER BY meta_id ASC
1 SELECT * FROM `wp_posts` WHERE post_parent IN (48891, 48913, 48917, 48925, 3201, 48946, 48909, 21718, 48933, 48929, 48921, 58875, 48901, 48893, 48905, 21733)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4390, 4393, 4394, 4395, 4396, 4397, 21702, 21703, 21722, 21723, 21724, 49007, 49008, 49009, 21734, 21735, 21736, 48977, 48978, 48979, 48980, 48892, 48894, 48895, 48896, 48902, 48903, 48904, 48906, 48907, 48908, 48910, 48911, 48912, 48914, 48915, 48916, 48918, 48919, 48920, 48922, 48923, 48924, 48926, 48927, 48928, 48930, 48931, 48932, 48934) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48935, 48936, 48937, 48947, 48948, 48949, 85819, 85820, 85821, 85822) 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 = 1 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 = 35706 LIMIT 1
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (77726,136171,84184,77225,84488,77367,4378,84566,77390,77202,12750,136044,133790,76894,76896,136041,78350,0,84153,84216,121727,84541,82803,82802,84104,86696,136012,93557,91376,91380,92821,94776,125201,135893,97733,121726,122119,135857,136099,122122,136119,134460,125333,125708,125711,125715,125963,135383,133996,136090) 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 = 141639 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (136171,136119,136099,136090,136044,136041,136012,135893,135857,135383,134460,133996,133790,125963,125715,125711,125708,125333,125201,122122,122119,121727,121726,97733,94776,93557,92821,91380,91376,86696,84566,84541,84488,84216,84184,84153,84104,82803,82802,78350,77726,77390,77367,77225,77202,76896,76894,12750,4378) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (136086,136085,136076,134815,134820,134824,134832,134834,134838,134840,135031,135336,136121,135341,135901,135346,135348,135351,135353,135355,135386,135388,135390,135392,135394,135401,135405,135453,135455,135458,135461,135463,135465,135474,135499,135619,135622,135624,135764,136003,135767,135769,135771,135787,136001,135940,135942,140287,135946,135948) 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 (140287,136121,136086,136085,136076,136003,136001,135948,135946,135942,135940,135901,135787,135771,135769,135767,135764,135624,135622,135619,135499,135474,135465,135463,135461,135458,135455,135453,135405,135401,135394,135392,135390,135388,135386,135355,135353,135351,135348,135346,135341,135336,135031,134840,134838,134834,134832,134824,134820,134815) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (135956,135987,136125,136126,136129,136135,136152,136196,138284,140218,140289,140895) 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 (140895,140289,140218,138284,136196,136152,136135,136129,136126,136125,135987,135956) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141631 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1