you are not logged in | sign in
Outlands College of Heralds - Office of the Wimble Herald
SELECT AG.AwardsGivenID, AG.Date, DATE_FORMAT(AG.Date, '%Y-%m-%d') AS NiceDate, P.PersonID as PersonID, P.SCAName as SCAName, AG.Premier, AG.Reason FROM wAwardsGiven AG INNER JOIN wPeople P ON AG.PersonID = P.PersonID WHERE AG.AwardID=512 AND AG.Visible=1 AND AG.Resigned=0 ORDER BY AG.Date, AG.Premier DESC, P.SCAName
Treasured Jewels of Dragonsspine (CTJD)

The stylization of members of this order is Companion of the Treasured Jewels.

Notes on this order:

Sort: date | alpha

Alexandria Morgan (premier) (Sapphire - Rapier) 2009-07-25
Cainnleach Uiseir of Glendalough (premier) (Ruby - A&S) 2009-07-25
Haroun ibn al-Dhi'b al Abyadh (premier) (Emerald - Heavy Fighting) 2009-07-25
Knut Eldfimr (premier) (Amethyst - Service) 2009-07-25
Lêofsige Õ Caoimh (premier) (Amber - Archery) 2009-07-25
Albert von Dreckenveldt (Emerald - Heavy Fighting) 2009-09-26
Alaric Dimitrievich Razvedchikov (Amethyst - Service) 2010-07-30
Thorsteinn Vandringsmann (Amethyst - Service) 2012-02-04
Zafirah al-`Aliyyah (Amethyst - Service) 2012-08-31
Alwyn of Kittisford (Ruby - A&S) 2013-02-02
Lothar vom Bergenwald (Emerald - Heavy Fighting) 2013-06-08
Alikina filia Elpin (Ruby - A&S) 2013-11-16
Kiara Loftus (Amethyst - Service) 2013-11-16
Raisa Zaplatskaya (Amethyst - Service) 2014-02-01
Antoine de Vallier (Sapphire-Rapier) 2015-03-07
Lydia of the Pines (Amethyst-Service) 2015-03-07
Eórann O'Connor (Amber - Archery) 2015-04-04
Selene of the Sky (Amethyst for Service) 2016-01-30
Bronwen of Hindscroft (Ruby - A&S) 2017-01-28
Raisa Zaplatskaya (Amber - Archery) 2017-06-10
Séamus MacRae (Sapphire - Rapier) 2017-06-10
Angel d\'Auvergne (Ruby - A&S) 2017-12-02
Lêofsige Õ Caoimh (Amethyst - Service) 2018-10-27