User:FltAdml. Wolf/Awards '07 Project - SQL File

• Working file found here: User:FltAdml. Wolf/Awards '07 Project - Cleanup file.
• View the sample for more help.

List of Awards Names

Duty Post Awards

• strange = First Officer: The Strange Medallion
• cochrane = Science: The Cochrane Award
• sextant = Helm: The Pilot's Sextant
• phoenix = Engineering: The Phoenix Award
• prantares = Medical: The Prantares Ribbon
• yar = Security: The Natasha Yar Pin
• voyager = Operations: The Voyager Medallion
• valiant = Counseling: The Order of the Valiant Heart
• sisko = Tactical: Captain Sisko Tactical Cross

General Awards

• barclay = The Barclay Bead
• bplot = B-Plot Award
• kalendra = The Kalendra Award
• merria = The Merria Medallion
• nebula = The Nebula Bar
• neelix = The Neelix Award
• purplestar = The Purple Star
• sarpeidon = Sarpeidon Award
• scotty = The Scotty Cross
• sheathed = The Sheathed Sword
• silver = The Silver Palm
• TOSMA1 = The Order of StarFleet Merit and Achievement First Class (TOSMA I)
• TOSMA2 = The Order of StarFleet Merit and Achievement Second Class (TOSMA II)
• xalor = The Xalor Clan Xifilis Award
• data = Data Artistic Award

The query

Format

[Award Code],[Rank Abbreviation w/period],[Character Name],[Ship],2007

Example

• General: barclay,Lt. Cmdr.,John Graves,USS Triumphant,2006
• Duty Post: sisko,Lt.,Rode Mitchell,Ops,2005

Post Duty Post Queries Below - DONE, and ONLINE!

PLEASE INSERT A SPACE AT THE BEGINNING OF EACH LINE

---

cochrane,Lt. Cmdr.,Stephen Carmody,USS Ursa Major,2007 
sextant,Ens., Alex Swift,USS Challenger,2007
phoenix,Lt. JG.,Seph 647,USS Constitution,2007 
prantares,Lt. Cmdr., Julia Harden,StarBase 118 Ops,2007
yar,Lt. JG.,Tal Tel-ar,USS Constitution,2007 
voyager,Lt. Cmdr.,Toni Turner,USS Challenger,2007 
valiant,Lt. Cmdr., Emirry MacGowan,USS Constitution,2007
sisko,Lt.,Rode Mitchell,Discovery-B,2007

---

Post General Awards Queries Below

PLEASE INSERT A SPACE AT THE BEGINNING OF EACH LINE

---

TOSMA1,Ens.,Emilio Aguinaldo,USS Challenger, 2007 
TOSMA1,Lt. JG.,Tal Tel-ar,USS Constitution,2007
TOSMA1,Ens.,Tabour Flux,USS Discovery,2007 
TOSMA1,Lt. Cmdr.,Sidney Riley,USS Independence,2007 
TOSMA1,Lt.,Ethan Brice,USS Ronin,2007 
TOSMA1,Lt. Cmdr.,Cura Stone,StarBase 118 Ops,2007 
TOSMA1,Lt. JG.,Will Carrington,USS Ursa Major,2007
TOSMA2,Lt. Cmdr.,Victoria Yladro,USS Constitution,2007
TOSMA2,Ens.,Grauro Zekyel/Syrak,USS Discovery,2007 
TOSMA2,Lt.,Allen Cruise,USS Independence,2007 
TOSMA2,Lt. JG.,Addison Parker,USS Ronin,2007 
TOSMA2,Ens.,Jarak,StarBase 118 Ops,2007 
TOSMA2,Lt. Cmdr.,Jophry Calhan,USS Ursa Major,2007 
barclay,Lt. Cmdr.,Danzia,USS Challenger,2007  
barclay,Lt.,Rode Mitchell,USS Discovery,2007  
barclay,Lt. JG.,Daniel Wood,USS Independence,2007  
barclay,Lt. JG.,William Rogers,USS Ronin,2007  
barclay,Lt.,Jacen Fanel,StarBase 118 Ops,2007  
barclay,Ens.,Robert “Do” Long,USS Ursa Major,2007
scotty,Lt. JG.,Ca-Re Dall,USS Challenger,2007 
scotty,Lt. JG.,Rho Kennedy Falcon,StarBase 118 Ops,2007 
purplestar,Lt. Cmdr.,Hugh Barnes,USS Challenger,2007
purplestar,Lt.,Quinn Reynolds,USS Independence,2007 
purplestar,Lt.,Jhen Thelev,USS Ronin,2007 
purplestar,Lt. Cmdr.,Tash Zubowskivich,StarBase 118 Ops,2007 
purplestar,Lt. Cmdr.,Stephen Carmody,USS Ursa Major,2007 
merria,Lt. Cmdr.,Toni Turner,USS Challenger,2007 
merria,Lt. Cmdr.,David Cody,USS Independence,2007  
merria,Lt. Cmdr.,Takashi Chen,USS Ursa Major,2007  
neelix,Cmdr.,Francis deMarc,USS Challenger,2007 
neelix,Ens.,Grauro Zekyel/Syrak,USS Discovery,2007  
neelix,Lt.,Jackford Kolk,USS Ronin,2007  
neelix,Lt. Cmdr.,T'Lea,StarBase 118 Ops,2007 
data,Lt. Cmdr.,Toni Turner,USS Challenger,2007 
silver,Lt. Cmdr.,Toni Turner, USS Challenger,2007 
silver,Lt.,Susan Banks,USS Ursa Major,2007 
silver,Lt.,Geeva Kalpana,StarBase 118 Ops,2007
xalor,Lt.,Jerry Reid,USS Challenger,2007 
xalor,Lt. JG.,Vojana Minerva Satscher,USS Independence,2007 
sheathed,Lt. JG.,Andrus Jaxx,USS Challenger,2007 
sheathed,Lt. Cmdr.,Julia Harden,StarBase 118 Ops,2007 
sheathed,Lt. Cmdr.,Danny Wilde,USS Ronin,2007 
sheathed,Lt.,Darius Clack,USS Ursa Major,2007 
kalendra,Cmdr.,Francis deMarc,USS Challenger,2007 
kalendra,Lt. Cmdr.,Benjamin Walker,USS Ronin,2007 
kalendra,Lt.,Geeva Kalpana,StarBase 118 Ops,2007 
bplot,Lt. Cmdr.,Heath West,USS Challenger,2007 
bplot,Lt.,Julio Vannini,USS Discovery,2007 
bplot,Lt.,Ronan Adair,USS Ronin,2007  
bplot,Lt. JG.,Delinda Sharee,StarBase 118 Ops,2007 
bplot,Lt.,Kel Mage,USS Ursa Major,2007  
bplot,Lt.,Galvin Prox,USS Ursa Major,2007 
nebula,Lt. Cmdr.,Heath West,USS Challenger,2007 
nebula,Lt. Cmdr.,Cara Maria,USS Ronin,2007 
nebula,Lt. Cmdr.,T'Lea,StarBase 118 Ops,2007 
nebula,Lt. Cmdr.,Sakorra Reed,USS Ursa Major,2007 
karagite,1st Lt.,Dade Adarnis,USS StarBase 118 Ops,2007 
sarpeidon,Lt. JG.,Seph 647,USS Constitution,2007 
sarpeidon,Ens.,Grauro Zekyel/Syrak,USS Discovery,2007 

---