DB/Creature: Vendor Update 3
[trinitycore] / sql / updates / world / master / 2018_04_06_02_world.sql
1 --
2 DELETE FROM `npc_vendor` WHERE (`entry`=18266 AND `item`=63696 AND `ExtendedCost`=56 AND `type`=1) OR (`entry`=20231 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=20231 AND `item`=30744 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=20231 AND `item`=4499 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=20231 AND `item`=27855 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=20231 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19314 AND `item`=30744 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19314 AND `item`=4499 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19314 AND `item`=27855 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19314 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=30734 AND `item`=79740 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=30734 AND `item`=1515 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=30734 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18773 AND `item`=38682 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18802 AND `item`=4565 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18802 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18802 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=16829 AND `item`=4565 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=16829 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=16826 AND `item`=39505 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=16826 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=16826 AND `item`=39354 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=16826 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=16826 AND `item`=30744 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=16826 AND `item`=4499 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=16826 AND `item`=27855 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=16826 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18774 AND `item`=52188 AND `ExtendedCost`=0 AND `type`=1);
3 INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
4 (18266, 1, 63696, 0, 56, 1, 0, 0, 26124), -- Bold Blood Garnet
5 (20231, 6, 4470, 0, 0, 1, 0, 0, 26124), -- Simple Wood
6 (20231, 5, 30744, 0, 0, 1, 0, 0, 26124), -- Draenic Leather Pack
7 (20231, 4, 4499, 0, 0, 1, 0, 0, 26124), -- Huge Brown Sack
8 (20231, 3, 27855, 0, 0, 1, 0, 0, 26124), -- Mag'har Grainbread
9 (20231, 1, 159, 0, 0, 1, 0, 0, 26124), -- Refreshing Spring Water
10 (19314, 5, 30744, 0, 0, 1, 0, 0, 26124), -- Draenic Leather Pack
11 (19314, 4, 4499, 0, 0, 1, 0, 0, 26124), -- Huge Brown Sack
12 (19314, 3, 27855, 0, 0, 1, 0, 0, 26124), -- Mag'har Grainbread
13 (19314, 1, 159, 0, 0, 1, 0, 0, 26124), -- Refreshing Spring Water
14 (30734, 7302, 79740, 0, 0, 1, 0, 0, 26124), -- Plain Wooden Staff
15 (30734, 7301, 1515, 0, 0, 1, 0, 0, 26124), -- Rough Wooden Staff
16 (30734, 7297, 64670, 0, 0, 1, 0, 0, 26124), -- Vanishing Powder
17 (18773, 4251, 38682, 0, 0, 1, 0, 0, 26124), -- Enchanting Vellum
18 (18802, 5, 4565, 0, 0, 1, 0, 0, 26124), -- Simple Dagger
19 (18802, 3, 3371, 0, 0, 1, 0, 0, 26124), -- Crystal Vial
20 (18802, 2, 64670, 0, 0, 1, 0, 0, 26124), -- Vanishing Powder
21 (16829, 4, 4565, 0, 0, 1, 0, 0, 26124), -- Simple Dagger
22 (16829, 3, 64670, 0, 0, 1, 0, 0, 26124), -- Vanishing Powder
23 (16826, 18, 39505, 0, 0, 1, 0, 0, 26124), -- Virtuoso Inking Set
24 (16826, 17, 20815, 0, 0, 1, 0, 0, 26124), -- Jeweler's Kit
25 (16826, 16, 39354, 0, 0, 1, 0, 0, 26124), -- Light Parchment
26 (16826, 14, 3371, 0, 0, 1, 0, 0, 26124), -- Crystal Vial
27 (16826, 11, 30744, 0, 0, 1, 0, 0, 26124), -- Draenic Leather Pack
28 (16826, 10, 4499, 0, 0, 1, 0, 0, 26124), -- Huge Brown Sack
29 (16826, 9, 27855, 0, 0, 1, 0, 0, 26124), -- Mag'har Grainbread
30 (16826, 8, 159, 0, 0, 1, 0, 0, 26124), -- Refreshing Spring Water
31 (18774, 2, 52188, 0, 0, 1, 0, 0, 26124); -- Jeweler's Setting
32
33 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=24520 AND `ExtendedCost`=53 AND `type`=1); -- Honor Hold Favor
34 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=27834 AND `ExtendedCost`=69 AND `type`=1); -- Circlet of the Victor
35 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=27833 AND `ExtendedCost`=69 AND `type`=1); -- Band of the Victor
36 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=27809 AND `ExtendedCost`=56 AND `type`=1); -- Jagged Deep Peridot
37 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=27812 AND `ExtendedCost`=56 AND `type`=1); -- Brilliant Blood Garnet
38 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=28361 AND `ExtendedCost`=56 AND `type`=1); -- Delicate Blood Garnet
39 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=20231 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
40 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=20231 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
41 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=20231 AND `item`=29451 AND `ExtendedCost`=0 AND `type`=1); -- Clefthoof Ribs
42 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=20231 AND `item`=27854 AND `ExtendedCost`=0 AND `type`=1); -- Smoked Talbuk Venison
43 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=20231 AND `item`=8952 AND `ExtendedCost`=0 AND `type`=1); -- Roasted Quail
44 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=20231 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
45 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
46 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
47 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=29451 AND `ExtendedCost`=0 AND `type`=1); -- Clefthoof Ribs
48 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=27854 AND `ExtendedCost`=0 AND `type`=1); -- Smoked Talbuk Venison
49 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=8952 AND `ExtendedCost`=0 AND `type`=1); -- Roasted Quail
50 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
51 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
52 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
53 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
54 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=29451 AND `ExtendedCost`=0 AND `type`=1); -- Clefthoof Ribs
55 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=27854 AND `ExtendedCost`=0 AND `type`=1); -- Smoked Talbuk Venison
56 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=8952 AND `ExtendedCost`=0 AND `type`=1); -- Roasted Quail
57 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
58 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
59 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
60 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
61 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=29451 AND `ExtendedCost`=0 AND `type`=1); -- Clefthoof Ribs
62 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=27854 AND `ExtendedCost`=0 AND `type`=1); -- Smoked Talbuk Venison
63 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=8952 AND `ExtendedCost`=0 AND `type`=1); -- Roasted Quail
64 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
65 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=19314 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
66 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=16823 AND `item`=3857 AND `ExtendedCost`=0 AND `type`=1); -- Coal
67 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=16823 AND `item`=18567 AND `ExtendedCost`=0 AND `type`=1); -- Elemental Flux
68 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=16823 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1); -- Strong Flux
69 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=16823 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1); -- Weak Flux
70 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=16823 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1); -- Blacksmith Hammer
71 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=16823 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1); -- Mining Pick
72 UPDATE `npc_vendor` SET `slot`=28, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=35465 AND `ExtendedCost`=0 AND `type`=1); -- Evoker's Silk Amice
73 UPDATE `npc_vendor` SET `slot`=23, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=29153 AND `ExtendedCost`=0 AND `type`=1); -- Blade of the Archmage
74 UPDATE `npc_vendor` SET `slot`=22, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=29151 AND `ExtendedCost`=0 AND `type`=1); -- Veteran's Musket
75 UPDATE `npc_vendor` SET `slot`=21, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=29156 AND `ExtendedCost`=0 AND `type`=1); -- Honor's Call
76 UPDATE `npc_vendor` SET `slot`=20, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=23999 AND `ExtendedCost`=0 AND `type`=1); -- Honor Hold Tabard
77 UPDATE `npc_vendor` SET `slot`=19, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=23619 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Felsteel Shield Spike
78 UPDATE `npc_vendor` SET `slot`=18, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=33150 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Enchant Cloak - Subtlety
79 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=29722 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Nethercobra Leg Armor
80 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=29169 AND `ExtendedCost`=0 AND `type`=1); -- Ring of Convalescence
81 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=29166 AND `ExtendedCost`=0 AND `type`=1); -- Hellforged Halberd
82 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=24180 AND `ExtendedCost`=0 AND `type`=1); -- Design: Dawnstone Crab
83 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=22547 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Enchant Chest - Exceptional Stats
84 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=25826 AND `ExtendedCost`=0 AND `type`=1); -- Sage's Band
85 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=25825 AND `ExtendedCost`=0 AND `type`=1); -- Footman's Longsword
86 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=25870 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Transmute Skyfire Diamond
87 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=29215 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Felstalker Breastplate
88 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=29214 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Felstalker Bracers
89 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=22905 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Elixir of Major Agility
90 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=29719 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Cobrahide Leg Armor
91 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=22531 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Enchant Bracer - Superior Healing
92 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=24008 AND `ExtendedCost`=0 AND `type`=1); -- Dried Mushroom Rations
93 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=24007 AND `ExtendedCost`=0 AND `type`=1); -- Footman's Waterskin
94 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=29213 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Felstalker Belt
95 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=17657 AND `item`=23142 AND `ExtendedCost`=0 AND `type`=1); -- Design: Regal Deep Peridot
96 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=24520 AND `ExtendedCost`=53 AND `type`=1); -- Honor Hold Favor
97 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=27834 AND `ExtendedCost`=69 AND `type`=1); -- Circlet of the Victor
98 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=27833 AND `ExtendedCost`=69 AND `type`=1); -- Band of the Victor
99 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=27809 AND `ExtendedCost`=56 AND `type`=1); -- Jagged Deep Peridot
100 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=27812 AND `ExtendedCost`=56 AND `type`=1); -- Brilliant Blood Garnet
101 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18266 AND `item`=28361 AND `ExtendedCost`=56 AND `type`=1); -- Delicate Blood Garnet
102 UPDATE `npc_vendor` SET `slot`=7300, `maxcount`=2, `VerifiedBuild`=26124 WHERE (`entry`=30734 AND `item`=39489 AND `ExtendedCost`=0 AND `type`=1); -- Scribe's Satchel
103 UPDATE `npc_vendor` SET `slot`=7299, `VerifiedBuild`=26124 WHERE (`entry`=30734 AND `item`=39505 AND `ExtendedCost`=0 AND `type`=1); -- Virtuoso Inking Set
104 UPDATE `npc_vendor` SET `slot`=7298, `VerifiedBuild`=26124 WHERE (`entry`=30734 AND `item`=39354 AND `ExtendedCost`=0 AND `type`=1); -- Light Parchment
105 UPDATE `npc_vendor` SET `slot`=4260, `VerifiedBuild`=26124 WHERE (`entry`=18773 AND `item`=22307 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Enchanted Mageweave Pouch
106 UPDATE `npc_vendor` SET `slot`=4259, `VerifiedBuild`=26124 WHERE (`entry`=18773 AND `item`=20753 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Lesser Wizard Oil
107 UPDATE `npc_vendor` SET `slot`=4258, `VerifiedBuild`=26124 WHERE (`entry`=18773 AND `item`=20752 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Minor Mana Oil
108 UPDATE `npc_vendor` SET `slot`=4257, `VerifiedBuild`=26124 WHERE (`entry`=18773 AND `item`=20758 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Minor Wizard Oil
109 UPDATE `npc_vendor` SET `slot`=4256, `VerifiedBuild`=26124 WHERE (`entry`=18773 AND `item`=11291 AND `ExtendedCost`=0 AND `type`=1); -- Star Wood
110 UPDATE `npc_vendor` SET `slot`=4255, `VerifiedBuild`=26124 WHERE (`entry`=18773 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
111 UPDATE `npc_vendor` SET `slot`=4254, `maxcount`=2, `VerifiedBuild`=26124 WHERE (`entry`=18773 AND `item`=10938 AND `ExtendedCost`=0 AND `type`=1); -- Lesser Magic Essence
112 UPDATE `npc_vendor` SET `slot`=4253, `VerifiedBuild`=26124 WHERE (`entry`=18773 AND `item`=10940 AND `ExtendedCost`=0 AND `type`=1); -- Strange Dust
113 UPDATE `npc_vendor` SET `slot`=4252, `VerifiedBuild`=26124 WHERE (`entry`=18773 AND `item`=6217 AND `ExtendedCost`=0 AND `type`=1); -- Copper Rod
114 UPDATE `npc_vendor` SET `slot`=397, `VerifiedBuild`=26124 WHERE (`entry`=18802 AND `item`=22900 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Elixir of Camouflage
115 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=16829 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1); -- Crystal Vial
116 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=10290 AND `ExtendedCost`=0 AND `type`=1); -- Pink Dye
117 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=4342 AND `ExtendedCost`=0 AND `type`=1); -- Purple Dye
118 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=6261 AND `ExtendedCost`=0 AND `type`=1); -- Orange Dye
119 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=4341 AND `ExtendedCost`=0 AND `type`=1); -- Yellow Dye
120 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=4340 AND `ExtendedCost`=0 AND `type`=1); -- Gray Dye
121 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=2605 AND `ExtendedCost`=0 AND `type`=1); -- Green Dye
122 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=2604 AND `ExtendedCost`=0 AND `type`=1); -- Red Dye
123 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=6260 AND `ExtendedCost`=0 AND `type`=1); -- Blue Dye
124 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=2325 AND `ExtendedCost`=0 AND `type`=1); -- Black Dye
125 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=38426 AND `ExtendedCost`=0 AND `type`=1); -- Eternium Thread
126 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1); -- Rune Thread
127 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=8343 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Silken Thread
128 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=4291 AND `ExtendedCost`=0 AND `type`=1); -- Silken Thread
129 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=2321 AND `ExtendedCost`=0 AND `type`=1); -- Fine Thread
130 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=2320 AND `ExtendedCost`=0 AND `type`=1); -- Coarse Thread
131 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=4289 AND `ExtendedCost`=0 AND `type`=1); -- Salt
132 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=18771 AND `item`=7005 AND `ExtendedCost`=0 AND `type`=1); -- Skinning Knife
133 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=10290 AND `ExtendedCost`=0 AND `type`=1); -- Pink Dye
134 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=4342 AND `ExtendedCost`=0 AND `type`=1); -- Purple Dye
135 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=2325 AND `ExtendedCost`=0 AND `type`=1); -- Black Dye
136 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=6261 AND `ExtendedCost`=0 AND `type`=1); -- Orange Dye
137 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=4340 AND `ExtendedCost`=0 AND `type`=1); -- Gray Dye
138 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=4341 AND `ExtendedCost`=0 AND `type`=1); -- Yellow Dye
139 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=2605 AND `ExtendedCost`=0 AND `type`=1); -- Green Dye
140 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=6260 AND `ExtendedCost`=0 AND `type`=1); -- Blue Dye
141 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=2604 AND `ExtendedCost`=0 AND `type`=1); -- Red Dye
142 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=2324 AND `ExtendedCost`=0 AND `type`=1); -- Bleach
143 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=38426 AND `ExtendedCost`=0 AND `type`=1); -- Eternium Thread
144 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1); -- Rune Thread
145 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=8343 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Silken Thread
146 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=4291 AND `ExtendedCost`=0 AND `type`=1); -- Silken Thread
147 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=2321 AND `ExtendedCost`=0 AND `type`=1); -- Fine Thread
148 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=18772 AND `item`=2320 AND `ExtendedCost`=0 AND `type`=1); -- Coarse Thread
149 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18987 AND `item`=2678 AND `ExtendedCost`=0 AND `type`=1); -- Mild Spices
150 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=18987 AND `item`=30817 AND `ExtendedCost`=0 AND `type`=1); -- Simple Flour
151 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18987 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1); -- Refreshing Spring Water
152 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=16826 AND `item`=6532 AND `ExtendedCost`=0 AND `type`=1); -- Bright Baubles
153 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=16826 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1); -- Rune Thread
154 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=16826 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
155 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=16826 AND `item`=29451 AND `ExtendedCost`=0 AND `type`=1); -- Clefthoof Ribs
156 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=16826 AND `item`=27854 AND `ExtendedCost`=0 AND `type`=1); -- Smoked Talbuk Venison
157 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=16826 AND `item`=8952 AND `ExtendedCost`=0 AND `type`=1); -- Roasted Quail
158 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=16826 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
159 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=16826 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
160 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=16826 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
161 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=16826 AND `item`=27688 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Ravager Dog
162 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=18774 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1); -- Jeweler's Kit
163 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=22227 AND `item`=28470 AND `ExtendedCost`=0 AND `type`=1); -- Subtle Amber
164 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=22227 AND `item`=28467 AND `ExtendedCost`=0 AND `type`=1); -- Smooth Amber
165 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=22227 AND `item`=28468 AND `ExtendedCost`=0 AND `type`=1); -- Rigid Zircon
166 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=22227 AND `item`=28464 AND `ExtendedCost`=0 AND `type`=1); -- Sparkling Zircon
167 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=22227 AND `item`=28463 AND `ExtendedCost`=0 AND `type`=1); -- Solid Zircon
168 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=22227 AND `item`=28459 AND `ExtendedCost`=0 AND `type`=1); -- Delicate Tourmaline
169 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=22227 AND `item`=28461 AND `ExtendedCost`=0 AND `type`=1); -- Brilliant Tourmaline
170 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=22227 AND `item`=28458 AND `ExtendedCost`=0 AND `type`=1); -- Bold Tourmaline
171 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=35101 AND `item`=25527 AND `ExtendedCost`=0 AND `type`=1); -- Swift Red Gryphon
172 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=35101 AND `item`=25529 AND `ExtendedCost`=0 AND `type`=1); -- Swift Purple Gryphon
173 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=35101 AND `item`=25528 AND `ExtendedCost`=0 AND `type`=1); -- Swift Green Gryphon
174 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=35101 AND `item`=25473 AND `ExtendedCost`=0 AND `type`=1); -- Swift Blue Gryphon
175 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=35101 AND `item`=25472 AND `ExtendedCost`=0 AND `type`=1); -- Snowy Gryphon
176 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=35101 AND `item`=25470 AND `ExtendedCost`=0 AND `type`=1); -- Golden Gryphon
177 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=35101 AND `item`=25471 AND `ExtendedCost`=0 AND `type`=1); -- Ebon Gryphon
178 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=16824 AND `item`=37460 AND `ExtendedCost`=0 AND `type`=1); -- Rope Pet Leash
179 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=19451 AND `item`=29449 AND `ExtendedCost`=0 AND `type`=1); -- Bladespire Bagel
180 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=19451 AND `item`=27855 AND `ExtendedCost`=0 AND `type`=1); -- Mag'har Grainbread
181 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=19451 AND `item`=8950 AND `ExtendedCost`=0 AND `type`=1); -- Homemade Cherry Pie
182 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=19451 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
183 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=19451 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
184 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=19451 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
185 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19452 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
186 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19452 AND `item`=30744 AND `ExtendedCost`=0 AND `type`=1); -- Draenic Leather Pack
187 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19452 AND `item`=4499 AND `ExtendedCost`=0 AND `type`=1); -- Huge Brown Sack
188 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19452 AND `item`=27855 AND `ExtendedCost`=0 AND `type`=1); -- Mag'har Grainbread
189 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19452 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
190 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19452 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1); -- Refreshing Spring Water
191
192 DELETE FROM `npc_vendor` WHERE (`entry`=19004 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18775 AND `item`=39354 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18775 AND `item`=90146 AND `ExtendedCost`=0 AND `type`=1);
193 INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
194 (19004, 1, 64670, 0, 0, 1, 0, 0, 26124), -- Vanishing Powder
195 (18775, 321, 39354, 0, 0, 1, 0, 0, 26124), -- Light Parchment
196 (18775, 310, 90146, 0, 0, 1, 0, 0, 26124); -- Tinker's Kit
197
198 UPDATE `npc_vendor` SET `slot`=19, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=23848 AND `ExtendedCost`=0 AND `type`=1); -- Nethergarde Bitter
199 UPDATE `npc_vendor` SET `slot`=18, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
200 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=1645 AND `ExtendedCost`=0 AND `type`=1); -- Moonberry Juice
201 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=1708 AND `ExtendedCost`=0 AND `type`=1); -- Sweet Nectar
202 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=1205 AND `ExtendedCost`=0 AND `type`=1); -- Melon Juice
203 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=1179 AND `ExtendedCost`=0 AND `type`=1); -- Ice Cold Milk
204 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1); -- Refreshing Spring Water
205 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=8932 AND `ExtendedCost`=0 AND `type`=1); -- Alterac Swiss
206 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=3927 AND `ExtendedCost`=0 AND `type`=1); -- Fine Aged Cheddar
207 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=1707 AND `ExtendedCost`=0 AND `type`=1); -- Stormwind Brie
208 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=422 AND `ExtendedCost`=0 AND `type`=1); -- Dwarven Mild
209 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=414 AND `ExtendedCost`=0 AND `type`=1); -- Dalaran Sharp
210 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=2070 AND `ExtendedCost`=0 AND `type`=1); -- Darnassian Bleu
211 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=8950 AND `ExtendedCost`=0 AND `type`=1); -- Homemade Cherry Pie
212 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=4601 AND `ExtendedCost`=0 AND `type`=1); -- Soft Banana Bread
213 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=4544 AND `ExtendedCost`=0 AND `type`=1); -- Mulgore Spice Bread
214 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=4542 AND `ExtendedCost`=0 AND `type`=1); -- Moist Cornbread
215 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=4541 AND `ExtendedCost`=0 AND `type`=1); -- Freshly Baked Bread
216 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=3546 AND `item`=4540 AND `ExtendedCost`=0 AND `type`=1); -- Tough Hunk of Bread
217 UPDATE `npc_vendor` SET `slot`=405, `VerifiedBuild`=26124 WHERE (`entry`=19001 AND `item`=30753 AND `ExtendedCost`=0 AND `type`=1); -- Warphorn Spear
218 UPDATE `npc_vendor` SET `slot`=404, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19001 AND `item`=30751 AND `ExtendedCost`=0 AND `type`=1); -- Mag'hari Light Axe
219 UPDATE `npc_vendor` SET `slot`=403, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19001 AND `item`=30752 AND `ExtendedCost`=0 AND `type`=1); -- Mag'hari Battleaxe
220 UPDATE `npc_vendor` SET `slot`=402, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19001 AND `item`=30750 AND `ExtendedCost`=0 AND `type`=1); -- Draenic Warblade
221 UPDATE `npc_vendor` SET `slot`=401, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19001 AND `item`=30749 AND `ExtendedCost`=0 AND `type`=1); -- Draenic Sparring Blade
222 UPDATE `npc_vendor` SET `slot`=400, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19001 AND `item`=30754 AND `ExtendedCost`=0 AND `type`=1); -- Ancient Bone Mace
223 UPDATE `npc_vendor` SET `slot`=2951, `VerifiedBuild`=26124 WHERE (`entry`=18906 AND `item`=30745 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Toolbox
224 UPDATE `npc_vendor` SET `slot`=2950, `VerifiedBuild`=26124 WHERE (`entry`=18906 AND `item`=30746 AND `ExtendedCost`=0 AND `type`=1); -- Mining Sack
225 UPDATE `npc_vendor` SET `slot`=2949, `VerifiedBuild`=26124 WHERE (`entry`=18906 AND `item`=30747 AND `ExtendedCost`=0 AND `type`=1); -- Gem Pouch
226 UPDATE `npc_vendor` SET `slot`=2948, `VerifiedBuild`=26124 WHERE (`entry`=18906 AND `item`=30748 AND `ExtendedCost`=0 AND `type`=1); -- Enchanter's Satchel
227 UPDATE `npc_vendor` SET `slot`=2947, `VerifiedBuild`=26124 WHERE (`entry`=18906 AND `item`=30744 AND `ExtendedCost`=0 AND `type`=1); -- Draenic Leather Pack
228 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18906 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
229 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=18906 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
230 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18906 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
231 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=18906 AND `item`=29451 AND `ExtendedCost`=0 AND `type`=1); -- Clefthoof Ribs
232 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18906 AND `item`=27854 AND `ExtendedCost`=0 AND `type`=1); -- Smoked Talbuk Venison
233 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=18906 AND `item`=8952 AND `ExtendedCost`=0 AND `type`=1); -- Roasted Quail
234 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=16798 AND `item`=29451 AND `ExtendedCost`=0 AND `type`=1); -- Clefthoof Ribs
235 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=16798 AND `item`=27854 AND `ExtendedCost`=0 AND `type`=1); -- Smoked Talbuk Venison
236 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=16798 AND `item`=8952 AND `ExtendedCost`=0 AND `type`=1); -- Roasted Quail
237 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=16798 AND `item`=29450 AND `ExtendedCost`=0 AND `type`=1); -- Telaari Grapes
238 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=16798 AND `item`=27856 AND `ExtendedCost`=0 AND `type`=1); -- Skethyl Berries
239 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=16798 AND `item`=8953 AND `ExtendedCost`=0 AND `type`=1); -- Deep Fried Plantains
240 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=16798 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
241 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=16798 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
242 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=16798 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
243 UPDATE `npc_vendor` SET `slot`=399, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19001 AND `item`=30751 AND `ExtendedCost`=0 AND `type`=1); -- Mag'hari Light Axe
244 UPDATE `npc_vendor` SET `slot`=398, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19001 AND `item`=30752 AND `ExtendedCost`=0 AND `type`=1); -- Mag'hari Battleaxe
245 UPDATE `npc_vendor` SET `slot`=397, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19001 AND `item`=30750 AND `ExtendedCost`=0 AND `type`=1); -- Draenic Warblade
246 UPDATE `npc_vendor` SET `slot`=396, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19001 AND `item`=30749 AND `ExtendedCost`=0 AND `type`=1); -- Draenic Sparring Blade
247 UPDATE `npc_vendor` SET `slot`=395, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19001 AND `item`=30754 AND `ExtendedCost`=0 AND `type`=1); -- Ancient Bone Mace
248 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=44737 AND `ExtendedCost`=0 AND `type`=1); -- Draenic Silk Robes
249 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
250 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=60335 AND `ExtendedCost`=0 AND `type`=1); -- Thick Hide Pack
251 UPDATE `npc_vendor` SET `slot`=20, `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=33449 AND `ExtendedCost`=0 AND `type`=1); -- Crusty Flatbread
252 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1); -- Refreshing Spring Water
253 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=35953 AND `ExtendedCost`=0 AND `type`=1); -- Mead Basted Caribou
254 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=35947 AND `ExtendedCost`=0 AND `type`=1); -- Sparkling Frostcap
255 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=35948 AND `ExtendedCost`=0 AND `type`=1); -- Savory Snowplum
256 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=35951 AND `ExtendedCost`=0 AND `type`=1); -- Poached Emperor Salmon
257 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=35952 AND `ExtendedCost`=0 AND `type`=1); -- Briny Hardcheese
258 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=35950 AND `ExtendedCost`=0 AND `type`=1); -- Sweet Potato Bread
259 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=33454 AND `ExtendedCost`=0 AND `type`=1); -- Salted Venison
260 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=33452 AND `ExtendedCost`=0 AND `type`=1); -- Honey-Spiced Lichen
261 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=35949 AND `ExtendedCost`=0 AND `type`=1); -- Tundra Berries
262 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=33451 AND `ExtendedCost`=0 AND `type`=1); -- Fillet of Icefin
263 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=33443 AND `ExtendedCost`=0 AND `type`=1); -- Sour Goat Cheese
264 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=33449 AND `ExtendedCost`=0 AND `type`=1); -- Crusty Flatbread
265 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=33445 AND `ExtendedCost`=0 AND `type`=1); -- Honeymint Tea
266 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=33444 AND `ExtendedCost`=0 AND `type`=1); -- Pungent Seal Whey
267 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=35954 AND `ExtendedCost`=0 AND `type`=1); -- Sweetened Goat's Milk
268 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=40042 AND `ExtendedCost`=0 AND `type`=1); -- Caraway Burnwine
269 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=40036 AND `ExtendedCost`=0 AND `type`=1); -- Snowplum Brandy
270 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=32638 AND `item`=40035 AND `ExtendedCost`=0 AND `type`=1); -- Northrend Honey Mead
271 UPDATE `npc_vendor` SET `slot`=339, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=23805 AND `ExtendedCost`=0 AND `type`=1); -- Schematic: Ultra-Spectropic Detection Goggles
272 UPDATE `npc_vendor` SET `slot`=338, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=23803 AND `ExtendedCost`=0 AND `type`=1); -- Schematic: Cogspinner Goggles
273 UPDATE `npc_vendor` SET `slot`=320, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=4364 AND `ExtendedCost`=0 AND `type`=1); -- Coarse Blasting Powder
274 UPDATE `npc_vendor` SET `slot`=319, `maxcount`=2, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=4357 AND `ExtendedCost`=0 AND `type`=1); -- Rough Blasting Powder
275 UPDATE `npc_vendor` SET `slot`=318, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=4404 AND `ExtendedCost`=0 AND `type`=1); -- Silver Contact
276 UPDATE `npc_vendor` SET `slot`=317, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=10647 AND `ExtendedCost`=0 AND `type`=1); -- Engineer's Ink
277 UPDATE `npc_vendor` SET `slot`=316, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1); -- Strong Flux
278 UPDATE `npc_vendor` SET `slot`=315, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1); -- Weak Flux
279 UPDATE `npc_vendor` SET `slot`=314, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=39684 AND `ExtendedCost`=0 AND `type`=1); -- Hair Trigger
280 UPDATE `npc_vendor` SET `slot`=313, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=40533 AND `ExtendedCost`=0 AND `type`=1); -- Walnut Stock
281 UPDATE `npc_vendor` SET `slot`=312, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=4400 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Stock
282 UPDATE `npc_vendor` SET `slot`=311, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=4399 AND `ExtendedCost`=0 AND `type`=1); -- Wooden Stock
283 UPDATE `npc_vendor` SET `slot`=309, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1); -- Mining Pick
284 UPDATE `npc_vendor` SET `slot`=308, `VerifiedBuild`=26124 WHERE (`entry`=18775 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1); -- Blacksmith Hammer
285
286 DELETE FROM `npc_vendor` WHERE (`entry`=18911 AND `item`=136377 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18006 AND `item`=4565 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18006 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18907 AND `item`=39505 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18907 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18907 AND `item`=39354 AND `ExtendedCost`=0 AND `type`=1);
287 INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
288 (18911, 340, 136377, 0, 0, 1, 0, 0, 26124), -- Oversized Bobber
289 (18006, 2, 4565, 0, 0, 1, 0, 0, 26124), -- Simple Dagger
290 (18006, 1, 64670, 0, 0, 1, 0, 0, 26124), -- Vanishing Powder
291 (18907, 18, 39505, 0, 0, 1, 0, 0, 26124), -- Virtuoso Inking Set
292 (18907, 17, 20815, 0, 0, 1, 0, 0, 26124), -- Jeweler's Kit
293 (18907, 16, 39354, 0, 0, 1, 0, 0, 26124); -- Light Parchment
294
295 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=34478 AND `ExtendedCost`=388 AND `type`=1); -- Tiny Sporebat
296 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=31775 AND `ExtendedCost`=1994 AND `type`=1); -- Sporeggar Tabard
297 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=22906 AND `ExtendedCost`=388 AND `type`=1); -- Recipe: Shrouding Potion
298 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=38229 AND `ExtendedCost`=103 AND `type`=1); -- Pattern: Mycah's Botanical Bag
299 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=22916 AND `ExtendedCost`=103 AND `type`=1); -- Recipe: Transmute Primal Earth to Water
300 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=29150 AND `ExtendedCost`=1077 AND `type`=1); -- Hardened Stone Shard
301 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=29149 AND `ExtendedCost`=1076 AND `type`=1); -- Sporeling's Firestick
302 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=25828 AND `ExtendedCost`=104 AND `type`=1); -- Petrified Lichen Guard
303 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=25827 AND `ExtendedCost`=103 AND `type`=1); -- Muck-Covered Drape
304 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=25550 AND `ExtendedCost`=100 AND `type`=1); -- Redcap Toadstool
305 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=25548 AND `ExtendedCost`=100 AND `type`=1); -- Tallstalk Mushroom
306 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=24539 AND `ExtendedCost`=102 AND `type`=1); -- Marsh Lichen
307 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=18382 AND `item`=30156 AND `ExtendedCost`=100 AND `type`=1); -- Recipe: Clam Bar
308 UPDATE `npc_vendor` SET `slot`=344, `VerifiedBuild`=26124 WHERE (`entry`=18911 AND `item`=6533 AND `ExtendedCost`=0 AND `type`=1); -- Aquadynamic Fish Attractor
309 UPDATE `npc_vendor` SET `slot`=343, `VerifiedBuild`=26124 WHERE (`entry`=18911 AND `item`=6532 AND `ExtendedCost`=0 AND `type`=1); -- Bright Baubles
310 UPDATE `npc_vendor` SET `slot`=342, `VerifiedBuild`=26124 WHERE (`entry`=18911 AND `item`=6530 AND `ExtendedCost`=0 AND `type`=1); -- Nightcrawlers
311 UPDATE `npc_vendor` SET `slot`=341, `VerifiedBuild`=26124 WHERE (`entry`=18911 AND `item`=6529 AND `ExtendedCost`=0 AND `type`=1); -- Shiny Bauble
312 UPDATE `npc_vendor` SET `slot`=339, `VerifiedBuild`=26124 WHERE (`entry`=18911 AND `item`=6256 AND `ExtendedCost`=0 AND `type`=1); -- Fishing Pole
313 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18911 AND `item`=27696 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Blackened Sporefish
314 UPDATE `npc_vendor` SET `slot`=1881, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=23595 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Plate Gloves
315 UPDATE `npc_vendor` SET `slot`=1880, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=23594 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Plate Bracers
316 UPDATE `npc_vendor` SET `slot`=1879, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=23596 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Breastplate
317 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30784 AND `ExtendedCost`=0 AND `type`=1); -- Worn Mag'hari Gauntlets
318 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30781 AND `ExtendedCost`=0 AND `type`=1); -- Mag'hari Chain Vest
319 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30765 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Draenic Breastplate
320 UPDATE `npc_vendor` SET `slot`=6, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30775 AND `ExtendedCost`=0 AND `type`=1); -- Layered Bone Shield
321 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30771 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Draenic Bracers
322 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30777 AND `ExtendedCost`=0 AND `type`=1); -- Aldor Heavy Belt
323 UPDATE `npc_vendor` SET `slot`=1873, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=23594 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Plate Bracers
324 UPDATE `npc_vendor` SET `slot`=1872, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=23595 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Plate Gloves
325 UPDATE `npc_vendor` SET `slot`=1871, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=23596 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Breastplate
326 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30784 AND `ExtendedCost`=0 AND `type`=1); -- Worn Mag'hari Gauntlets
327 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30781 AND `ExtendedCost`=0 AND `type`=1); -- Mag'hari Chain Vest
328 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30765 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Draenic Breastplate
329 UPDATE `npc_vendor` SET `slot`=6, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30775 AND `ExtendedCost`=0 AND `type`=1); -- Layered Bone Shield
330 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30771 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Draenic Bracers
331 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30777 AND `ExtendedCost`=0 AND `type`=1); -- Aldor Heavy Belt
332 UPDATE `npc_vendor` SET `slot`=1441, `VerifiedBuild`=26124 WHERE (`entry`=18005 AND `item`=22909 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Elixir of Major Defense
333 UPDATE `npc_vendor` SET `slot`=1440, `VerifiedBuild`=26124 WHERE (`entry`=18005 AND `item`=22902 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Elixir of Major Frost Power
334 UPDATE `npc_vendor` SET `slot`=1437, `VerifiedBuild`=26124 WHERE (`entry`=18005 AND `item`=22907 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Super Mana Potion
335 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18005 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1); -- Crystal Vial
336 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=18250 AND `item`=37460 AND `ExtendedCost`=0 AND `type`=1); -- Rope Pet Leash
337 UPDATE `npc_vendor` SET `slot`=1870, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=23594 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Plate Bracers
338 UPDATE `npc_vendor` SET `slot`=1869, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=23595 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Plate Gloves
339 UPDATE `npc_vendor` SET `slot`=1868, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=23596 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Breastplate
340 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30784 AND `ExtendedCost`=0 AND `type`=1); -- Worn Mag'hari Gauntlets
341 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30781 AND `ExtendedCost`=0 AND `type`=1); -- Mag'hari Chain Vest
342 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30765 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Draenic Breastplate
343 UPDATE `npc_vendor` SET `slot`=6, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30775 AND `ExtendedCost`=0 AND `type`=1); -- Layered Bone Shield
344 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30771 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Draenic Bracers
345 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=19694 AND `item`=30777 AND `ExtendedCost`=0 AND `type`=1); -- Aldor Heavy Belt
346 UPDATE `npc_vendor` SET `slot`=37, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=35347 AND `ExtendedCost`=0 AND `type`=1); -- Evoker's Silk Trousers
347 UPDATE `npc_vendor` SET `slot`=32, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=33999 AND `ExtendedCost`=0 AND `type`=1); -- Cenarion War Hippogryph
348 UPDATE `npc_vendor` SET `slot`=31, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31804 AND `ExtendedCost`=0 AND `type`=1); -- Cenarion Expedition Tabard
349 UPDATE `npc_vendor` SET `slot`=30, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29172 AND `ExtendedCost`=0 AND `type`=1); -- Ashyen's Gift
350 UPDATE `npc_vendor` SET `slot`=29, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29170 AND `ExtendedCost`=0 AND `type`=1); -- Windcaller's Orb
351 UPDATE `npc_vendor` SET `slot`=28, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29171 AND `ExtendedCost`=0 AND `type`=1); -- Earthwarden
352 UPDATE `npc_vendor` SET `slot`=27, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=33149 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Enchant Cloak - Stealth
353 UPDATE `npc_vendor` SET `slot`=26, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31402 AND `ExtendedCost`=0 AND `type`=1); -- Design: The Natural Ward
354 UPDATE `npc_vendor` SET `slot`=25, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29721 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Nethercleft Leg Armor
355 UPDATE `npc_vendor` SET `slot`=24, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31390 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Wildguard Breastplate
356 UPDATE `npc_vendor` SET `slot`=23, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31356 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Flask of Distilled Wisdom
357 UPDATE `npc_vendor` SET `slot`=22, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=22922 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Major Nature Protection Potion
358 UPDATE `npc_vendor` SET `slot`=21, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29173 AND `ExtendedCost`=0 AND `type`=1); -- Strength of the Untamed
359 UPDATE `npc_vendor` SET `slot`=20, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29174 AND `ExtendedCost`=0 AND `type`=1); -- Watcher's Cowl
360 UPDATE `npc_vendor` SET `slot`=19, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31391 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Wildguard Leggings
361 UPDATE `npc_vendor` SET `slot`=18, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31392 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Wildguard Helm
362 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=22918 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Transmute Primal Water to Air
363 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=28271 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Enchant Gloves - Precise Strikes
364 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25735 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Heavy Clefthoof Vest
365 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=24183 AND `ExtendedCost`=0 AND `type`=1); -- Design: Nightseye Panther
366 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25835 AND `ExtendedCost`=0 AND `type`=1); -- Explorer's Walking Stick
367 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25838 AND `ExtendedCost`=0 AND `type`=1); -- Warden's Hauberk
368 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=32070 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Earthen Elixir
369 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25836 AND `ExtendedCost`=0 AND `type`=1); -- Preserver's Cudgel
370 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25526 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Greater Rune of Warding
371 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29720 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Clefthide Leg Armor
372 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25869 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Transmute Earthstorm Diamond
373 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=28632 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Weightstone
374 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=23618 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Sharpening Stone
375 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25736 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Heavy Clefthoof Leggings
376 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=24429 AND `ExtendedCost`=0 AND `type`=1); -- Expedition Flare
377 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=23814 AND `ExtendedCost`=0 AND `type`=1); -- Schematic: Green Smoke Flare
378 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25737 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Heavy Clefthoof Boots
379 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
380 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=30744 AND `ExtendedCost`=0 AND `type`=1); -- Draenic Leather Pack
381 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=4499 AND `ExtendedCost`=0 AND `type`=1); -- Huge Brown Sack
382 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=27855 AND `ExtendedCost`=0 AND `type`=1); -- Mag'har Grainbread
383 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
384 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1); -- Refreshing Spring Water
385 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18581 AND `item`=27922 AND `ExtendedCost`=77 AND `type`=1); -- Mark of Defiance
386 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18581 AND `item`=27942 AND `ExtendedCost`=69 AND `type`=1); -- Incendic Rod
387 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=18581 AND `item`=27931 AND `ExtendedCost`=69 AND `type`=1); -- Splintermark
388 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18581 AND `item`=27922 AND `ExtendedCost`=77 AND `type`=1); -- Mark of Defiance
389 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18581 AND `item`=27942 AND `ExtendedCost`=69 AND `type`=1); -- Incendic Rod
390 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=18581 AND `item`=27931 AND `ExtendedCost`=69 AND `type`=1); -- Splintermark
391 UPDATE `npc_vendor` SET `slot`=19, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=29112 AND `ExtendedCost`=0 AND `type`=1); -- Cenarion Spirits
392 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=6532 AND `ExtendedCost`=0 AND `type`=1); -- Bright Baubles
393 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1); -- Crystal Vial
394 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1); -- Rune Thread
395 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
396 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=30744 AND `ExtendedCost`=0 AND `type`=1); -- Draenic Leather Pack
397 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=4499 AND `ExtendedCost`=0 AND `type`=1); -- Huge Brown Sack
398 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1); -- Refreshing Spring Water
399 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
400 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
401 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
402 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=29449 AND `ExtendedCost`=0 AND `type`=1); -- Bladespire Bagel
403 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=27855 AND `ExtendedCost`=0 AND `type`=1); -- Mag'har Grainbread
404 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=18907 AND `item`=8950 AND `ExtendedCost`=0 AND `type`=1); -- Homemade Cherry Pie
405 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=18993 AND `item`=2678 AND `ExtendedCost`=0 AND `type`=1); -- Mild Spices
406 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=18993 AND `item`=30817 AND `ExtendedCost`=0 AND `type`=1); -- Simple Flour
407 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=18993 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1); -- Refreshing Spring Water
408 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=17896 AND `item`=37460 AND `ExtendedCost`=0 AND `type`=1); -- Rope Pet Leash
409 UPDATE `npc_vendor` SET `slot`=37, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=35347 AND `ExtendedCost`=0 AND `type`=1); -- Evoker's Silk Trousers
410 UPDATE `npc_vendor` SET `slot`=32, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=33999 AND `ExtendedCost`=0 AND `type`=1); -- Cenarion War Hippogryph
411 UPDATE `npc_vendor` SET `slot`=31, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31804 AND `ExtendedCost`=0 AND `type`=1); -- Cenarion Expedition Tabard
412 UPDATE `npc_vendor` SET `slot`=30, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29172 AND `ExtendedCost`=0 AND `type`=1); -- Ashyen's Gift
413 UPDATE `npc_vendor` SET `slot`=29, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29170 AND `ExtendedCost`=0 AND `type`=1); -- Windcaller's Orb
414 UPDATE `npc_vendor` SET `slot`=28, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29171 AND `ExtendedCost`=0 AND `type`=1); -- Earthwarden
415 UPDATE `npc_vendor` SET `slot`=27, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=33149 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Enchant Cloak - Stealth
416 UPDATE `npc_vendor` SET `slot`=26, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31402 AND `ExtendedCost`=0 AND `type`=1); -- Design: The Natural Ward
417 UPDATE `npc_vendor` SET `slot`=25, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29721 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Nethercleft Leg Armor
418 UPDATE `npc_vendor` SET `slot`=24, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31390 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Wildguard Breastplate
419 UPDATE `npc_vendor` SET `slot`=23, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31356 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Flask of Distilled Wisdom
420 UPDATE `npc_vendor` SET `slot`=22, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=22922 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Major Nature Protection Potion
421 UPDATE `npc_vendor` SET `slot`=21, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29173 AND `ExtendedCost`=0 AND `type`=1); -- Strength of the Untamed
422 UPDATE `npc_vendor` SET `slot`=20, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29174 AND `ExtendedCost`=0 AND `type`=1); -- Watcher's Cowl
423 UPDATE `npc_vendor` SET `slot`=19, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31391 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Wildguard Leggings
424 UPDATE `npc_vendor` SET `slot`=18, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=31392 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Wildguard Helm
425 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=22918 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Transmute Primal Water to Air
426 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=28271 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Enchant Gloves - Precise Strikes
427 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25735 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Heavy Clefthoof Vest
428 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=24183 AND `ExtendedCost`=0 AND `type`=1); -- Design: Nightseye Panther
429 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25835 AND `ExtendedCost`=0 AND `type`=1); -- Explorer's Walking Stick
430 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25838 AND `ExtendedCost`=0 AND `type`=1); -- Warden's Hauberk
431 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=32070 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Earthen Elixir
432 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25836 AND `ExtendedCost`=0 AND `type`=1); -- Preserver's Cudgel
433 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25526 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Greater Rune of Warding
434 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=29720 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Clefthide Leg Armor
435 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25869 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Transmute Earthstorm Diamond
436 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=28632 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Weightstone
437 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=23618 AND `ExtendedCost`=0 AND `type`=1); -- Plans: Adamantite Sharpening Stone
438 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25736 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Heavy Clefthoof Leggings
439 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=24429 AND `ExtendedCost`=0 AND `type`=1); -- Expedition Flare
440 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=23814 AND `ExtendedCost`=0 AND `type`=1); -- Schematic: Green Smoke Flare
441 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=17904 AND `item`=25737 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Heavy Clefthoof Boots
442 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
443 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=30744 AND `ExtendedCost`=0 AND `type`=1); -- Draenic Leather Pack
444 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=4499 AND `ExtendedCost`=0 AND `type`=1); -- Huge Brown Sack
445 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=27855 AND `ExtendedCost`=0 AND `type`=1); -- Mag'har Grainbread
446 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
447 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=21172 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1); -- Refreshing Spring Water
448
449 DELETE FROM `npc_vendor` WHERE (`entry`=18009 AND `item`=39505 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18009 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18009 AND `item`=85663 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18019 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18019 AND `item`=4565 AND `ExtendedCost`=0 AND `type`=1);
450 INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
451 (18009, 28, 39505, 0, 0, 1, 0, 0, 26124), -- Virtuoso Inking Set
452 (18009, 27, 20815, 0, 0, 1, 0, 0, 26124), -- Jeweler's Kit
453 (18009, 3, 85663, 0, 0, 1, 0, 0, 26124), -- Herbalist's Spade
454 (18019, 2, 64670, 0, 0, 1, 0, 0, 26124), -- Vanishing Powder
455 (18019, 1, 4565, 0, 0, 1, 0, 0, 26124); -- Simple Dagger
456
457 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30784 AND `ExtendedCost`=0 AND `type`=1); -- Worn Mag'hari Gauntlets
458 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30781 AND `ExtendedCost`=0 AND `type`=1); -- Mag'hari Chain Vest
459 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30765 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Draenic Breastplate
460 UPDATE `npc_vendor` SET `slot`=3, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30775 AND `ExtendedCost`=0 AND `type`=1); -- Layered Bone Shield
461 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30771 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Draenic Bracers
462 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30777 AND `ExtendedCost`=0 AND `type`=1); -- Aldor Heavy Belt
463 UPDATE `npc_vendor` SET `slot`=727, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=21898 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Imbued Netherweave Pants
464 UPDATE `npc_vendor` SET `slot`=726, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=21899 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Imbued Netherweave Boots
465 UPDATE `npc_vendor` SET `slot`=18, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=10290 AND `ExtendedCost`=0 AND `type`=1); -- Pink Dye
466 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=4342 AND `ExtendedCost`=0 AND `type`=1); -- Purple Dye
467 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=2325 AND `ExtendedCost`=0 AND `type`=1); -- Black Dye
468 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=6261 AND `ExtendedCost`=0 AND `type`=1); -- Orange Dye
469 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=4340 AND `ExtendedCost`=0 AND `type`=1); -- Gray Dye
470 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=4341 AND `ExtendedCost`=0 AND `type`=1); -- Yellow Dye
471 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=2605 AND `ExtendedCost`=0 AND `type`=1); -- Green Dye
472 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=6260 AND `ExtendedCost`=0 AND `type`=1); -- Blue Dye
473 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=2604 AND `ExtendedCost`=0 AND `type`=1); -- Red Dye
474 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=2324 AND `ExtendedCost`=0 AND `type`=1); -- Bleach
475 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=38426 AND `ExtendedCost`=0 AND `type`=1); -- Eternium Thread
476 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1); -- Rune Thread
477 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=8343 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Silken Thread
478 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=4291 AND `ExtendedCost`=0 AND `type`=1); -- Silken Thread
479 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=2321 AND `ExtendedCost`=0 AND `type`=1); -- Fine Thread
480 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=19722 AND `item`=2320 AND `ExtendedCost`=0 AND `type`=1); -- Coarse Thread
481 UPDATE `npc_vendor` SET `slot`=26, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=6532 AND `ExtendedCost`=0 AND `type`=1); -- Bright Baubles
482 UPDATE `npc_vendor` SET `slot`=25, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=6530 AND `ExtendedCost`=0 AND `type`=1); -- Nightcrawlers
483 UPDATE `npc_vendor` SET `slot`=24, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4400 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Stock
484 UPDATE `npc_vendor` SET `slot`=23, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4399 AND `ExtendedCost`=0 AND `type`=1); -- Wooden Stock
485 UPDATE `npc_vendor` SET `slot`=22, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4289 AND `ExtendedCost`=0 AND `type`=1); -- Salt
486 UPDATE `npc_vendor` SET `slot`=21, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1); -- Crystal Vial
487 UPDATE `npc_vendor` SET `slot`=20, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4340 AND `ExtendedCost`=0 AND `type`=1); -- Gray Dye
488 UPDATE `npc_vendor` SET `slot`=19, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4342 AND `ExtendedCost`=0 AND `type`=1); -- Purple Dye
489 UPDATE `npc_vendor` SET `slot`=18, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4341 AND `ExtendedCost`=0 AND `type`=1); -- Yellow Dye
490 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2325 AND `ExtendedCost`=0 AND `type`=1); -- Black Dye
491 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2604 AND `ExtendedCost`=0 AND `type`=1); -- Red Dye
492 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=3857 AND `ExtendedCost`=0 AND `type`=1); -- Coal
493 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1); -- Strong Flux
494 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1); -- Weak Flux
495 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2678 AND `ExtendedCost`=0 AND `type`=1); -- Mild Spices
496 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1); -- Rune Thread
497 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=8343 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Silken Thread
498 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4291 AND `ExtendedCost`=0 AND `type`=1); -- Silken Thread
499 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2321 AND `ExtendedCost`=0 AND `type`=1); -- Fine Thread
500 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2320 AND `ExtendedCost`=0 AND `type`=1); -- Coarse Thread
501 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1); -- Blacksmith Hammer
502 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=6217 AND `ExtendedCost`=0 AND `type`=1); -- Copper Rod
503 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=6256 AND `ExtendedCost`=0 AND `type`=1); -- Fishing Pole
504 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=7005 AND `ExtendedCost`=0 AND `type`=1); -- Skinning Knife
505 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1); -- Mining Pick
506 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=20028 AND `item`=2678 AND `ExtendedCost`=0 AND `type`=1); -- Mild Spices
507 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=20028 AND `item`=30817 AND `ExtendedCost`=0 AND `type`=1); -- Simple Flour
508 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=20028 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1); -- Refreshing Spring Water
509 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=20028 AND `item`=27694 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Blackened Trout
510 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=20028 AND `item`=27695 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Feltail Delight
511 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30784 AND `ExtendedCost`=0 AND `type`=1); -- Worn Mag'hari Gauntlets
512 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30781 AND `ExtendedCost`=0 AND `type`=1); -- Mag'hari Chain Vest
513 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30765 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Draenic Breastplate
514 UPDATE `npc_vendor` SET `slot`=3, `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30775 AND `ExtendedCost`=0 AND `type`=1); -- Layered Bone Shield
515 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30771 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Draenic Bracers
516 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=18010 AND `item`=30777 AND `ExtendedCost`=0 AND `type`=1); -- Aldor Heavy Belt
517 UPDATE `npc_vendor` SET `slot`=26, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=6532 AND `ExtendedCost`=0 AND `type`=1); -- Bright Baubles
518 UPDATE `npc_vendor` SET `slot`=25, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=6530 AND `ExtendedCost`=0 AND `type`=1); -- Nightcrawlers
519 UPDATE `npc_vendor` SET `slot`=24, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4400 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Stock
520 UPDATE `npc_vendor` SET `slot`=23, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4399 AND `ExtendedCost`=0 AND `type`=1); -- Wooden Stock
521 UPDATE `npc_vendor` SET `slot`=22, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4289 AND `ExtendedCost`=0 AND `type`=1); -- Salt
522 UPDATE `npc_vendor` SET `slot`=21, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1); -- Crystal Vial
523 UPDATE `npc_vendor` SET `slot`=20, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4340 AND `ExtendedCost`=0 AND `type`=1); -- Gray Dye
524 UPDATE `npc_vendor` SET `slot`=19, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4342 AND `ExtendedCost`=0 AND `type`=1); -- Purple Dye
525 UPDATE `npc_vendor` SET `slot`=18, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4341 AND `ExtendedCost`=0 AND `type`=1); -- Yellow Dye
526 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2325 AND `ExtendedCost`=0 AND `type`=1); -- Black Dye
527 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2604 AND `ExtendedCost`=0 AND `type`=1); -- Red Dye
528 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=3857 AND `ExtendedCost`=0 AND `type`=1); -- Coal
529 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1); -- Strong Flux
530 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1); -- Weak Flux
531 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2678 AND `ExtendedCost`=0 AND `type`=1); -- Mild Spices
532 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1); -- Rune Thread
533 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=8343 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Silken Thread
534 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=4291 AND `ExtendedCost`=0 AND `type`=1); -- Silken Thread
535 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2321 AND `ExtendedCost`=0 AND `type`=1); -- Fine Thread
536 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2320 AND `ExtendedCost`=0 AND `type`=1); -- Coarse Thread
537 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1); -- Blacksmith Hammer
538 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=6217 AND `ExtendedCost`=0 AND `type`=1); -- Copper Rod
539 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=6256 AND `ExtendedCost`=0 AND `type`=1); -- Fishing Pole
540 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=7005 AND `ExtendedCost`=0 AND `type`=1); -- Skinning Knife
541 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=18009 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1); -- Mining Pick
542
543 DELETE FROM `npc_vendor` WHERE (`entry`=19053 AND `item`=4499 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19053 AND `item`=27855 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19053 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19053 AND `item`=159 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19042 AND `item`=39505 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19042 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19042 AND `item`=39354 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19042 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19234 AND `item`=38682 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19235 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19245 AND `item`=82344 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19245 AND `item`=83094 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19245 AND `item`=82343 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19245 AND `item`=83095 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33634 AND `item`=39354 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33634 AND `item`=90146 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33630 AND `item`=4565 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33630 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19239 AND `item`=4565 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33640 AND `item`=30746 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33637 AND `item`=52188 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33633 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33633 AND `item`=10940 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33633 AND `item`=38682 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33638 AND `item`=79740 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33638 AND `item`=1515 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=33638 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19244 AND `item`=39505 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19244 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19244 AND `item`=85663 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=35326 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=34162 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=34163 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=34049 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=34050 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33832 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33296 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33192 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33325 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33334 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33484 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=35321 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33304 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=35324 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33333 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33593 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33589 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33587 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33585 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33291 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33586 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33584 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33588 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33583 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33579 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33972 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33559 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33973 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33974 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33557 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33552 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33287 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33577 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33582 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33566 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33580 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33578 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33539 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33222 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33538 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33540 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33537 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33536 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33531 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33324 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33530 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33386 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33534 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33532 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33970 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33965 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33535 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33529 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33280 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33527 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33528 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33520 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33523 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33207 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33518 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33519 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33524 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33522 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33515 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33514 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33512 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33331 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33513 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33516 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33279 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33517 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33501 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=33810 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=32090 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=32089 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=32085 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=32086 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=32087 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=32088 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=32084 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=32083 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30762 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30761 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30764 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30763 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30766 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30767 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30769 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30768 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30778 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30780 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30776 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30779 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30772 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30773 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30774 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30770 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=30183 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=23572 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29387 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29383 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29376 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29370 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29385 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29382 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29375 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29369 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29386 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29381 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29374 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29368 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29384 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29379 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29373 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29367 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29266 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29272 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29267 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29274 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29269 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29270 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29275 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29268 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29271 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18525 AND `item`=29273 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34952 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34949 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34894 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34951 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34950 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34893 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34896 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34898 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34892 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34895 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34891 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34888 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34887 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34890 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34889 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34940 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34939 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34941 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34943 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34942 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34944 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34946 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34945 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34947 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34922 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34921 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34923 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34934 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34933 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34935 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34931 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34930 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34932 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34914 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34916 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34912 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34928 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34927 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34929 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34905 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34904 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34903 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34910 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34911 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34906 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34901 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34902 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34900 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34936 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34937 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34938 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34924 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34925 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34926 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34917 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34918 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=27667 AND `item`=34919 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=52278 AND `item`=15198 AND `ExtendedCost`=5962 AND `type`=1) OR (`entry`=52278 AND `item`=15196 AND `ExtendedCost`=5962 AND `type`=1) OR (`entry`=52278 AND `item`=19032 AND `ExtendedCost`=5992 AND `type`=1) OR (`entry`=52278 AND `item`=19506 AND `ExtendedCost`=5992 AND `type`=1) OR (`entry`=52278 AND `item`=31774 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=52278 AND `item`=23999 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19049 AND `item`=4565 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19197 AND `item`=39505 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19197 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19197 AND `item`=39354 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19678 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19661 AND `item`=39354 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19661 AND `item`=90146 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19227 AND `item`=74918 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18756 AND `item`=134007 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18756 AND `item`=134004 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19186 AND `item`=82344 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19186 AND `item`=83094 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19186 AND `item`=82343 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=19186 AND `item`=83095 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18484 AND `item`=39354 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=18484 AND `item`=90146 AND `ExtendedCost`=0 AND `type`=1);
544 INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
545 (19053, 9, 4499, 0, 0, 1, 0, 0, 26124), -- Huge Brown Sack
546 (19053, 8, 27855, 0, 0, 1, 0, 0, 26124), -- Mag'har Grainbread
547 (19053, 7, 28399, 0, 0, 1, 0, 0, 26124), -- Filtered Draenic Water
548 (19053, 6, 159, 0, 0, 1, 0, 0, 26124), -- Refreshing Spring Water
549 (19042, 8, 39505, 0, 0, 1, 0, 0, 26124), -- Virtuoso Inking Set
550 (19042, 7, 20815, 0, 0, 1, 0, 0, 26124), -- Jeweler's Kit
551 (19042, 6, 39354, 0, 0, 1, 0, 0, 26124), -- Light Parchment
552 (19042, 4, 3371, 0, 0, 1, 0, 0, 26124), -- Crystal Vial
553 (19234, 1, 38682, 0, 0, 1, 0, 0, 26124), -- Enchanting Vellum
554 (19235, 1, 64670, 0, 0, 1, 0, 0, 26124), -- Vanishing Powder
555 (19245, 9, 82344, 0, 0, 1, 0, 0, 26124), -- Hearthglen Ambrosia
556 (19245, 8, 83094, 0, 0, 1, 0, 0, 26124), -- Foote Tripel
557 (19245, 7, 82343, 0, 0, 1, 0, 0, 26124), -- Lordaeron Lambic
558 (19245, 6, 83095, 0, 0, 1, 0, 0, 26124), -- Lagrave Stout
559 (33634, 13, 39354, 0, 0, 1, 0, 0, 26124), -- Light Parchment
560 (33634, 3, 90146, 0, 0, 1, 0, 0, 26124), -- Tinker's Kit
561 (33630, 4, 4565, 0, 0, 1, 0, 0, 26124), -- Simple Dagger
562 (33630, 3, 64670, 0, 0, 1, 0, 0, 26124), -- Vanishing Powder
563 (19239, 3, 4565, 0, 0, 1, 0, 0, 26124), -- Simple Dagger
564 (33640, 2, 30746, 0, 0, 1, 0, 0, 26124), -- Mining Sack
565 (33637, 2, 52188, 0, 0, 1, 0, 0, 26124), -- Jeweler's Setting
566 (33633, 11, 64670, 0, 0, 1, 0, 0, 26124), -- Vanishing Powder
567 (33633, 3, 10940, 2, 0, 1, 0, 0, 26124), -- Strange Dust
568 (33633, 1, 38682, 0, 0, 1, 0, 0, 26124), -- Enchanting Vellum
569 (33638, 6, 79740, 0, 0, 1, 0, 0, 26124), -- Plain Wooden Staff
570 (33638, 5, 1515, 0, 0, 1, 0, 0, 26124), -- Rough Wooden Staff
571 (33638, 1, 64670, 0, 0, 1, 0, 0, 26124), -- Vanishing Powder
572 (19244, 28, 39505, 0, 0, 1, 0, 0, 26124), -- Virtuoso Inking Set
573 (19244, 27, 20815, 0, 0, 1, 0, 0, 26124), -- Jeweler's Kit
574 (19244, 3, 85663, 0, 0, 1, 0, 0, 26124), -- Herbalist's Spade
575 (18525, 125, 35326, 0, 0, 1, 0, 0, 26124), -- Battlemaster's Alacrity
576 (18525, 124, 34162, 0, 0, 1, 0, 0, 26124), -- Battlemaster's Depravity
577 (18525, 123, 34163, 0, 0, 1, 0, 0, 26124), -- Battlemaster's Cruelty
578 (18525, 122, 34049, 0, 0, 1, 0, 0, 26124), -- Battlemaster's Audacity
579 (18525, 121, 34050, 0, 0, 1, 0, 0, 26124), -- Battlemaster's Perseverance
580 (18525, 120, 33832, 0, 0, 1, 0, 0, 26124), -- Battlemaster's Determination
581 (18525, 119, 33296, 0, 0, 1, 0, 0, 26124), -- Brooch of Deftness
582 (18525, 118, 33192, 0, 0, 1, 0, 0, 26124), -- Carved Witch Doctor's Stick
583 (18525, 117, 33325, 0, 0, 1, 0, 0, 26124), -- Voodoo Shaker
584 (18525, 116, 33334, 0, 0, 1, 0, 0, 26124), -- Fetish of the Primal Gods
585 (18525, 115, 33484, 0, 0, 1, 0, 0, 26124), -- Dory's Embrace
586 (18525, 114, 35321, 0, 0, 1, 0, 0, 26124), -- Cloak of Arcane Alacrity
587 (18525, 113, 33304, 0, 0, 1, 0, 0, 26124), -- Cloak of Subjugated Power
588 (18525, 112, 35324, 0, 0, 1, 0, 0, 26124), -- Cloak of Swift Reprieve
589 (18525, 111, 33333, 0, 0, 1, 0, 0, 26124), -- Kharmaa's Shroud of Hope
590 (18525, 110, 33593, 0, 0, 1, 0, 0, 26124), -- Slikk's Cloak of Placation
591 (18525, 109, 33589, 0, 0, 1, 0, 0, 26124), -- Wristguards of Tranquil Thought
592 (18525, 108, 33587, 0, 0, 1, 0, 0, 26124), -- Light-Blessed Bonds
593 (18525, 107, 33585, 0, 0, 1, 0, 0, 26124), -- Achromic Trousers of the Naaru
594 (18525, 106, 33291, 0, 0, 1, 0, 0, 26124), -- Voodoo-Woven Belt
595 (18525, 105, 33586, 0, 0, 1, 0, 0, 26124), -- Studious Wraps
596 (18525, 104, 33584, 0, 0, 1, 0, 0, 26124), -- Pantaloons of Arcane Annihilation
597 (18525, 103, 33588, 0, 0, 1, 0, 0, 26124), -- Runed Spell-Cuffs
598 (18525, 102, 33583, 0, 0, 1, 0, 0, 26124), -- Waistguard of the Great Beast
599 (18525, 101, 33579, 0, 0, 1, 0, 0, 26124), -- Vestments of Hibernation
600 (18525, 100, 33972, 0, 0, 1, 0, 0, 26124), -- Mask of Primal Power
601 (18525, 99, 33559, 0, 0, 1, 0, 0, 26124), -- Starfire Waistband
602 (18525, 98, 33973, 0, 0, 1, 0, 0, 26124), -- Pauldrons of Tribal Fury
603 (18525, 97, 33974, 0, 0, 1, 0, 0, 26124), -- Grasp of the Moonkin
604 (18525, 96, 33557, 0, 0, 1, 0, 0, 26124), -- Gargon's Bracers of Peaceful Slumber
605 (18525, 95, 33552, 0, 0, 1, 0, 0, 26124), -- Pants of Splendid Recovery
606 (18525, 94, 33287, 0, 0, 1, 0, 0, 26124), -- Gnarled Ironwood Pauldrons
607 (18525, 93, 33577, 0, 0, 1, 0, 0, 26124), -- Moon-Walkers
608 (18525, 92, 33582, 0, 0, 1, 0, 0, 26124), -- Footwraps of Wild Encroachment
609 (18525, 91, 33566, 0, 0, 1, 0, 0, 26124), -- Blessed Elunite Coverings
610 (18525, 90, 33580, 0, 0, 1, 0, 0, 26124), -- Band of the Swift Paw
611 (18525, 89, 33578, 0, 0, 1, 0, 0, 26124), -- Armwraps of the Kaldorei Protector
612 (18525, 88, 33539, 0, 0, 1, 0, 0, 26124), -- Trickster's Stickyfingers
613 (18525, 87, 33222, 0, 0, 1, 0, 0, 26124), -- Nyn'jah's Tabi Boots
614 (18525, 86, 33538, 0, 0, 1, 0, 0, 26124), -- Shallow-Grave Trousers
615 (18525, 85, 33540, 0, 0, 1, 0, 0, 26124), -- Master Assassin Wristwraps
616 (18525, 84, 33537, 0, 0, 1, 0, 0, 26124), -- Treads of Booming Thunder
617 (18525, 83, 33536, 0, 0, 1, 0, 0, 26124), -- Stormwrap
618 (18525, 82, 33531, 0, 0, 1, 0, 0, 26124), -- Polished Waterscale Gloves
619 (18525, 81, 33324, 0, 0, 1, 0, 0, 26124), -- Treads of the Life Path
620 (18525, 80, 33530, 0, 0, 1, 0, 0, 26124), -- Natural Life Leggings
621 (18525, 79, 33386, 0, 0, 1, 0, 0, 26124), -- Man'kin'do's Belt
622 (18525, 78, 33534, 0, 0, 1, 0, 0, 26124), -- Grips of Nature's Wrath
623 (18525, 77, 33532, 0, 0, 1, 0, 0, 26124), -- Gleaming Earthen Bracers
624 (18525, 76, 33970, 0, 0, 1, 0, 0, 26124), -- Pauldrons of the Furious Elements
625 (18525, 75, 33965, 0, 0, 1, 0, 0, 26124), -- Hauberk of the Furious Elements
626 (18525, 74, 33535, 0, 0, 1, 0, 0, 26124), -- Earthquake Bracers
627 (18525, 73, 33529, 0, 0, 1, 0, 0, 26124), -- Steadying Bracers
628 (18525, 72, 33280, 0, 0, 1, 0, 0, 26124), -- War-Feathered Loop
629 (18525, 71, 33527, 0, 0, 1, 0, 0, 26124), -- Shifting Camouflage Pants
630 (18525, 70, 33528, 0, 0, 1, 0, 0, 26124), -- Gauntlets of Sniping
631 (18525, 69, 33520, 0, 0, 1, 0, 0, 26124), -- Vambraces of the Naaru
632 (18525, 68, 33523, 0, 0, 1, 0, 0, 26124), -- Sabatons of the Righteous Defender
633 (18525, 67, 33207, 0, 0, 1, 0, 0, 26124), -- Implacable Guardian Sabatons
634 (18525, 66, 33518, 0, 0, 1, 0, 0, 26124), -- High Justicar's Legplates
635 (18525, 65, 33519, 0, 0, 1, 0, 0, 26124), -- Handguards of the Templar
636 (18525, 64, 33524, 0, 0, 1, 0, 0, 26124), -- Girdle of the Protector
637 (18525, 63, 33522, 0, 0, 1, 0, 0, 26124), -- Chestguard of the Stoic Guardian
638 (18525, 62, 33515, 0, 0, 1, 0, 0, 26124), -- Unwavering Legguards
639 (18525, 61, 33514, 0, 0, 1, 0, 0, 26124), -- Pauldrons of Gruesome Fate
640 (18525, 60, 33512, 0, 0, 1, 0, 0, 26124), -- Furious Deathgrips
641 (18525, 59, 33331, 0, 0, 1, 0, 0, 26124), -- Chain of Unleashed Rage
642 (18525, 58, 33513, 0, 0, 1, 0, 0, 26124), -- Eternium Rage-Shackles
643 (18525, 57, 33516, 0, 0, 1, 0, 0, 26124), -- Bracers of the Ancient Phalanx
644 (18525, 56, 33279, 0, 0, 1, 0, 0, 26124), -- Iron-Tusk Girdle
645 (18525, 55, 33517, 0, 0, 1, 0, 0, 26124), -- Bonefist Gauntlets
646 (18525, 54, 33501, 0, 0, 1, 0, 0, 26124), -- Bloodthirster's Wargreaves
647 (18525, 53, 33810, 0, 0, 1, 0, 0, 26124), -- Amani Mask of Death
648 (18525, 52, 32090, 0, 0, 1, 0, 0, 26124), -- Cowl of Naaru Blessings
649 (18525, 51, 32089, 0, 0, 1, 0, 0, 26124), -- Mana-Binders Cowl
650 (18525, 50, 32085, 0, 0, 1, 0, 0, 26124), -- Warpstalker Helm
651 (18525, 49, 32086, 0, 0, 1, 0, 0, 26124), -- Storm Master's Helmet
652 (18525, 48, 32087, 0, 0, 1, 0, 0, 26124), -- Mask of the Deceiver
653 (18525, 47, 32088, 0, 0, 1, 0, 0, 26124), -- Cowl of Beastly Rage
654 (18525, 46, 32084, 0, 0, 1, 0, 0, 26124), -- Helmet of the Steadfast Champion
655 (18525, 45, 32083, 0, 0, 1, 0, 0, 26124), -- Faceguard of Determination
656 (18525, 44, 30762, 0, 0, 1, 0, 0, 26124), -- Infernoweave Robe
657 (18525, 43, 30761, 0, 0, 1, 0, 0, 26124), -- Infernoweave Leggings
658 (18525, 42, 30764, 0, 0, 1, 0, 0, 26124), -- Infernoweave Gloves
659 (18525, 41, 30763, 0, 0, 1, 0, 0, 26124), -- Infernoweave Boots
660 (18525, 40, 30766, 0, 0, 1, 0, 0, 26124), -- Inferno Tempered Leggings
661 (18525, 39, 30767, 0, 0, 1, 0, 0, 26124), -- Inferno Tempered Gauntlets
662 (18525, 38, 30769, 0, 0, 1, 0, 0, 26124), -- Inferno Tempered Chestguard
663 (18525, 37, 30768, 0, 0, 1, 0, 0, 26124), -- Inferno Tempered Boots
664 (18525, 36, 30778, 0, 0, 1, 0, 0, 26124), -- Inferno Hardened Leggings
665 (18525, 35, 30780, 0, 0, 1, 0, 0, 26124), -- Inferno Hardened Gloves
666 (18525, 34, 30776, 0, 0, 1, 0, 0, 26124), -- Inferno Hardened Chestguard
667 (18525, 33, 30779, 0, 0, 1, 0, 0, 26124), -- Inferno Hardened Boots
668 (18525, 32, 30772, 0, 0, 1, 0, 0, 26124), -- Inferno Forged Leggings
669 (18525, 31, 30773, 0, 0, 1, 0, 0, 26124), -- Inferno Forged Hauberk
670 (18525, 30, 30774, 0, 0, 1, 0, 0, 26124), -- Inferno Forged Gloves
671 (18525, 29, 30770, 0, 0, 1, 0, 0, 26124), -- Inferno Forged Boots
672 (18525, 28, 30183, 0, 0, 1, 0, 0, 26124), -- Nether Vortex
673 (18525, 27, 23572, 0, 0, 1, 0, 0, 26124), -- Primal Nether
674 (18525, 26, 29387, 0, 0, 1, 0, 0, 26124), -- Gnomeregan Auto-Dodger 600
675 (18525, 25, 29383, 0, 0, 1, 0, 0, 26124), -- Bloodlust Brooch
676 (18525, 24, 29376, 0, 0, 1, 0, 0, 26124), -- Essence of the Martyr
677 (18525, 23, 29370, 0, 0, 1, 0, 0, 26124), -- Icon of the Silver Crescent
678 (18525, 22, 29385, 0, 0, 1, 0, 0, 26124), -- Farstrider Defender's Cloak
679 (18525, 21, 29382, 0, 0, 1, 0, 0, 26124), -- Blood Knight War Cloak
680 (18525, 20, 29375, 0, 0, 1, 0, 0, 26124), -- Bishop's Cloak
681 (18525, 19, 29369, 0, 0, 1, 0, 0, 26124), -- Shawl of Shifting Probabilities
682 (18525, 18, 29386, 0, 0, 1, 0, 0, 26124), -- Necklace of the Juggernaut
683 (18525, 17, 29381, 0, 0, 1, 0, 0, 26124), -- Choker of Vile Intent
684 (18525, 16, 29374, 0, 0, 1, 0, 0, 26124), -- Necklace of Eternal Hope
685 (18525, 15, 29368, 0, 0, 1, 0, 0, 26124), -- Manasurge Pendant
686 (18525, 14, 29384, 0, 0, 1, 0, 0, 26124), -- Ring of Unyielding Force
687 (18525, 13, 29379, 0, 0, 1, 0, 0, 26124), -- Ring of Arathi Warlords
688 (18525, 12, 29373, 0, 0, 1, 0, 0, 26124), -- Band of Halos
689 (18525, 11, 29367, 0, 0, 1, 0, 0, 26124), -- Ring of Cryptic Dreams
690 (18525, 10, 29266, 0, 0, 1, 0, 0, 26124), -- Azure-Shield of Coldarra
691 (18525, 9, 29272, 0, 0, 1, 0, 0, 26124), -- Orb of the Soul-Eater
692 (18525, 8, 29267, 0, 0, 1, 0, 0, 26124), -- Light-Bearer's Faith Shield
693 (18525, 7, 29274, 0, 0, 1, 0, 0, 26124), -- Tears of Heaven
694 (18525, 6, 29269, 0, 0, 1, 0, 0, 26124), -- Sapphiron's Wing Bone
695 (18525, 5, 29270, 0, 0, 1, 0, 0, 26124), -- Flametongue Seal
696 (18525, 4, 29275, 0, 0, 1, 0, 0, 26124), -- Searing Sunblade
697 (18525, 3, 29268, 0, 0, 1, 0, 0, 26124), -- Mazthoril Honor Shield
698 (18525, 2, 29271, 0, 0, 1, 0, 0, 26124), -- Talisman of Kalecgos
699 (18525, 1, 29273, 0, 0, 1, 0, 0, 26124), -- Khadgar's Knapsack
700 (27667, 62, 34952, 0, 0, 1, 0, 0, 26124), -- The Mutilator
701 (27667, 61, 34949, 0, 0, 1, 0, 0, 26124), -- Swift Blade of Uncertainty
702 (27667, 60, 34894, 0, 0, 1, 0, 0, 26124), -- Blade of Serration
703 (27667, 59, 34951, 0, 0, 1, 0, 0, 26124), -- Vanir's Fist of Carnage
704 (27667, 58, 34950, 0, 0, 1, 0, 0, 26124), -- Vanir's Fist of Savagery
705 (27667, 57, 34893, 0, 0, 1, 0, 0, 26124), -- Vanir's Fist of Brutality
706 (27667, 56, 34896, 0, 0, 1, 0, 0, 26124), -- Gavel of Naaru Blessings
707 (27667, 55, 34898, 0, 0, 1, 0, 0, 26124), -- Staff of the Forest Lord
708 (27667, 54, 34892, 0, 0, 1, 0, 0, 26124), -- Crossbow of Relentless Strikes
709 (27667, 53, 34895, 0, 0, 1, 0, 0, 26124), -- Scryer's Blade of Focus
710 (27667, 52, 34891, 0, 0, 1, 0, 0, 26124), -- The Blade of Harbingers
711 (27667, 51, 34888, 0, 0, 1, 0, 0, 26124), -- Ring of the Stalwart Protector
712 (27667, 50, 34887, 0, 0, 1, 0, 0, 26124), -- Angelista's Revenge
713 (27667, 49, 34890, 0, 0, 1, 0, 0, 26124), -- Anveena's Touch
714 (27667, 48, 34889, 0, 0, 1, 0, 0, 26124), -- Fused Nethergon Band
715 (27667, 47, 34940, 0, 0, 1, 0, 0, 26124), -- Sunguard Legplates
716 (27667, 46, 34939, 0, 0, 1, 0, 0, 26124), -- Chestplate of Stoicism
717 (27667, 45, 34941, 0, 0, 1, 0, 0, 26124), -- Girdle of the Fearless
718 (27667, 44, 34943, 0, 0, 1, 0, 0, 26124), -- Legplates of Unending Fury
719 (27667, 43, 34942, 0, 0, 1, 0, 0, 26124), -- Breastplate of Ire
720 (27667, 42, 34944, 0, 0, 1, 0, 0, 26124), -- Girdle of Seething Rage
721 (27667, 41, 34946, 0, 0, 1, 0, 0, 26124), -- Inscribed Legplates of the Aldor
722 (27667, 40, 34945, 0, 0, 1, 0, 0, 26124), -- Shattrath Protectorate's Breastplate
723 (27667, 39, 34947, 0, 0, 1, 0, 0, 26124), -- Blue's Greaves of the Righteous Guardian
724 (27667, 38, 34922, 0, 0, 1, 0, 0, 26124), -- Greaves of Pacification
725 (27667, 37, 34921, 0, 0, 1, 0, 0, 26124), -- Ecclesiastical Cuirass
726 (27667, 36, 34923, 0, 0, 1, 0, 0, 26124), -- Waistguard of Reparation
727 (27667, 35, 34934, 0, 0, 1, 0, 0, 26124), -- Rushing Storm Kilt
728 (27667, 34, 34933, 0, 0, 1, 0, 0, 26124), -- Hauberk of Whirling Fury
729 (27667, 33, 34935, 0, 0, 1, 0, 0, 26124), -- Aftershock Waistguard
730 (27667, 32, 34931, 0, 0, 1, 0, 0, 26124), -- Runed Scales of Antiquity
731 (27667, 31, 34930, 0, 0, 1, 0, 0, 26124), -- Wave of Life Chestguard
732 (27667, 30, 34932, 0, 0, 1, 0, 0, 26124), -- Clutch of the Soothing Breeze
733 (27667, 29, 34914, 0, 0, 1, 0, 0, 26124), -- Leggings of the Pursuit
734 (27667, 28, 34916, 0, 0, 1, 0, 0, 26124), -- Gauntlets of Rapidity
735 (27667, 27, 34912, 0, 0, 1, 0, 0, 26124), -- Scaled Drakeskin Chestguard
736 (27667, 26, 34928, 0, 0, 1, 0, 0, 26124), -- Trousers of the Scryers' Retainer
737 (27667, 25, 34927, 0, 0, 1, 0, 0, 26124), -- Tunic of the Dark Hour
738 (27667, 24, 34929, 0, 0, 1, 0, 0, 26124), -- Belt of the Silent Path
739 (27667, 23, 34905, 0, 0, 1, 0, 0, 26124), -- Crystalwind Leggings
740 (27667, 22, 34904, 0, 0, 1, 0, 0, 26124), -- Barbed Gloves of the Sage
741 (27667, 21, 34903, 0, 0, 1, 0, 0, 26124), -- Embrace of Starlight
742 (27667, 20, 34910, 0, 0, 1, 0, 0, 26124), -- Tameless Breeches
743 (27667, 19, 34911, 0, 0, 1, 0, 0, 26124), -- Handwraps of the Aggressor
744 (27667, 18, 34906, 0, 0, 1, 0, 0, 26124), -- Embrace of Everlasting Prowess
745 (27667, 17, 34901, 0, 0, 1, 0, 0, 26124), -- Grovewalker's Leggings
746 (27667, 16, 34902, 0, 0, 1, 0, 0, 26124), -- Oakleaf-Spun Handguards
747 (27667, 15, 34900, 0, 0, 1, 0, 0, 26124), -- Shroud of Nature's Harmony
748 (27667, 14, 34936, 0, 0, 1, 0, 0, 26124), -- Tormented Demonsoul Robes
749 (27667, 13, 34937, 0, 0, 1, 0, 0, 26124), -- Corrupted Soulcloth Pantaloons
750 (27667, 12, 34938, 0, 0, 1, 0, 0, 26124), -- Enslaved Doomguard Soulgrips
751 (27667, 11, 34924, 0, 0, 1, 0, 0, 26124), -- Gown of Spiritual Wonder
752 (27667, 10, 34925, 0, 0, 1, 0, 0, 26124), -- Adorned Supernal Legwraps
753 (27667, 9, 34926, 0, 0, 1, 0, 0, 26124), -- Slippers of Dutiful Mending
754 (27667, 8, 34917, 0, 0, 1, 0, 0, 26124), -- Shroud of the Lore`nial
755 (27667, 7, 34918, 0, 0, 1, 0, 0, 26124), -- Legwraps of Sweltering Flame
756 (27667, 6, 34919, 0, 0, 1, 0, 0, 26124), -- Boots of Incantations
757 (52278, 18, 15198, 0, 5962, 1, 0, 0, 26124), -- Knight's Colors
758 (52278, 17, 15196, 0, 5962, 1, 0, 0, 26124), -- Private's Tabard
759 (52278, 16, 19032, 0, 5992, 1, 0, 0, 26124), -- Stormpike Battle Tabard
760 (52278, 15, 19506, 0, 5992, 1, 0, 0, 26124), -- Silverwing Battle Tabard
761 (52278, 14, 31774, 0, 0, 1, 0, 0, 26124), -- Kurenai Tabard
762 (52278, 13, 23999, 0, 0, 1, 0, 0, 26124), -- Honor Hold Tabard
763 (19049, 1, 4565, 0, 0, 1, 0, 0, 26124), -- Simple Dagger
764 (19197, 12, 39505, 0, 0, 1, 0, 0, 26124), -- Virtuoso Inking Set
765 (19197, 11, 20815, 0, 0, 1, 0, 0, 26124), -- Jeweler's Kit
766 (19197, 10, 39354, 0, 0, 1, 0, 0, 26124), -- Light Parchment
767 (19678, 1, 64670, 0, 0, 1, 0, 0, 26124), -- Vanishing Powder
768 (19661, 2129, 39354, 0, 0, 1, 0, 0, 26124), -- Light Parchment
769 (19661, 2125, 90146, 0, 0, 1, 0, 0, 26124), -- Tinker's Kit
770 (19227, 11, 74918, 0, 0, 1, 0, 0, 26124), -- Problem Solving Pendant
771 (18756, 5032, 134007, 0, 0, 1, 0, 0, 26124), -- Eternal Black Diamond Ring
772 (18756, 5029, 134004, 1, 0, 1, 0, 0, 26124), -- Noble's Eternal Elementium Signet
773 (19186, 11, 82344, 0, 0, 1, 0, 0, 26124), -- Hearthglen Ambrosia
774 (19186, 10, 83094, 0, 0, 1, 0, 0, 26124), -- Foote Tripel
775 (19186, 9, 82343, 0, 0, 1, 0, 0, 26124), -- Lordaeron Lambic
776 (19186, 8, 83095, 0, 0, 1, 0, 0, 26124), -- Lagrave Stout
777 (18484, 3953, 39354, 0, 0, 1, 0, 0, 26124), -- Light Parchment
778 (18484, 3942, 90146, 0, 0, 1, 0, 0, 26124); -- Tinker's Kit
779
780 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=19056 AND `item`=3857 AND `ExtendedCost`=0 AND `type`=1); -- Coal
781 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=19056 AND `item`=18567 AND `ExtendedCost`=0 AND `type`=1); -- Elemental Flux
782 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=19056 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1); -- Strong Flux
783 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=19056 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1); -- Weak Flux
784 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=19056 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1); -- Blacksmith Hammer
785 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=19056 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1); -- Mining Pick
786 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19038 AND `item`=29451 AND `ExtendedCost`=0 AND `type`=1); -- Clefthoof Ribs
787 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19038 AND `item`=27854 AND `ExtendedCost`=0 AND `type`=1); -- Smoked Talbuk Venison
788 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19038 AND `item`=8952 AND `ExtendedCost`=0 AND `type`=1); -- Roasted Quail
789 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19038 AND `item`=29449 AND `ExtendedCost`=0 AND `type`=1); -- Bladespire Bagel
790 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19038 AND `item`=27855 AND `ExtendedCost`=0 AND `type`=1); -- Mag'har Grainbread
791 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19038 AND `item`=8950 AND `ExtendedCost`=0 AND `type`=1); -- Homemade Cherry Pie
792 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19038 AND `item`=27692 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Warp Burger
793 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19038 AND `item`=27690 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Blackened Basilisk
794 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28557 AND `ExtendedCost`=298 AND `type`=1); -- Quickened Starfire Diamond
795 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28556 AND `ExtendedCost`=298 AND `type`=1); -- Swift Windfire Diamond
796 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28759 AND `ExtendedCost`=194 AND `type`=1); -- Exorcist's Dreadweave Hood
797 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28760 AND `ExtendedCost`=194 AND `type`=1); -- Exorcist's Silk Hood
798 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28575 AND `ExtendedCost`=194 AND `type`=1); -- Exorcist's Wyrmhide Helm
799 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28574 AND `ExtendedCost`=194 AND `type`=1); -- Exorcist's Dragonhide Helm
800 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28561 AND `ExtendedCost`=194 AND `type`=1); -- Exorcist's Leather Helm
801 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28758 AND `ExtendedCost`=194 AND `type`=1); -- Exorcist's Mail Helm
802 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28577 AND `ExtendedCost`=194 AND `type`=1); -- Exorcist's Linked Helm
803 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28576 AND `ExtendedCost`=194 AND `type`=1); -- Exorcist's Chain Helm
804 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28761 AND `ExtendedCost`=194 AND `type`=1); -- Exorcist's Scaled Helm
805 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28560 AND `ExtendedCost`=194 AND `type`=1); -- Exorcist's Lamellar Helm
806 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28559 AND `ExtendedCost`=194 AND `type`=1); -- Exorcist's Plate Helm
807 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28555 AND `ExtendedCost`=293 AND `type`=1); -- Seal of the Exorcist
808 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=28553 AND `ExtendedCost`=293 AND `type`=1); -- Band of the Exorcist
809 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=32948 AND `ExtendedCost`=1992 AND `type`=1); -- Auchenai Mana Potion
810 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=19773 AND `item`=32947 AND `ExtendedCost`=1992 AND `type`=1); -- Auchenai Healing Potion
811 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=19296 AND `item`=29448 AND `ExtendedCost`=0 AND `type`=1); -- Mag'har Mild Cheese
812 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=19296 AND `item`=27857 AND `ExtendedCost`=0 AND `type`=1); -- Garadar Sharp
813 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=19296 AND `item`=8932 AND `ExtendedCost`=0 AND `type`=1); -- Alterac Swiss
814 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=19296 AND `item`=29452 AND `ExtendedCost`=0 AND `type`=1); -- Zangar Trout
815 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=19296 AND `item`=27858 AND `ExtendedCost`=0 AND `type`=1); -- Sunspring Carp
816 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=19296 AND `item`=8957 AND `ExtendedCost`=0 AND `type`=1); -- Spinefin Halibut
817 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=19296 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
818 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=19296 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
819 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=19296 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
820 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=19296 AND `item`=27700 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Spicy Crawdad
821 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=19296 AND `item`=27699 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Golden Fish Sticks
822 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=24905 AND `item`=37460 AND `ExtendedCost`=0 AND `type`=1); -- Rope Pet Leash
823 UPDATE `npc_vendor` SET `slot`=35, `VerifiedBuild`=26124 WHERE (`entry`=19053 AND `item`=30745 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Toolbox
824 UPDATE `npc_vendor` SET `slot`=34, `VerifiedBuild`=26124 WHERE (`entry`=19053 AND `item`=30746 AND `ExtendedCost`=0 AND `type`=1); -- Mining Sack
825 UPDATE `npc_vendor` SET `slot`=33, `VerifiedBuild`=26124 WHERE (`entry`=19053 AND `item`=30747 AND `ExtendedCost`=0 AND `type`=1); -- Gem Pouch
826 UPDATE `npc_vendor` SET `slot`=32, `VerifiedBuild`=26124 WHERE (`entry`=19053 AND `item`=30748 AND `ExtendedCost`=0 AND `type`=1); -- Enchanter's Satchel
827 UPDATE `npc_vendor` SET `slot`=31, `VerifiedBuild`=26124 WHERE (`entry`=19053 AND `item`=30744 AND `ExtendedCost`=0 AND `type`=1); -- Draenic Leather Pack
828 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=19053 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
829 UPDATE `npc_vendor` SET `slot`=18, `VerifiedBuild`=26124 WHERE (`entry`=19042 AND `item`=22911 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Major Dreamless Sleep Potion
830 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=19042 AND `item`=22901 AND `ExtendedCost`=0 AND `type`=1); -- Recipe: Sneaking Potion
831 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=19042 AND `item`=6532 AND `ExtendedCost`=0 AND `type`=1); -- Bright Baubles
832 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=19042 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1); -- Rune Thread
833 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=19234 AND `item`=22307 AND `ExtendedCost`=0 AND `type`=1); -- Pattern: Enchanted Mageweave Pouch
834 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=19234 AND `item`=20753 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Lesser Wizard Oil
835 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=19234 AND `item`=20752 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Minor Mana Oil
836 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=19234 AND `item`=20758 AND `ExtendedCost`=0 AND `type`=1); -- Formula: Minor Wizard Oil
837 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=19234 AND `item`=11291 AND `ExtendedCost`=0 AND `type`=1); -- Star Wood
838 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=19234 AND `item`=4470 AND `ExtendedCost`=0 AND `type`=1); -- Simple Wood
839 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=19234 AND `item`=10938 AND `ExtendedCost`=0 AND `type`=1); -- Lesser Magic Essence
840 UPDATE `npc_vendor` SET `slot`=3, `maxcount`=2, `VerifiedBuild`=26124 WHERE (`entry`=19234 AND `item`=10940 AND `ExtendedCost`=0 AND `type`=1); -- Strange Dust
841 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=19234 AND `item`=6217 AND `ExtendedCost`=0 AND `type`=1); -- Copper Rod
842 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=19245 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
843 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=19245 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
844 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=19245 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
845 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19245 AND `item`=2595 AND `ExtendedCost`=0 AND `type`=1); -- Jug of Badlands Bourbon
846 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19245 AND `item`=2594 AND `ExtendedCost`=0 AND `type`=1); -- Flagon of Dwarven Mead
847 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19245 AND `item`=2596 AND `ExtendedCost`=0 AND `type`=1); -- Skin of Dwarven Stout
848 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19245 AND `item`=2593 AND `ExtendedCost`=0 AND `type`=1); -- Flask of Stormwind Tawny
849 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19245 AND `item`=2723 AND `ExtendedCost`=0 AND `type`=1); -- Bottle of Dalaran Noir
850 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=21905 AND `item`=30196 AND `ExtendedCost`=1357 AND `type`=1); -- Robes of Tirisfal
851 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=21905 AND `item`=30210 AND `ExtendedCost`=1361 AND `type`=1); -- Mantle of Tirisfal
852 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=21905 AND `item`=30207 AND `ExtendedCost`=1360 AND `type`=1); -- Leggings of Tirisfal
853 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=21905 AND `item`=30205 AND `ExtendedCost`=1358 AND `type`=1); -- Gloves of Tirisfal
854 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=21905 AND `item`=30206 AND `ExtendedCost`=1359 AND `type`=1); -- Cowl of Tirisfal
855 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=20613 AND `item`=29079 AND `ExtendedCost`=1219 AND `type`=1); -- Pauldrons of the Aldor
856 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=20613 AND `item`=29078 AND `ExtendedCost`=1218 AND `type`=1); -- Legwraps of the Aldor
857 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=20613 AND `item`=29076 AND `ExtendedCost`=1217 AND `type`=1); -- Collar of the Aldor
858 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=20613 AND `item`=29080 AND `ExtendedCost`=1216 AND `type`=1); -- Gloves of the Aldor
859 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=20613 AND `item`=29077 AND `ExtendedCost`=1215 AND `type`=1); -- Vestments of the Aldor
860 UPDATE `npc_vendor` SET `slot`=12, `maxcount`=2, `VerifiedBuild`=26124 WHERE (`entry`=33634 AND `item`=4364 AND `ExtendedCost`=0 AND `type`=1); -- Coarse Blasting Powder
861 UPDATE `npc_vendor` SET `slot`=11, `maxcount`=2, `VerifiedBuild`=26124 WHERE (`entry`=33634 AND `item`=4357 AND `ExtendedCost`=0 AND `type`=1); -- Rough Blasting Powder
862 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=33634 AND `item`=10647 AND `ExtendedCost`=0 AND `type`=1); -- Engineer's Ink
863 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=33634 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1); -- Strong Flux
864 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=33634 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1); -- Weak Flux
865 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=33634 AND `item`=39684 AND `ExtendedCost`=0 AND `type`=1); -- Hair Trigger
866 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=33634 AND `item`=40533 AND `ExtendedCost`=0 AND `type`=1); -- Walnut Stock
867 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=33634 AND `item`=4400 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Stock
868 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=33634 AND `item`=4399 AND `ExtendedCost`=0 AND `type`=1); -- Wooden Stock
869 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=33634 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1); -- Mining Pick
870 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=33634 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1); -- Blacksmith Hammer
871 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=33631 AND `item`=3857 AND `ExtendedCost`=0 AND `type`=1); -- Coal
872 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=33631 AND `item`=18567 AND `ExtendedCost`=0 AND `type`=1); -- Elemental Flux
873 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=33631 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1); -- Strong Flux
874 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=33631 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1); -- Weak Flux
875 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=33631 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1); -- Blacksmith Hammer
876 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=33631 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1); -- Mining Pick
877 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=10290 AND `ExtendedCost`=0 AND `type`=1); -- Pink Dye
878 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=4342 AND `ExtendedCost`=0 AND `type`=1); -- Purple Dye
879 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=6261 AND `ExtendedCost`=0 AND `type`=1); -- Orange Dye
880 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=4341 AND `ExtendedCost`=0 AND `type`=1); -- Yellow Dye
881 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=4340 AND `ExtendedCost`=0 AND `type`=1); -- Gray Dye
882 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=2605 AND `ExtendedCost`=0 AND `type`=1); -- Green Dye
883 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=2604 AND `ExtendedCost`=0 AND `type`=1); -- Red Dye
884 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=6260 AND `ExtendedCost`=0 AND `type`=1); -- Blue Dye
885 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=2325 AND `ExtendedCost`=0 AND `type`=1); -- Black Dye
886 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=38426 AND `ExtendedCost`=0 AND `type`=1); -- Eternium Thread
887 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1); -- Rune Thread
888 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=8343 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Silken Thread
889 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=4291 AND `ExtendedCost`=0 AND `type`=1); -- Silken Thread
890 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=2321 AND `ExtendedCost`=0 AND `type`=1); -- Fine Thread
891 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=2320 AND `ExtendedCost`=0 AND `type`=1); -- Coarse Thread
892 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=4289 AND `ExtendedCost`=0 AND `type`=1); -- Salt
893 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=33635 AND `item`=7005 AND `ExtendedCost`=0 AND `type`=1); -- Skinning Knife
894 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=10290 AND `ExtendedCost`=0 AND `type`=1); -- Pink Dye
895 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=4342 AND `ExtendedCost`=0 AND `type`=1); -- Purple Dye
896 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=2325 AND `ExtendedCost`=0 AND `type`=1); -- Black Dye
897 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=6261 AND `ExtendedCost`=0 AND `type`=1); -- Orange Dye
898 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=4340 AND `ExtendedCost`=0 AND `type`=1); -- Gray Dye
899 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=4341 AND `ExtendedCost`=0 AND `type`=1); -- Yellow Dye
900 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=2605 AND `ExtendedCost`=0 AND `type`=1); -- Green Dye
901 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=6260 AND `ExtendedCost`=0 AND `type`=1); -- Blue Dye
902 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=2604 AND `ExtendedCost`=0 AND `type`=1); -- Red Dye
903 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=2324 AND `ExtendedCost`=0 AND `type`=1); -- Bleach
904 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=38426 AND `ExtendedCost`=0 AND `type`=1); -- Eternium Thread
905 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=14341 AND `ExtendedCost`=0 AND `type`=1); -- Rune Thread
906 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=8343 AND `ExtendedCost`=0 AND `type`=1); -- Heavy Silken Thread
907 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=4291 AND `ExtendedCost`=0 AND `type`=1); -- Silken Thread
908 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=2321 AND `ExtendedCost`=0 AND `type`=1); -- Fine Thread
909 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=33636 AND `item`=2320 AND `ExtendedCost`=0 AND `type`=1); -- Coarse Thread
910 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=33630 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1); -- Crystal Vial
911 UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=26124 WHERE (`entry`=33639 AND `item`=3371 AND `ExtendedCost`=0 AND `type`=1); -- Crystal Vial
912 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=33639 AND `item`=22250 AND `ExtendedCost`=0 AND `type`=1); -- Herb Pouch
913 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19240 AND `item`=2529 AND `ExtendedCost`=0 AND `type`=1); -- Zweihander
914 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19240 AND `item`=2521 AND `ExtendedCost`=0 AND `type`=1); -- Flamberge
915 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19240 AND `item`=2528 AND `ExtendedCost`=0 AND `type`=1); -- Falchion
916 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19240 AND `item`=2520 AND `ExtendedCost`=0 AND `type`=1); -- Broadsword
917 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19240 AND `item`=2534 AND `ExtendedCost`=0 AND `type`=1); -- Rondel
918 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19240 AND `item`=2526 AND `ExtendedCost`=0 AND `type`=1); -- Main Gauche
919 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19236 AND `item`=5239 AND `ExtendedCost`=0 AND `type`=1); -- Blackbone Wand
920 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19236 AND `item`=5238 AND `ExtendedCost`=0 AND `type`=1); -- Pitchwood Wand
921 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19236 AND `item`=5347 AND `ExtendedCost`=0 AND `type`=1); -- Pestilent Wand
922 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19236 AND `item`=5236 AND `ExtendedCost`=0 AND `type`=1); -- Combustible Wand
923 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19236 AND `item`=5211 AND `ExtendedCost`=0 AND `type`=1); -- Dusk Wand
924 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19236 AND `item`=5210 AND `ExtendedCost`=0 AND `type`=1); -- Burning Wand
925 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19236 AND `item`=5209 AND `ExtendedCost`=0 AND `type`=1); -- Gloom Wand
926 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19236 AND `item`=5208 AND `ExtendedCost`=0 AND `type`=1); -- Smoldering Wand
927 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19330 AND `item`=28470 AND `ExtendedCost`=0 AND `type`=1); -- Subtle Amber
928 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19330 AND `item`=28467 AND `ExtendedCost`=0 AND `type`=1); -- Smooth Amber
929 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19330 AND `item`=28468 AND `ExtendedCost`=0 AND `type`=1); -- Rigid Zircon
930 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19330 AND `item`=28464 AND `ExtendedCost`=0 AND `type`=1); -- Sparkling Zircon
931 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19330 AND `item`=28463 AND `ExtendedCost`=0 AND `type`=1); -- Solid Zircon
932 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19330 AND `item`=28459 AND `ExtendedCost`=0 AND `type`=1); -- Delicate Tourmaline
933 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19330 AND `item`=28461 AND `ExtendedCost`=0 AND `type`=1); -- Brilliant Tourmaline
934 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19330 AND `item`=28458 AND `ExtendedCost`=0 AND `type`=1); -- Bold Tourmaline
935 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19239 AND `item`=2534 AND `ExtendedCost`=0 AND `type`=1); -- Rondel
936 UPDATE `npc_vendor` SET `IgnoreFiltering`=1, `VerifiedBuild`=26124 WHERE (`entry`=19239 AND `item`=2526 AND `ExtendedCost`=0 AND `type`=1); -- Main Gauche
937 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=27860 AND `ExtendedCost`=0 AND `type`=1); -- Purified Draenic Water
938 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=28399 AND `ExtendedCost`=0 AND `type`=1); -- Filtered Draenic Water
939 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=8766 AND `ExtendedCost`=0 AND `type`=1); -- Morning Glory Dew
940 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=29448 AND `ExtendedCost`=0 AND `type`=1); -- Mag'har Mild Cheese
941 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=27857 AND `ExtendedCost`=0 AND `type`=1); -- Garadar Sharp
942 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=8932 AND `ExtendedCost`=0 AND `type`=1); -- Alterac Swiss
943 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=29450 AND `ExtendedCost`=0 AND `type`=1); -- Telaari Grapes
944 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=27856 AND `ExtendedCost`=0 AND `type`=1); -- Skethyl Berries
945 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=8953 AND `ExtendedCost`=0 AND `type`=1); -- Deep Fried Plantains
946 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=29449 AND `ExtendedCost`=0 AND `type`=1); -- Bladespire Bagel
947 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=27855 AND `ExtendedCost`=0 AND `type`=1); -- Mag'har Grainbread
948 UPDATE `npc_vendor` SET `VerifiedBuild`=26124 WHERE (`entry`=19232 AND `item`=8950 AND `ExtendedCost`=0 AND `type`=1); -- Homemade Cherry Pie
949 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE (`entry`=33640 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1); -- Jeweler's Kit
950 UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=26124 WHERE (`entry`=33640 AND `item`=3857 AND `ExtendedCost`=0 AND `type`=1); -- Coal
951 UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=26124 WHERE (`entry`=33640 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1); -- Strong Flux
952 UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=26124 WHERE (`entry`=33640 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1); -- Weak Flux
953 UPDATE `npc_vendor` SET `slot`=1, `VerifiedBuild`=26124 WHERE (`entry`=33640 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1); -- Mining Pick
954 UPDATE `npc_vendor` SET `slot`=50, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=49112 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Nightmare Tear
955 UPDATE `npc_vendor` SET `slot`=49, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=47020 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Deft Ametrine
956 UPDATE `npc_vendor` SET `slot`=48, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=47022 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Resolute Ametrine
957 UPDATE `npc_vendor` SET `slot`=47, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=47021 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Lucent Ametrine
958 UPDATE `npc_vendor` SET `slot`=46, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=47019 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Fierce Ametrine
959 UPDATE `npc_vendor` SET `slot`=45, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=47018 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Resplendent Ametrine
960 UPDATE `npc_vendor` SET `slot`=44, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=47017 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Stalwart Ametrine
961 UPDATE `npc_vendor` SET `slot`=43, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=47015 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Champion's Ametrine
962 UPDATE `npc_vendor` SET `slot`=42, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=47010 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Accurate Dreadstone
963 UPDATE `npc_vendor` SET `slot`=41, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=47007 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Reckless Ametrine
964 UPDATE `npc_vendor` SET `slot`=40, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46956 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Glinting Dreadstone
965 UPDATE `npc_vendor` SET `slot`=39, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46953 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Etched Dreadstone
966 UPDATE `npc_vendor` SET `slot`=38, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46952 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Willful Ametrine
967 UPDATE `npc_vendor` SET `slot`=37, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46951 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Veiled Dreadstone
968 UPDATE `npc_vendor` SET `slot`=36, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46950 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Potent Ametrine
969 UPDATE `npc_vendor` SET `slot`=35, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46949 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Deadly Ametrine
970 UPDATE `npc_vendor` SET `slot`=34, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46948 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Inscribed Ametrine
971 UPDATE `npc_vendor` SET `slot`=33, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46943 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Mysterious Dreadstone
972 UPDATE `npc_vendor` SET `slot`=32, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46942 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Guardian's Dreadstone
973 UPDATE `npc_vendor` SET `slot`=31, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46941 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Defender's Dreadstone
974 UPDATE `npc_vendor` SET `slot`=30, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46938 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Shifting Dreadstone
975 UPDATE `npc_vendor` SET `slot`=29, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46937 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Purified Dreadstone
976 UPDATE `npc_vendor` SET `slot`=28, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46935 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Sovereign Dreadstone
977 UPDATE `npc_vendor` SET `slot`=27, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46933 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Quick King's Amber
978 UPDATE `npc_vendor` SET `slot`=26, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46932 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Mystic King's Amber
979 UPDATE `npc_vendor` SET `slot`=25, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46929 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Smooth King's Amber
980 UPDATE `npc_vendor` SET `slot`=24, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46928 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Rigid Majestic Zircon
981 UPDATE `npc_vendor` SET `slot`=23, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46926 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Stormy Majestic Zircon
982 UPDATE `npc_vendor` SET `slot`=22, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46925 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Sparkling Majestic Zircon
983 UPDATE `npc_vendor` SET `slot`=21, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46924 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Solid Majestic Zircon
984 UPDATE `npc_vendor` SET `slot`=20, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46923 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Flashing Cardinal Ruby
985 UPDATE `npc_vendor` SET `slot`=19, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46922 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Subtle King's Amber
986 UPDATE `npc_vendor` SET `slot`=18, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46920 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Precise Cardinal Ruby
987 UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46918 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Delicate Cardinal Ruby
988 UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46917 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Bold Cardinal Ruby
989 UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46916 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Brilliant Cardinal Ruby
990 UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46915 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Turbid Eye of Zul
991 UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46913 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Shattered Eye of Zul
992 UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46912 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Energized Eye of Zul
993 UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46911 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Radiant Eye of Zul
994 UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46909 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Lightning Eye of Zul
995 UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46905 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Misty Eye of Zul
996 UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46904 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Forceful Eye of Zul
997 UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=26124 WHERE (`entry`=33637 AND `item`=46902 AND `ExtendedCost`=2436 AND `type`=1); -- Design: Timeless Dreadstone
998 UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=26124 WHERE