disable_duplicate_items.sql

-- Select all vanilla items that now have SoD copies
-- SELECT id, item_id, name, required_level, created_at
-- FROM items i1
-- WHERE
--     expansion_id = 4
--     AND item_id < 150000
--     -- AND required_level > 55
--     AND EXISTS (
--         SELECT 1
--         FROM items i2
--         WHERE
--             i2.expansion_id = 4
--             AND i2.id != i1.id
--             AND i2.item_id >= 150000
--             AND i2.name = i1.name
--             -- AND i2.item_id != i1.item_id
--             -- AND i2.required_level > 55
--         LIMIT 1
--     )
-- ORDER BY required_level, item_id ASC;
UPDATE `items`
SET `is_disabled` = 1
WHERE `expansion_id` = 4
AND `item_id` IN (1652,3871,3872,3873,3875,4298,4300,4352,6047,7084,7086,7088,7192,8385,8386,8387,9362,9367,9604,9605,10455,10749,10750,10751,10780,10781,10782,11123,11124,12163,12382,12630,14156,14510,14630,15454,16762,16768,17204,17966,18398,18399,18403,18404,18406,18465,18466,18467,18468,18469,18470,18471,18472,18473,18488,18492,18513,18592,19216,19217,19329,19978,21326,21994,21995,21996,21997,21998,21999,22000,22001,22002,22003,22004,22005,22006,22007,22008,22009,22010,22011,22013,22015,22016,22017,22060,22061,22062,22063,22064,22065,22066,22067,22068,22069,22070,22071,22072,22073,22074,22075,22076,22077,22078,22079,22080,22081,22082,22083,22084,22085,22086,22087,22088,22089,22090,22091,22092,22093,22095,22096,22097,22098,22099,22100,22101,22102,22107,22109,22110,22111,22112,22113,22679,1710,16782,8183,4383,9508,5962,4322,9326,3843,4258,7051,14219,3841,4325,7055,7691,7708,7731,11290,14221,3853,14217,4326,14218,14222,3837,7059,7711,7712,14223,4260,7061,7713,14224,3845,3847,9388,9390,9407,10776,14220,7063,8187,9366,9389,9998,9999,10769,10770,10771,14225,8189,9172,9408,8200,7720,7722,7723,8201,10762,10764,8630,9387,9432,12327,13325,9415,9416,9467,12470,12471,18083,9469,9641,9473,9474,9476,9479,13446,18430,18432,18435,18436,18437,18447,18449,18453,18455,18457,17748,13462,17740,10454,11625,11628,11629,11747,11749,11750,11784,17717,17718,17719,17732,17733,17734,17737,17943,11634,11824,17707,17710,17715,17766,17780,9372,11677,11685,11722,11743,11839,18697,11744,11746,11755,11786,11803,11805,11809,11816,11817,11920,12605,18698,22212,22242,22245,11726,11729,11730,11731,11782,11921,11922,11923,11925,11926,11927,13181,13182,13404,16671,16681,16683,16697,16703,16710,16714,16722,16735,22266,22395,22400,11812,11814,11815,11832,11935,12608,13284,13378,13379,13383,13384,16673,16680,16685,16696,16702,16713,16716,16723,16736,18311,18317,18319,18323,18324,19047,22208,11669,11808,11819,11822,11823,11931,11932,12554,12626,12651,13255,13257,13261,13282,13283,13376,13400,13402,13403,14531,14576,16670,16672,16675,16676,16682,16684,16691,16692,16704,16705,16711,16712,16715,16717,16724,16725,16734,16737,18310,18312,18314,18315,18356,18357,18358,18359,18692,18725,18726,11684,11924,11928,11930,11933,12604,12634,12637,13167,13168,13177,13179,13183,13211,13213,13244,13374,16669,16679,16689,16695,16701,16708,16718,16729,16733,18387,18493,18494,18496,18730,22204,22207,12589,12606,12927,12929,13143,13148,13161,13162,13164,13185,13205,13218,13260,13380,13382,13388,13389,13390,13391,13392,13955,13956,13957,13960,13967,14024,14541,14577,14611,14612,14614,14615,14616,14620,14621,14622,14623,14624,14626,14629,14631,14632,14633,14637,16668,16678,16687,16694,16699,16709,16719,16728,16732,18393,18397,18485,18490,18500,18528,18680,18684,18739,18740,18741,18861,22231,22232,22304,22305,22306,22311,22313,22321,22322,13163,13314,13398,13937,13944,13950,13952,13953,13964,13983,14503,14522,14528,14539,14543,14545,16667,16677,16686,16693,16698,16707,16720,16727,16731,18047,18378,18380,18388,18390,18392,18505,18530,18531,18532,18690,18693,18695,18736,18737,18757,18759,18760,18870,22303,22332,22333,23139,12103,12583,12587,12588,12590,12592,12935,12936,12939,12940,12963,12964,12966,12967,12968,12969,13098,13141,13142,13344,13345,13353,13359,13360,13361,13502,13505,16391,16397,16406,16409,16410,16419,16421,16422,16425,16427,16429,16431,16433,16434,16435,16436,16486,16487,16494,16496,16497,16501,16503,16521,16523,16528,16532,16666,16674,16688,16690,16700,16706,16721,16726,16730,17074,17077,17223,17599,18103,18104,18429,18434,18445,18448,18452,18454,18456,18520,18524,18526,18534,18538,18717,18718,18720,18872,22268,22301,22302,22326,22329,22335,22339,22340,22409,22410,22411,22433,2801,18875,16795,16796,16797,16798,16799,16800,16801,16802,16803,16804,16805,16806,16807,16808,16809,16810,16811,16812,16813,16814,16815,16816,16817,16819,16820,16821,16822,16823,16824,16825,16826,16827,16828,16829,16830,16831,16834,16835,16836,16837,16838,16839,16840,16841,16842,16843,16844,16845,16846,16847,16848,16849,16850,16851,16852,16853,16854,16855,16856,16857,16858,16859,16860,16861,16862,16863,16864,16865,16866,16867,16868,17063,17064,17065,17066,17067,17069,17070,17071,17072,17073,17076,17082,17102,17103,17104,17105,17106,17107,17109,17110,17111,17112,17113,17182,17193,18202,18203,18204,18208,18348,18541,18542,18543,18544,18545,18546,18547,18608,18609,18628,18707,18713,18715,18805,18806,18808,18809,18810,18811,18812,18814,18815,18816,18817,18820,18821,18822,18823,18824,18829,18832,18842,18878,18879,19130,19131,19132,19133,19134,19135,19136,19137,19138,19139,19140,19142,19143,19144,19145,19146,19147,19340,22267,22843,22852,22855,22856,22857,22858,22859,22860,22862,22863,22864,22865,22867,22868,22869,22870,22872,22873,22874,22875,22876,22877,22878,22879,22880,22881,22882,22883,22884,22885,22886,22887,23200,23201,23243,23244,23251,23252,23253,23254,23255,23256,23257,23258,23259,23260,23261,23262,23263,23264,23272,23273,23274,23275,23276,23277,23278,23279,23280,23281,23282,23283,23284,23285,23286,23287,23288,23289,23290,23291,23292,23293,23294,23295,23296,23297,23298,23299,23300,23301,23302,23303,23304,23305,23306,23307,23308,23309,23310,23311,23312,23313,23314,23315,23316,23317,23318,23319);