Previous page  The Kingdom of An Tir

Territorial Barons & Baronesses of An Tir

error: SELECT DISTINCT DATE(t1.`Started`) FROM antir2an_OP.`GRANTED_AWARDS` AS t1 WHERE t1.Demesne_ID =47 AND t1.Award_ID = 439 ORDER BY t1.`Started` Expression #1 of ORDER BY clause is not in SELECT list, references column 'antir2an_OP.t1.Started' which is not in SELECT list; this is incompatible with DISTINCT

Barons & Baronesses of Adiantum

Shire: established January 26 VIII/1974
Baronial status: approved by Board February 10 X/1976
Barony installed: March 27 X/1976

    error: SELECT DISTINCT DATE(t1.`Started`) FROM antir2an_OP.`GRANTED_AWARDS` AS t1 WHERE t1.Demesne_ID =10 AND t1.Award_ID = 439 ORDER BY t1.`Started` Expression #1 of ORDER BY clause is not in SELECT list, references column 'antir2an_OP.t1.Started' which is not in SELECT list; this is incompatible with DISTINCT

    Barons & Baronesses of Aquaterra

    Baronial status: September 1 XXXI/1996

      error: SELECT DISTINCT DATE(t1.`Started`) FROM antir2an_OP.`GRANTED_AWARDS` AS t1 WHERE t1.Demesne_ID =12 AND t1.Award_ID = 439 ORDER BY t1.`Started` Expression #1 of ORDER BY clause is not in SELECT list, references column 'antir2an_OP.t1.Started' which is not in SELECT list; this is incompatible with DISTINCT

      Barons & Baronesses of Blatha An Oir

        error: SELECT DISTINCT DATE(t1.`Started`) FROM antir2an_OP.`GRANTED_AWARDS` AS t1 WHERE t1.Demesne_ID =14 AND t1.Award_ID = 439 ORDER BY t1.`Started` Expression #1 of ORDER BY clause is not in SELECT list, references column 'antir2an_OP.t1.Started' which is not in SELECT list; this is incompatible with DISTINCT

        Barons & Baronesses of Dragon's Laire

        Baronial status: September 24, 2011/XXXXVI

          error: SELECT DISTINCT DATE(t1.`Started`) FROM antir2an_OP.`GRANTED_AWARDS` AS t1 WHERE t1.Demesne_ID =15 AND t1.Award_ID = 439 ORDER BY t1.`Started` Expression #1 of ORDER BY clause is not in SELECT list, references column 'antir2an_OP.t1.Started' which is not in SELECT list; this is incompatible with DISTINCT

          Barons & Baronesses of Dragon's Mist

          Baronial status: September 24, 2011/XXXXVI

            error: SELECT DISTINCT DATE(t1.`Started`) FROM antir2an_OP.`GRANTED_AWARDS` AS t1 WHERE t1.Demesne_ID =18 AND t1.Award_ID = 439 ORDER BY t1.`Started` Expression #1 of ORDER BY clause is not in SELECT list, references column 'antir2an_OP.t1.Started' which is not in SELECT list; this is incompatible with DISTINCT

            Barons & Baronesses of Glymm Mere

            Created as the incipient Shire of Evercleare - May XVI/1981
            Shire status: July10 XVII/1982
            Changed name to Glymm Mere: March XXII/1988
            Baronial status: January 9 XXVII/1993

              error: SELECT DISTINCT DATE(t1.`Started`) FROM antir2an_OP.`GRANTED_AWARDS` AS t1 WHERE t1.Demesne_ID =6 AND t1.Award_ID = 439 ORDER BY t1.`Started` Expression #1 of ORDER BY clause is not in SELECT list, references column 'antir2an_OP.t1.Started' which is not in SELECT list; this is incompatible with DISTINCT

              Barons & Baronesses of Lions Gate

              Organizational meeting - December VIII/1973
              First event - May 21 IX/1974
              Michel le Voyager/Susan the Opaque, Baron and Baroness designates resign - May 17 X/1975
              Created Barony: June 8 XI/1976

                error: SELECT DISTINCT DATE(t1.`Started`) FROM antir2an_OP.`GRANTED_AWARDS` AS t1 WHERE t1.Demesne_ID =5 AND t1.Award_ID = 439 ORDER BY t1.`Started` Expression #1 of ORDER BY clause is not in SELECT list, references column 'antir2an_OP.t1.Started' which is not in SELECT list; this is incompatible with DISTINCT

                Barons & Baronesses of Madrone

                First event May 3 V/1970, in Olympia.
                Baronial Tourney (with 3M) June 20 V/1970.
                Created barony: by Paul and Carol of West Kingdom in July VIII/1973. (Three Mountains became a barony same day.)

                  error: SELECT DISTINCT DATE(t1.`Started`) FROM antir2an_OP.`GRANTED_AWARDS` AS t1 WHERE t1.Demesne_ID =72 AND t1.Award_ID = 439 ORDER BY t1.`Started` Expression #1 of ORDER BY clause is not in SELECT list, references column 'antir2an_OP.t1.Started' which is not in SELECT list; this is incompatible with DISTINCT

                  Barons & Baronesses of Seagirt

                  Created a shire: 1 May XII/1977
                  Created a barony: July Coronation XXXIII/1998

                    error: SELECT DISTINCT DATE(t1.`Started`) FROM antir2an_OP.`GRANTED_AWARDS` AS t1 WHERE t1.Demesne_ID =28 AND t1.Award_ID = 439 ORDER BY t1.`Started` Expression #1 of ORDER BY clause is not in SELECT list, references column 'antir2an_OP.t1.Started' which is not in SELECT list; this is incompatible with DISTINCT

                    Barons & Baronesses of Stromgard

                    Created a shire: when?
                    Created a barony: Twelfth Night Coronation, January 9 XXXIV/2000

                      error: SELECT DISTINCT DATE(t1.`Started`) FROM antir2an_OP.`GRANTED_AWARDS` AS t1 WHERE t1.Demesne_ID =56 AND t1.Award_ID = 439 ORDER BY t1.`Started` Expression #1 of ORDER BY clause is not in SELECT list, references column 'antir2an_OP.t1.Started' which is not in SELECT list; this is incompatible with DISTINCT

                      Aborting -- too many errors...