DEV BUILD - NOT FOR PUBLIC USE
 
FrameProfile Photo
Lieutenant Junior Grade
James Miller

Reserves, Fourth Fleet Reserves

Statistics
Bravo Fleet Join Date
19 October 2022

Last Login
1 October 2024

Last Promotion
3 August 2024
Word Count
11,378
Competitions
11 submissions
Contact Information
Sign in to view this information.
Gaming Accounts
Sign in to view this information.
Badges
New Member Program Badge
Character Creation Program Badge
4x Labyrinth Challenge Coin
Ribbons
8x Duty Ribbon
47x Service Ribbon
4x Campaign Ribbon (Legacy)
Medals
Medal of Achievement

Load Time: 1.18 seconds

Total SQL Queries: 98

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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16139) 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 * FROM wp_posts WHERE ID = 16135 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19339) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 19339 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16137) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 16137 LIMIT 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 * FROM wp_posts WHERE ID = 16139 LIMIT 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 (96965) ORDER BY meta_id ASC
1 SELECT meta_value FROM wp_postmeta WHERE post_id = 96965 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 96965 AND meta_key LIKE "manifest_%_character" AND meta_value = '125590' )
1 SELECT * FROM wp_posts WHERE ID = 96965 LIMIT 1
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 (34941) ORDER BY meta_id ASC
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 = '64893' )
1 SELECT * FROM wp_posts WHERE ID = 34941 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (86162) 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 = 2575
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19340) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16133) 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_date >= '2024-06-02 00:00:00' ) AND wp_posts.post_author IN (2575) 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 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 (2575) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"65217\"%' ) ) 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 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 = 16756 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 49761 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 IN ('fleet_action','fiction_campaign') ) ) 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 (163230,163266) 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 (163230, 163266) ORDER BY t.name ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (163230,163266)
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.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 (2575) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '65217' ) ) 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 (2575) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '124752' ) ) 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 = 19341 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 (2575) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"124752\"%' ) ) 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 = 11 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 14272 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 9211 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 7 LIMIT 1
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 (16131) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 16131 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19341) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (134528,134253,133700,133325,132670,132655,132583,131548,131197,130626,128681) ORDER BY meta_id ASC
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 = 2575
1 SELECT FOUND_ROWS()
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (124752,65217) 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 = 'defendant' AND wp_postmeta.meta_value = '2575' ) ) AND wp_posts.post_type = 'trials' 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 = 'letter_reprimand_offender' AND wp_postmeta.meta_value = '2575' ) ) AND wp_posts.post_type = 'letter_of_reprimand' 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 = 'user' AND wp_postmeta.meta_value = '2575' ) ) 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 (128862,65089,64979,64925,64913,64879) 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 = '2575' ) ) 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 = 30168 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 22420 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 (2575) 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 (2575) AND wp_posts.post_type = 'command_unit' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_title ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (2575) 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 (140267,124617,69366) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (133673,125590,125589,79301,65282,65258,65257,65256,64893,64878) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (2575) 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 (64880) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (64880)
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 = '2575' ) ) 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 user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2575) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2575' LIMIT 1
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 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 wp_posts.* FROM wp_posts WHERE ID IN (14888,14883,14718,14629,14546,14537,14468,14334,14415,14318,14297,14275)
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 = '2575' ) ) 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 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 = 2575 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 = 2575 AND p_pma.meta_key = "number" ) counter ON counter.id = main.id ORDER BY main.post_date DESC;
1 SELECT count(id) as count FROM wp_posts WHERE post_type = "competition" AND post_status IN ("pending","publish") AND post_author = 2575
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 = 2575 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 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 = 2575
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 * FROM wp_posts WHERE ID = 16141 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (127489,125788,125787,65311,64895) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (65311,64895,125787,0,125788,127489) AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status = 'inherit')) 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 = 2575 AND pm.meta_key = "photo"
1 SELECT * FROM wp_posts WHERE ID = 86162 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48918, 48919, 48920, 48930, 48931, 48932, 48934, 48935, 48936, 48937, 48975, 67072, 67073, 67074, 85804) ORDER BY meta_id ASC
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 = 2575 AND approver_user_id IS NOT NULL ORDER BY `date` DESC
1 SELECT * FROM `wp_posts` WHERE post_parent IN (48933, 48974, 48929, 48917, 67071)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (67071,48974,48933,48929,48917) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (48933,48974,48929,48917,67071) 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 = 2575 AND pm.meta_key = "rank"
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 (1937, 19287, 128063, 43812, 43810, 19278, 19281) AND wp_postmeta.meta_key = "award_category";
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (29321, 19283, 29111, 29114, 19293, 29117, 43811, 43813, 128065) ORDER BY meta_id ASC
1 SELECT * FROM `wp_posts` WHERE post_parent IN (1937, 19287, 128063, 43812, 43810, 19278, 19281)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (128063,43812,43810,19287,19281,19278,1937) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (1937,19287,128063,43812,43810,19278,19281) 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 (1937, 19287, 128063, 43812, 43810, 19278, 19281) AND wp_postmeta.meta_key = "award_type";
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1