User:FltAdml. Wolf/Awards '07 Project - SQL File
Jump to navigation
Jump to search
- 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