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

Check out our latest Fleet Action!

Learn More
 

TF17: Stormbreaker – Garbled Data

Description

Several colonies near the Paulson Nebula are in need of assistance and it’s Starfleet’s duty to come to their aid. Unfortunately communications in the area are badly garbled and we need to sort out the information regarding a handful of colonies to make sure the correct resources are made available.

Sort through the garbled data below to figure out the distance from the nebula, population and primary species for each colony world so that resources and ships can be allocated appropriately.

1. Of the colony with 200k population and Ju’van, one is 5ly and the other is 4ly from the Paulson Nebula.
2. Of Ju’van and the colony with 500k population, one is Romulan and the other is 3ly from the nebula.
3. Of Lindal and the Human colony, one is 2ly from the nebula and the other has 200k population.
4. Boltu is not 5ly from the nebula.
5. The Tellarite colony is 2ly closer then Rastok II.
6. Gran is the colony with a population of 500k.
7. Boltu, the Bolian colony and the colony with 500k population are three different colonies.
8. The 300k population colony is closer to the nebula then Gran.
9. The 400k population colony, the colony 1ly from the nebula and Ju’van are three different colonies.

TF17 Stormbreaker logic puzzle grid

Criteria

  • Submissions must include colony, population, primary species and distance from the Paulson Nebula. 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
Liam Dahlgren (#669)

Rastok II | 5 LY | 200K | Human
Lindal | 2 LY | 400K | Bolian
Gran | 3 LY | 500K | Tellarite
Boltu | 1 LY | 300K | Vulcan
Ju'van | 4 LY | 100K | Romulan

 2022-02-09 21:48:41
R’Tor (#2309)

Boltu - Telleriete colony with a population of 300k is 1 ly from the Nebula

Lindal - Bolian colony with a population of 400k is 2ly from the Nebula

Gran - Vulcan colony with a population of 500k is 3ly from the Nebula.

Rastok II - Human colony with a population of 200k is 4ly from the Nebula

Ju’van, - Romulan colony with a population of 100k is 5ly from Nebula

2022-02-07 03:13:24
Alexander Beckett (#1036)

After much, much sobbing:

Rastok II: 5 LY, Human, 200k
Lindal: 2LY, Bolian, 400k
Gran: 3LY, Tellarite, 500k
Boltu: 1LY, Vulcan, 300k
Ju'van, 4LY, Romulan, 100k

 2022-02-06 12:20:09
Struan MacLeod (#2197)

User: bri.whyte (2197)
TF: 93

Colony Pop Species Distance
-------- ------ -------- ---------
RastokII 200k Human 5ly
Ju’van 100k Romulan 4ly
Gran 500k Tellarite 3ly
Lindal 400k Bolian 2ly
Boltu 300k Vulcan 1ly

 2022-02-06 00:14:43

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.37 seconds

Total SQL Queries: 75

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 = '669' ) ) 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 = '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
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 = '47201' ) ) ) 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 = '2197' ) ) 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 = '47201' AND wp_posts.post_type = 'competition' ORDER BY wp_posts.post_date DESC
1 SELECT * FROM wp_posts WHERE ID = 140308 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 = '669' ) ) 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 (49761) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 49761 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (18572) ORDER BY meta_id ASC
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 = 49387 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141640) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141640 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (141639) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 141639 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140308) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2309' LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16756) ORDER BY meta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (140618,140922) 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 = 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 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 user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2309) ORDER BY umeta_id 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (42099) 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 = '2309' ) ) 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 = 42099 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (42101) 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 = '2309' ) ) 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.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 (18806) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 16756 LIMIT 1
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_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.* 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 = '47201' ) ) 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 post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (47815,47701,47679,47636) 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 (22416) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 27493 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 = 141625 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141627 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141416 LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 141414 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 = 141628 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 (47201) ORDER BY meta_id ASC
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (669) ORDER BY umeta_id ASC
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (34710) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 34710 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 = '2197' ) ) 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 (34700) ORDER BY meta_id ASC
1 SELECT * FROM wp_posts WHERE ID = 34700 LIMIT 1
1 SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (28309) ORDER BY meta_id ASC
1 SELECT * FROM wp_users WHERE ID = '669' LIMIT 1
1 SELECT * FROM wp_posts WHERE ID = 57386 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 * FROM wp_users WHERE ID = '1036' LIMIT 1
1 SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2197) ORDER BY umeta_id ASC
1 SELECT * FROM wp_users WHERE ID = '2197' 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 = 47201;
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 = 12371 LIMIT 1