Last Login
Last Promotion
13 August 2023
Word Count
23,455
Competitions
Load Time: 0.89 seconds
Total SQL Queries: 115
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 (16141) 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 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 = 16139 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18513) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 18513 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 16141 LIMIT 1 |
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 (18512) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 18512 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16143) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 16143 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18511) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 18511 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16145) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 16145 LIMIT 1 |
1 | SELECT meta_value FROM wp_postmeta WHERE post_id = 86713 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 86713 AND meta_key LIKE "manifest_%_character" AND meta_value = '51828' ) |
1 | SELECT meta_value FROM wp_postmeta WHERE post_id = 59492 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 59492 AND meta_key LIKE "manifest_%_character" AND meta_value = '64355' ) |
1 | SELECT meta_value FROM wp_postmeta WHERE post_id = 86713 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 86713 AND meta_key LIKE "manifest_%_character" AND meta_value = '51826' ) |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (59411) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16135) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19340) ORDER BY meta_id ASC |
1 | SELECT meta_value FROM wp_postmeta WHERE post_id = 59492 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 59492 AND meta_key LIKE "manifest_%_character" AND meta_value = '62097' ) |
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 (2446) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"53683\"%' ) ) 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 = 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 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 (2446) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '53683' ) ) 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 (2446) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '59492' ) ) 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 = 16133 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 (2446) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"59492\"%' ) ) 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 (2446) AND ( ( wp_postmeta.meta_key = 'flag_command' AND wp_postmeta.meta_value = '86713' ) ) 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 (2446) AND ( ( wp_postmeta.meta_key = 'attached_commands' AND wp_postmeta.meta_value LIKE '%\"86713\"%' ) ) 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 = 9 LIMIT 1 |
1 | SELECT * FROM wp_posts WHERE ID = 23 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 * FROM wp_posts WHERE ID = 19341 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16133) ORDER BY meta_id ASC |
1 | SELECT meta_value FROM wp_postmeta WHERE post_id = 59411 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 59411 AND meta_key LIKE "manifest_%_character" AND meta_value = '59597' ) |
1 | SELECT meta_value FROM wp_postmeta WHERE post_id = 59492 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 59492 AND meta_key LIKE "manifest_%_character" AND meta_value = '62095' ) |
1 | SELECT FOUND_ROWS() |
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 (2446) AND ( ( wp_postmeta.meta_key = 'ship_primary' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'command' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 |
1 | SELECT wp_posts.ID, wp_postmeta.meta_value FROM wp_posts INNER JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID WHERE wp_posts.ID IN (83256, 60014, 19349, 19626, 19628, 19351, 19599, 13984, 19296, 57828, 14133, 14131, 14135, 21138, 43812, 43810, 19278, 19281) 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 = 2446 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 = 2446 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 = 2446 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 (103717) 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 = '2446' ) ) 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 = '2446' ) ) 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 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 = '2446' ) ) 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 (86660,59486,58658,53174,51823,51719,51458,51435,51310) 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 = '2446' ) ) 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.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (2446) 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 (83256,60014,57828,43812,43810,21138,19628,19626,19599,19351,19349,19296,19281,19278,14135,14133,14131,13984) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (86713,59492,53683) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (2446) 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 (67690,66757,66752,64355,62914,62095,61957,62097,60221,59597,57437,51824,51828,51826,51309) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_author IN (2446) 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 (51311) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE ID IN (51311) |
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 = '2446' ) ) 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 (2446) ORDER BY umeta_id ASC |
1 | SELECT * FROM wp_users WHERE ID = '2446' 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 WHERE 1=1 AND wp_posts.ID IN (83256,60014,19349,19626,19628,19351,19599,13984,19296,57828,14133,14131,14135,21138,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 * FROM `wp_posts` WHERE post_parent IN (83256, 60014, 19349, 19626, 19628, 19351, 19599, 13984, 19296, 57828, 14133, 14131, 14135, 21138, 43812, 43810, 19278, 19281) |
1 | SELECT meta_value FROM wp_postmeta WHERE post_id = 86713 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 86713 AND meta_key LIKE "manifest_%_character" AND meta_value = '67690' ) |
1 | SELECT * FROM wp_posts WHERE ID = 18510 LIMIT 1 |
1 | SELECT meta_value FROM wp_postmeta WHERE post_id = 86713 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 86713 AND meta_key LIKE "manifest_%_character" AND meta_value = '66752' ) |
1 | SELECT meta_value FROM wp_postmeta WHERE post_id = 59492 AND meta_key IN ( SELECT CONCAT(SUBSTRING(meta_key, 1, LENGTH(meta_key)-9), "position") as idx FROM `wp_postmeta` WHERE post_id = 59492 AND meta_key LIKE "manifest_%_character" AND meta_value = '66757' ) |
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 = '60221' ) |
1 | SELECT * FROM wp_posts WHERE ID = 34941 LIMIT 1 |
1 | SELECT count(id) as count FROM wp_posts WHERE post_type = "group_news" AND post_status = "publish" AND post_author = 2446 |
1 | SELECT count(id) as count FROM wp_posts WHERE post_type = "competition_sub" AND post_status IN ("pending","publish") AND post_author = 2446 |
1 | SELECT count(id) as count FROM wp_posts WHERE post_type = "competition" AND post_status IN ("pending","publish") AND post_author = 2446 |
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 = 2446 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18510) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16148) ORDER BY meta_id ASC |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (29320, 16731, 29152, 29154, 15837, 29153, 19283, 29111, 29114, 20607, 29316, 20608, 29313, 20376, 29312, 29139, 34532, 29137, 29136, 29115, 43811, 43813, 57829, 60015, 83257) ORDER BY meta_id ASC |
1 | SELECT * FROM wp_posts WHERE ID = 16148 LIMIT 1 |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (87029,67691,66763,66756,64356,62915,62334,62098,62096,60222,59599,57438,51855,51829,51414) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (51414,87029,51855,51829,57438,59599,60222,62334,62096,62098,62915,64356,66756,66763,67691) 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 = 2446 AND pm.meta_key = "photo" |
1 | SELECT * FROM wp_posts WHERE ID = 59411 LIMIT 1 |
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 = 2446 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (48914, 48915, 48916, 48918, 48919, 48920, 48922, 48923, 48924, 48926, 48927, 48928, 48930, 48931, 48932, 85810, 49082, 49083, 49084) ORDER BY meta_id ASC |
1 | SELECT * FROM `wp_posts` WHERE post_parent IN (48925, 48913, 48929, 48970, 48917, 48921, 49080) |
1 | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (49080,48970,48929,48925,48921,48917,48913) ORDER BY meta_id ASC |
1 | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (48925,48913,48929,48970,48917,48921,49080) 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 = 2446 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 (83256, 60014, 19349, 19626, 19628, 19351, 19599, 13984, 19296, 57828, 14133, 14131, 14135, 21138, 43812, 43810, 19278, 19281) AND wp_postmeta.meta_key = "award_category"; |
1 | SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1 |