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=722 AND AG.Visible=1 AND AG.Resigned=0 ORDER BY AG.Date, AG.Premier DESC, P.SCAName

The stylization of members of this order is Bearers of the Baron’s Keystone.

Notes on this order:

Sort: date | alpha

Warning: Invalid argument supplied for foreach() in /u3/wimble/public_html/by_single_award.php on line 57