--[[ SQL Made by CyberMist2]]--
 
-- Get Season : 1 Armors
SELECT * FROM item_template WHERE
    name NOT LIKE '%brutal%' AND
        name NOT LIKE '%vengeful%'AND
            name NOT LIKE '%merciless%'AND
itemset IN
(/*druid=*/584, 585, 685,/*hunter=*/586,/*mage=*/579,/*paladin=*/582, 583, 690,/*priest=*/687, 581,/*rogue=*/577,/*shaman=*/578, 580, 686,/*warlock=*/568, 615,/*warrior=*/567);
 
-- Get Season : 2 Armors
SELECT * FROM item_template WHERE
    name LIKE '%merciless%' AND
        name NOT LIKE '%brutal%' AND
        name NOT LIKE '%vengeful%'AND
itemset IN
(/*druid=*/584, 585, 685,/*hunter=*/586,/*mage=*/579,/*paladin=*/582, 583, 690,/*priest=*/687, 581,/*rogue=*/577,/*shaman=*/578, 580, 686,/*warlock=*/568, 615,/*warrior=*/567);
 
-- Get Season : 3 Armors
SELECT * FROM item_template WHERE
    name LIKE '%vengeful%' AND
        name NOT LIKE '%brutal%' AND
            name NOT LIKE '%merciless%'AND
itemset IN
(/*druid=*/584, 585, 685,/*hunter=*/586,/*mage=*/579,/*paladin=*/582, 583, 690,/*priest=*/687, 581,/*rogue=*/577,/*shaman=*/578, 580, 686,/*warlock=*/568, 615,/*warrior=*/567);
 
 
-- Get Season : 4 Armors
SELECT * FROM item_template WHERE
    name LIKE '%brutal%' AND
        name NOT LIKE '%vengeful%' AND
            name NOT LIKE '%merciless%'AND
itemset IN
(/*druid=*/584, 585, 685,/*hunter=*/586,/*mage=*/579,/*paladin=*/582, 583, 690,/*priest=*/687, 581,/*rogue=*/577,/*shaman=*/578, 580, 686,/*warlock=*/568, 615,/*warrior=*/567);
@CyberMist2