CREATE TABLE tblQuoAztecsHorseUnits AS
select unittype, technologies.eratype from units
inner join technologies on technologies.TechnologyType = units.PrereqTech
where promotionclass in ("PROMOTION_CLASS_HEAVY_CAVALRY","PROMOTION_CLASS_LIGHT_CAVALRY") AND EraType in ("ERA_ANCIENT", "ERA_CLASSICAL", "ERA_MEDIEVAL", "ERA_RENAISSANCE", "ERA_INDUSTRIAL") AND TraitType IS NULL
union
select unittype, civics.EraType from units
inner join civics on civics.CivicType = units.PrereqCivic
where promotionclass in ("PROMOTION_CLASS_HEAVY_CAVALRY","PROMOTION_CLASS_LIGHT_CAVALRY") AND EraType in ("ERA_ANCIENT", "ERA_CLASSICAL", "ERA_MEDIEVAL", "ERA_RENAISSANCE", "ERA_INDUSTRIAL") AND TraitType IS NULL;
INSERT INTO Modifiers
(ModifierId, ModifierType, RunOnce, Permanent, OwnerRequirementSetId, SubjectRequirementSetId)
SELECT 'QUO_AZTECS_CANNOT_BUILD_' || tblQuoAztecsHorseUnits.UnitType, 'MODIFIER_PLAYER_UNIT_BUILD_DISABLED', 0, 0, NULL, NULL
FROM tblQuoAztecsHorseUnits;
INSERT INTO ModifierArguments
(ModifierId, Name, Type, Value, Extra, SecondExtra)
SELECT 'QUO_AZTECS_CANNOT_BUILD_' || tblQuoAztecsHorseUnits.UnitType, 'UnitType', 'ARGTYPE_IDENTITY', tblQuoAztecsHorseUnits.UnitType, NULL, NULL
FROM tblQuoAztecsHorseUnits;
INSERT INTO TraitModifiers
(TraitType, ModifierID)
SELECT 'TRAIT_CIVILIZATION_LEGEND_FIVE_SUNS', 'QUO_AZTECS_CANNOT_BUILD_' || tblQuoAztecsHorseUnits.UnitType
FROM tblQuoAztecsHorseUnits
WHERE EXISTS (SELECT Civilizations.CivilizationType FROM Civilizations WHERE Civilizations.CivilizationType = 'CIVILIZATION_AZTEC' ) ;