DEV BUILD - NOT FOR PUBLIC USE
 

Check out our latest Campaign!

Learn More
 

New Frontiers Comment Race

Automatically Submitted

Description

We expect to see a lot of Stories come out of the New Frontiers campaign, and writers love nothing more than feedback. Writing a good, helpful, thoughtful Comment is its own skill, its own investment of time, and something on which the Intel Office has given guidance. Write as many Comments as you can on BFMS Stories posted under the Fleet-Wide New Frontiers Mission.

These Comments must be Competition-Standard as laid out in the guide: a good paragraph of feedback, at least three sentences of some substance. Tell the writer what you’ve enjoyed about their work, and do it in some depth. Writing reviews is a skill, and practice makes perfect!

Criteria

  • The highest number of comments submitted throughout the campaign will win.
  • Each Comment must be Competition Standard, as per the Intel Office Guide; this will be determined by the organiser and substandard Comments will be disqualified from the count. Only one comment per Story will be counted.
  • All Comments will be automatically tallied at the end of the campaign. There is no need to individually submit to this competition. Only Comments on Stories in the New Frontiers Missions will be counted.
  • Ties will be broken by scoring your last comment out of 5 points, using the Intelligence Office guidance on Competition-Standard Comments.

Submissions

User
Michael Angelus (#3090)
Aloran (#2232)
Ishreth Dal (#2998)
Jason Devron (#2554)
Aelin Maori (#2980)
Varen Wyll (#2419)
Zachary Murphy (#2080)
Meila Tris (#2914)
Callen Varro (#2063)
Anna Caldwell (#1638)
Hrelle 'Runt' M'Hark (#3034)
Keziah Nazir (#18)
Alexander Dubois (#2671)
Trevenan Williams (#1295)
Henry Maxwell (#2223)
James Neidlinger (#1)
Cressida Brennan (#2765)
Tikva Theodoras (#2121)
Luke Duncan (#1759)
Ryoko Takato (#2545)
Edwin Wagner (#2468)
Ludvig Traven (#3114)
Khim Samnang (#2222)
Andreus Kohl (#2374)
George Kansas (#3166)
Traan (#3099)

Managed By the

Office of the Chief of Staff

This service is managed by the Office of the Chief of Staff. If you have questions about this service, please contact an office staff member.

Visit the office

Load Time: 1.08 seconds

Total SQL Queries: 215

1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '171694' AND wp_posts.post_type = 'competition' ORDER BY wp_posts.post_date DESC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (18746)
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (32342)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (32342) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2222' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2222) 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 = '2222' ) ) 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 (31013)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (31013) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '1295' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1295) 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 = '1295' ) ) 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 (18746) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2063) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '1638' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1638) 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 = '1638' ) ) 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 (18663)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18663) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 157115 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157115) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 32091 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (32091) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 149756 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (149756) 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 = 'member_user' AND wp_postmeta.meta_value = '2063' ) ) 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 * FROM wp_users WHERE ID = '2063' LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (60425) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3034) ORDER BY umeta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2080) 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 = '2080' ) ) 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 (19389)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (19389) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '18' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (18) 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 = '18' ) ) 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 (18322)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18322) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '3034' 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '3034' ) ) 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 (158360) ORDER BY meta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (144061)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (144061) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2419' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2419) 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 = '2419' ) ) 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 (49894)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (49894) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '3099' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3099) 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 = '3099' ) ) 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 (158360)
1 SELECT * FROM wp_posts WHERE ID = 60425 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 147488 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (75923) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (47905) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (86412) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 65950 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (65950) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 142217 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (142217) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 159576 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159576) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 83715 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (83715) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 47905 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 171790 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (26791) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (171790) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 158358 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158358) ORDER BY meta_id ASC
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 (173993,173660)
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 (173660, 173993) ORDER BY t.name ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (173660,173993) 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 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 wp_posts.* FROM wp_posts WHERE ID IN (170919)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (170919) ORDER BY meta_id ASC
1 SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('donate') AND post_type IN ('page','attachment')
1 SELECT * FROM wp_posts WHERE ID = 86412 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 26791 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (147488) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 144063 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 86925 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (86925) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 131107 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (131107) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 123469 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (123469) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 88217 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (88217) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 15964 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (15964) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (144063) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (136019) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 43418 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (43418) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 162366 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (162366) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 105004 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (105004) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 31802 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (31802) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 94767 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (94767) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 136019 LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '2080' LIMIT 1
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (75923)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (171694) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2980' LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '2998' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2998) 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 = '2998' ) ) 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 (139073)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (139073) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2554' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2554) 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 = '2554' ) ) 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 (60427)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (60427) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2980) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (18311)
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 = '2980' ) ) 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 (135874)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (135874) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2765' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2765) 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 = '2765' ) ) 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 (91261)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (91261) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '1759' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1759) 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 = '1759' ) ) 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_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 (18640) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 147861 LIMIT 1
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.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'competition' AND wp_postmeta.meta_value = '171694' ) ) AND wp_posts.post_type = 'competition_sub' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'pending')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT DISTINCT p.* FROM wp_posts p INNER JOIN wp_postmeta AS pm ON pm.post_id = p.ID WHERE p.post_type = "events" AND pm.meta_key LIKE "event_comps_%_competition" AND pm.meta_value = 171694;
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '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
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18806) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 16756 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_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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16756) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 147863 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 158922 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 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 = 49387 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (49387) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 170905 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 = 'parent' AND wp_postmeta.meta_value = '170905' ) ) AND ((wp_posts.post_type = 'mission' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (173967,173033,172977,172804,172616,172536,172482,172356,172245,172247,172094,171966,171923,171862,171859,171760,171759,171756,171312,171673,171615,171574,171572,171565,171398,171391,171332,171330,171269,171328,171327,171245,171261,170515,171219,171211,171206,171088,171007,168472,166042,163859,163325,84995) ORDER BY meta_id ASC
1 SELECT p.* FROM wp_posts p INNER JOIN wp_postmeta pm ON p.ID = pm.post_id WHERE p.post_type = "mission" AND p.post_status = "publish" AND pm.meta_key = "parent" AND pm.meta_value IN (173967, 173033, 172977, 172804, 172616, 172536, 172482, 172356, 172245, 172247, 172094, 171966, 171923, 171862, 171859, 171760, 171759, 171756, 171312, 171673, 171615, 171574, 171572, 171565, 171398, 171391, 171332, 171330, 171269, 171328, 171327, 171245, 171261, 170515, 171219, 171211, 171206, 171088, 171007, 168472, 166042, 163859, 163325, 84995);
1 SELECT story_comment_date_pm.post_id as story_id, story_comment_date_pm.meta_value as `timestamp`, story_comment_user_pm.meta_value as user_id, story_comment_text_pm.meta_value as `text` FROM wp_posts AS story_p INNER JOIN wp_postmeta AS story_mission_pm ON story_mission_pm.post_id = story_p.id AND story_mission_pm.meta_key = "mission" INNER JOIN wp_postmeta AS story_comment_date_pm ON story_comment_date_pm.post_id = story_p.ID AND story_comment_date_pm.meta_key LIKE "comments_%_comment_date" INNER JOIN wp_postmeta AS story_comment_user_pm ON story_comment_user_pm.post_id = story_p.ID AND story_comment_user_pm.meta_key = REPLACE(story_comment_date_pm.meta_key, '_date', '_user') INNER JOIN wp_postmeta AS story_comment_text_pm ON story_comment_text_pm.post_id = story_p.ID AND story_comment_text_pm.meta_key = REPLACE(story_comment_date_pm.meta_key, '_date', '_text') WHERE story_p.post_type = "story" AND story_mission_pm.meta_value IN (170905, 173967, 173033, 172977, 172804, 172616, 172536, 172482, 172356, 172245, 172247, 172094, 171966, 171923, 171862, 171859, 171760, 171759, 171756, 171312, 171673, 171615, 171574, 171572, 171565, 171398, 171391, 171332, 171330, 171269, 171328, 171327, 171245, 171261, 170515, 171219, 171211, 171206, 171088, 171007, 168472, 166042, 163859, 163325, 84995) AND story_comment_date_pm.meta_value BETWEEN 1761372722 AND 1766297522 AND story_comment_user_pm.meta_value != 1036
1 SELECT * FROM wp_users WHERE ID = '1' LIMIT 1
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (18640)
1 SELECT * FROM wp_users WHERE ID = '2468' 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2671' ) ) 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 (59351) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (32093) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '3114' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3114) 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 = '3114' ) ) 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 (159578)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159578) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2545' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2545) 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 = '2545' ) ) 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 (59351)
1 SELECT * FROM wp_users WHERE ID = '3166' 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_postmeta.meta_key = 'member_user' AND wp_postmeta.meta_value = '2232' ) ) 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 (3166) 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 = '3166' ) ) 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 (171792)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (171792) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2914' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2914) 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 = '2914' ) ) 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 (123471)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (123471) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2671' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2671) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (32093)
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2232) ORDER BY umeta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2468) 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 = '2374' ) ) 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.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 = '2468' ) ) 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 (52541)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (52541) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2121' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2121) 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 = '2121' ) ) 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 (22416)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (22416) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2374' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2374) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (47074)
1 SELECT * FROM wp_users WHERE ID = '2232' LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (47074) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '3090' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (3090) 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 = '3090' ) ) 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 (157117)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (157117) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2223' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2223) 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 = '2223' ) ) 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 (31032)
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (31032) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1