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.
Status
As of November 4th, 11:15am, the GENERAL AWARDS just need to be CHECKED FOR ACCURACY. Please check what's below with what's on the Cleanup File link above to make sure everything is EXACTLY CORRECT. After that, we're done! --Wolf /talk page 14:22, 4 November 2008 (EST)
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