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

Check out our latest Fleet Action!

Learn More
 

TF17 : The needs of the oh so many…

Description

Well after the last few months it’s high time the Federation went about hosting visitors from some of the great powers, to reassure them that all is well. Thanks to a computer mishap all our information about 4 visiting groups of diplomats has been scrambled! It’s an absolute mess! We could looking at diplomatic incidents with everyone if we don’t get this sorted!

We’re not sure how many staff each delegation is bringing, how many ambassadors in each group, or even which month they’ll be visiting in! We’ve got to get this sorted so we can make sure we know who’s visiting each month and how many staff to make sure we get room booking sorted and we don’t accidentally serve gagh to a Romulan, or tulaberries to a Tholian!

Luckily for us Starfleet officers are a pretty clever bunch and we’re pretty sure you’re up to the task of sorting out the details from our only confirmed facts about the soon to occur visits.

  1. The Dominion delegates are either the group with 3 ambassadors or 40 staff
  2. The delegates with 40 staff either has 4 ambassadors or represent the Tholians
  3. The delegates with 4 ambassadors visits 1 month after the the delegates with 30 staff
  4. The delegates with 20 staff visit 2 months after the Klingon visit
  5. Of the group with 4 ambassadors and the Dominion delegation, one visits in August and the other has 20 staff
  6. Of the Klingon delegates and the group with 40 staff, one has 2 ambassadors and the other visits in August

To help we’ve supplied a hand grid to assist.

Criteria

  • Submissions must include which species, how many ambassadors and how many staff are visiting each month. There are no duplicates.
  • Judging is done by correct entries and order of submission.
  • Entry may be done by text or by drawing on the supplied table.

Winners

Submissions

User Content Date Entry
Acker Kather (#763)

Capt Acker Kather, USS Ascension, TF93

I know these answers are wrong, but oh well

Tholians visit in June with 1 ambassador and 40 staff
Klingons visit in July with 2 ambassadors and 30 staff
Romulans visit in August with 4 ambassadors and 50 staff
Dominion visits in September with 3 ambassadors and 20 staff

 2021-10-15 17:53:20
Th'lora Vehl (#2240)

Entry for Treylana Hess/Th'lora Vehl

 2021-10-13 19:18:38
Sam Aubrey (#239)

The Tholians come in June with 1 ambassador and 50 staff.
The Klingons come in July with 2 ambassadors and 30 staff.
The Romulans come in August with 4 ambassadors and 40 staff.
The Dominion comes in September with 3 ambassadors and 20 staff.

 2021-10-13 15:54:38

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: 0.3 seconds

Total SQL Queries: 102

2 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 = '239' ) ) AND wp_posts.post_type = 'member' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC
2 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 = '40790' ) ) ) AND wp_posts.post_type = 'comp_sub_timer' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC
2 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 = '763' ) ) 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 wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '40790' AND wp_posts.post_type = 'competition' ORDER BY wp_posts.post_date DESC
1 SELECT * FROM wp_posts WHERE ID = 141824 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141838 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141836 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141834 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141832 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141830 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141828 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141826 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141822 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141840 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141820 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141801 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141799 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141797 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141794 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141791 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141740 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141631 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141806 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141808 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141842 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141842) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141812 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (41303) 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 = 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 = 41303 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141843 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (33287) 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 = '2240' ) ) 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 = 33287 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (33203) 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 = 'member_user' AND wp_postmeta.meta_value = '2240' ) ) 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 user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2240) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2240' LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (86415) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 86415 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141843) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141810 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141816 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141814 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141627 LIMIT 1
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 = 40790;
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (57386) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 57386 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (27493) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141628) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141628 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141627) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141414 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141416 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141625 LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '239' 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 = '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 * FROM wp_posts WHERE ID = 27493 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (22416) 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 = '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
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (40794) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (41357,41302,41291) 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 = 'competition' AND wp_postmeta.meta_value = '40790' ) ) 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 user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2121) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2121' LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (43296) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (239) ORDER BY umeta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (40790) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (6122) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141818 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 = '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 (86412) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 86412 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18640) 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 = '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
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (6972) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 6972 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 = '763' ) ) 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 = 6122 LIMIT 1
1 SELECT * FROM wp_users WHERE ID = '763' LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18745) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (2956) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 2956 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 = '239' ) ) 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 (2954) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 2954 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18443) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1759) ORDER BY umeta_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 (763) ORDER BY umeta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 12371 LIMIT 1