delete from character_inventory WHERE characters.character_inventory.item > '194638052' AND mangos.item_template.entry = characters.character_inventory.item_template AND mangos.item_template.ExtendedCost not in (0,1,66,94,95,98,99,115,125,127,129,131,165,169,170,171,172,173,201,202,203,204,205,348,359,360,386,427,428,444,460,463,464,465,488,489,490,491,492,495,496,497,501,520,532,533,541,542,565,567,634,652,653,701,702,746,747,748,774,821,822,823,826,837,838,839,841,855,871,883,884,885,887,901,917,929,930,931,933,947,968,986,989,990,1050,1054,1055,1442,1468,1564,1565,1911,1923,1935,2028,2237,2238,2239,2240,2241,2242,2248,2249,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2277,2278,2279,2280,2281,2289,2290,2291) AND characters.characters.guid = characters.character_inventory.guid
delete from item_instance where guid in (63322,5834,61503,39850,52085,73473,38938,71273,38938,71687,71641,5856,5856,99513,99513,99513,99513,99513,99513,99513,99513,99513,99513,99513,522,522,522,522,44069,522,522,522,522,522,522,522,522,522,522,75091,75091,75091,75091,75091,3416,16998,24781,1207,26640,26640,100062,26640,99979,99979,44625,99979,99979,99979,68168,25956,25956,68168,68168,63090,25956,25956,68168,25956,203,68168,68168,103813,103813,103813,103813,103813,203,203,203,203,203,203,203,203,203,203,66546,25956,25956,25956,25956,203,25956,25956,25956,68168,25956,25956,68168,203,25956,68168,11222,11222,203,11222,68168,11222,11222,68168,68168,11222,11222,11222,25095,11222,11222,11222,68168,11222,11222,11222,11222,11222,203,11222,11222,11222,11222,11222,25956,25095,42270,203,26899,42270,25095,25095,42270,26899,25095,25095,25095,25095,26899,27413,25095,26899,25095,6923,25095,25095,25095,66546,71050,71050,71050,6923,71050,71050,68168,66546,68168,6923,6923,66546,25095,68168,27413,66546,11222,6923,66546,27413,66546,6923,6923,25956,25956,11222,25956,25956,25095,11222,25095,27413,11222,11222,66546,11222,68168,44069,44069,57258,57258,57258,25095,57258,57258,57258,57258,2152,2152,57258,57258,44069,25095,2152,2152,57258,57258,57258,71949,57258,26899,2152,57258,71949,57258,71949,71949,57258,71949,71949,71949,71949,71949,57258,71949,42270,25095,57258,57258,29000,57258,29000,2152,2152,55951,29000,29000,57258,57258,57258,29000,2152,57258,57258,57258,29000,57258,29000,29000,2152,11222,57258,66546,57258,57258,57258,2152,57258,55951,57258,57570,2152,57258,57258,57570,29000,11222,11222,11222,55951,29000,203,203,29000,72394,72394,72394,72394,72394,72394,72394,72394,72394,72394,72394,72394,72394,72394,72394,72394,57570,68168,8813,68168,68168,68168,68168,68168,203,68168,17360,68168,68168,68168,68168,68168,17360,72394,72394,72394,72394,72394,72394,68168,72394,72394,72394,72394,72394,72394,72394,72394,72394,17360,71629,71629,44069,71629,498,71629,72394,71629,39087,72394,71629,72394,72394,71629,72394,71629,72394,72394,72394,72394,72394,72394,72394,72394,44069,72394,72394,18920,17360,18920,18920,44069,18920,44069,17360,18920,18920,44069,18920,66546,80,1669,72513,72513,72513,72513,1669,80,1669,80,1669,44069,80,55951,17360,17360,17360,501,1669,44069,80,18920,18920,5786,5786,5786,80,5786,5786,80,18920,44069,72513,80,72513,189,72513,72513,18920,498,72513,72513,498,80,189,1669,71360,71360,71360,1669,44476,17269,55951,17269,68943,17269,71418,1669,71418,71418,44476,71418,19285,19285,71418,19285,19285,71418,19285,71418,68943,71418,501,1669,1669,55951,189,203,203,203,203,44476,1669,19285,71360,71360,19285,71360,19285,68943,71360,71360,19285,1669,19285,68943,44476,189,29000,29000,189,5786,29000,1669,29000,189,92532,1669,92532,92532,92532,1669,92532,92532,92532,92532,92532,92532,17269,189,68943,1669,44476,25956,17360,57570,68168,44476,53194,39022,44476,68943,39022,44476,189,19285,189,189,44476,44476,44476,44476,44476,44476,189,44476,44476,53194,44476,39087,53194,25956,44476,53194,57570,44476,203,39087,39022,55951,53194,19285,19285,19285,19285,53194,19285,53194,19285,39022,25956,19285,19285,19285,19285,19285,39022,71360,19285,39022,71360,71360,44476,53194,71360,39022,19285,19285,19285,53194,53194,25956,5786,53194,25956,44069,39022,53194,25956,25956,39022,53194,25956,25956,57570,53194,53194,19285,19285,19285,19285,19285,25956,19285,19285,19285,19285,19285,18920,53194,53194,44069,53194,71418,53194,53194,53194,71629,71629,71629,53194,71418,53194,44069,55090,55090,55090,55090,55090,68168,55090,55090,55090,55090,55090,55090,53194,53194,53194,57570,42270,13731,55090,53194,53194,189,53194,203,68943,57570,18920,68168,42270,55951,39087,42270,189,71010,71010,71010,17360,68168,17360,17360,17360,17360,71010,57570,71010,71010,55951,39087,71010,501,57570,501,44069,501,501,55951,68168,203,501,501,39087,39087,39022,57570,42270,23325,68168,23325,23325,23325,501,23325,501,23325,23325,501,23325,23325,13731,13731,23325,57570,1705,13731,13731,18920,17269,39087,2109,39087,1705,189,2109,42270,56487,2109,44069,26928,26928,2109,5786,5786,5786,2109,71418,71418,71418,2109,71418,2109,18920,5786,5786,5786,5786,5786,5786,2109,71336,41790,2109,41790,82713,71949,71949,71949,71949,71949,71949,41790,41790,9488,82713,41790,41790,18920,41790,82713,82713,13731,41790,82713,55951,41790,41790,82713,82713,66546,82713,41790,41790,41790,41790,41790,39087,13731,41790,66546,41790,66546,2109,25956,17360,82713,55090,25956,39087,41790,82713,39087,25956,55090,39087,55090,41790,82713,39087,68168,2109,68168,39087,41790,41790,619,68168,71563,619,71563,71563,66546,71563,71563,5786,5786,5786,5786,5786,619,5786,619,5786,5786,5786,5786,71010,71010,71563,619,68943,66546,71563,71010,71563,71563,71563,71010,41790,41790,71010,619,66546,71010,62253,42270,42270,42270,42270,42270,36047,36047,41790,36047,41790,36047,39087,45538,45538,45538,36047,45538,45538,36047,45538,55951,45538,71418,82713,45538,79899,36047,36047,45538,79899,79899,71563,79899,79899,79899,45538,71563,55951,71418,55951,71418,45538,45538,71418,45538,45538,79899,79899,79899,45538,79899,43383,79899,79899,79899,79899,43383,43383,45538,39087,66546,45538,43383,45538,66546,45538,66546,79899,66546,27413,25757,45538,79899,43383,45538,79899,79899,45538,79899,27413,79899,79899,79899,43383,82713,45538,71563,45538,45538,79899,1705,1705,1705,1705,1705,57570,57570,79899,57570,57570,57570,79899,1705,203,9488,45538,17360,71563,79899,45538,203,203,71563,79899,45538,203,80,80,80,57570,57570,44069,57570,80,45538,56487,57570,57570,80,6923,79899,56487,66546,66546,66546,66546,66546,66546,66546,66546,6923,45538,26928,26928,26928,6923,45538,26928,26928,6923,45538,79899,26928,45538,26928,203,26928,45538,26928,26928,79899,79899,6539,6539,6539,40731,66546,40731,66546,13731,79899,40731,66546,56487,40731,71050,40731,79899,66546,40731,66546,40731,40731,13731,40731,40731,13731,72513,39022,72513,203,39022,39022,66546,66546,203,66546,66546,203,27413,27413,68943,68943,68943,68943,26899,68943,26899,27413,26899,79899,68943,27262,2152,68943,2152,68943,68943,68943,17269,17269,2152,1341,17269,17269,17269,79899,17360,17360,17360,17360,2152,2152,27262,27262,27262,17269,17269,2152,27262,17269,2152,17269,80,2152,17269,2152,2152,2152,2152,1705,6539,2152,40731,40731,6539,40731,6539,6539,18920,2152,18920,2152,18920,18920,71629,1341,18920,71629,1341,56487,40731,40731,55951,82713,82713,18920,55951,98288,18920,18920,55951,82713,82713,55951,1341,82713,6539,55951,82713,82713,6539,82713,55951,82713,6539,82713,55951,6539,82713,82713,55951,82713,6539,82713,82713,6539,55951,189,6539,55951,82713,82713,55951,39303,82713,39303,82713,39303,40731,1341,55951,39303,82713,39303,40731,55951,55951,1341,55951,1341,40731,41790,40731,1341,41790,41790,41790,41790,1341);