DB/Vendors: removed all non-existing items from vendors

1 files changed, 3 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2025_04_16_02_world.sql b/sql/updates/world/cata_classic/2025_04_16_02_world.sql
new file mode 100644
index 00000000000..e22d975e8f3
--- /dev/null
+++ b/sql/updates/world/cata_classic/2025_04_16_02_world.sql
@@ -0,0 +1,3 @@
+-- Kill all non-existing items from npc_vendor
+DELETE FROM `npc_vendor` WHERE `type`= 1 AND `item` IN (138383, 122338, 136849, 138900, 169448, 104323, 208735, 168058, 124674, 85663, 188152, 136377, 138382, 122339, 136795, 138884, 104324, 183950, 168059, 126928, 79249, 90146, 138384, 122340, 136794, 91003, 95621, 183954, 116828, 168060, 184683, 122387, 138385, 122341, 136789, 95481, 128643, 168061, 126931, 122388, 97921, 151614, 136790, 120983, 138867, 138871, 138869, 138870, 138868, 95482, 188694, 79048, 138990, 164378, 126927, 122381, 83095, 151615, 136787, 79740, 120996, 151268, 157573, 184625, 122355, 82343, 150746, 141041, 151804, 157574, 124671, 122356, 83094, 177062, 150743, 188680, 120982, 151806, 188689, 157576, 120991, 126929, 122379, 82344, 183955, 122378, 116888, 134860, 116848, 151271, 157577, 146617, 184689, 122357, 180733, 122360, 146437, 169461, 116889, 146537, 79254, 116850, 151270, 151117, 120990, 126925, 122380, 120984, 122376, 168915, 141532, 116856, 120995, 146641, 116851, 163045, 151118, 126926, 122382, 81922, 82450, 122377, 81919, 116258, 116891, 116853, 151119, 126930, 122359, 81921, 82451, 81917, 122358, 81920, 116890, 79255, 116854, 151120, 142398, 120985, 81918, 128646, 151116, 122383, 122374, 90426, 128645, 122375, 90427, 164922, 116155, 120994, 128644, 122384, 160298, 164923, 139004, 122350, 164924, 122349, 122372, 82448, 122352, 122373, 137663, 204675, 116648, 167731, 82449, 122354, 116756, 165802, 187997, 122353, 81924, 138796, 116357, 144339, 204336, 122386, 81923, 116358, 142341, 122351, 116757, 116359, 165670, 192099, 122385, 116758, 81889, 122389, 81916, 122362, 138730, 113111, 122361, 166747, 122266, 122363, 127010, 167732, 122260, 122390, 187998, 122261, 122391, 140773, 122262, 122392, 122368, 122263, 122365, 122250, 122249, 122248, 122247, 122246, 127012, 122366, 122245, 122364, 122367, 122369, 120981, 120976, 122264, 120977, 122256, 120980, 122255, 122254, 122253, 122252, 127011, 122251, 122371, 120986, 122530, 89190, 120988, 122663, 89192, 122667, 89194, 122664, 89191, 120987, 122662, 89193, 122668, 89195, 122666, 120993, 120992, 147616, 147615, 147772, 147614, 147613, 147771, 134004, 134007);
+DELETE FROM `npc_vendor` WHERE `type` IN (3, 4);