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

Test Yourselves – new competitions!

September 1, 2020

We’re in a golden age of competitions right now. While the Holodeck continues to spoil us with the As Time Goes By event, we’re also bringing you two pretty dang fiendish quizzes from one of our very own. They’re short and sweet and fun, the perfect thing to tackle over your morning coffee.

I myself was pretty challenged when vetting these; if you want to get everything right, I’m sure you can take your time. Check Google. Check Memory Alpha. Getting them right is one thing. But if you want to win, you’re going to have to get them right fastest.

First, we have the simple Timeline quiz, chock-full of events from the 2360s to 2399, both in Trek canon and BF lore. Get the exact year right!

Second, How Well Do You Know Your Star Trek Characters? Identify and answer questions about a series of images of Trek characters, from the beloved to the seriously obscure. Yet again, don’t just be right: be right first.

May the odds be ever in your favour!

Load Time: 0.47 seconds

Total SQL Queries: 37

1 SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = 'test-yourselves-new-competitions' AND wp_posts.post_type = 'group_news' ORDER BY wp_posts.post_date DESC
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 = 147861 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 158922 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158922) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 158923 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (158923) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 49387 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34812) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16756) 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 (159903,159902)
1 SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('group_news_category') AND tr.object_id IN (159902, 159903) ORDER BY t.name ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (159902,159903) ORDER BY meta_id ASC
1 SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'event_status' AND wp_postmeta.meta_value = 'In Progress' ) AND ( mt1.meta_key = 'event_type' AND mt1.meta_value = 'fleet_action' ) ) AND wp_posts.post_type = 'events' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title DESC LIMIT 0, 1
1 SELECT * FROM wp_posts WHERE ID = 136019 LIMIT 1
1 SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('donate') AND post_type IN ('page','attachment')
1 SELECT * FROM wp_posts WHERE ID = 147863 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18806) 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 (26251) ORDER BY t.name ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (20760) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (26251) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '1036' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1036) ORDER BY umeta_id ASC
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'promoted_user' AND wp_postmeta.meta_value = '1036' ) ) AND wp_posts.post_type = 'user_rank_assignment' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (69176,39168,19422,19023) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 20760 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 16756 LIMIT 1
1 SELECT wp_posts.* FROM wp_posts WHERE ID IN (18806)
1 SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'user' AND wp_postmeta.meta_value = '1036' ) ) AND wp_posts.post_type = 'staff_record' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34847) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 34812 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 34844 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 34813 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 34819 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 * FROM wp_posts WHERE ID = 12371 LIMIT 1