delete from `character_inventory` where `character_inventory`.`item_template` in (30183,30244,30243,30242,30112,30102,30110,32895,30108,30107,30621,30109,30103,30105,30111,30104,30106,30062,30061,30060,30665,30064,30066,30067,30063,30059,30058,30065,30057,33054,29947,30448,29923,29949,29918,29922,30447,29921,29920,29924,29925,32944,29948,30026,29966,29982,29976,32405,30236,30238,30237,29990,29996,29992,29994,29987,29997,29995,29988,29991,29993,29998,29989,32458,30249,30250,30248,29986,30619,29985,29984,29983,32515,30450,30245,30247,30246,30100,30090,30663,30101,30099,30626,30098,30084,30720,30075,30082,30085,30008,30081,30068,30083,30080,33058,30079,30240,30241,30239,30097,30091,30627,30095,30096,30092,30629,30056,30047,30048,30049,30054,30053,30051,30664,30052,30055,30050,32516,33055,30118,30113,30216,30231,30222,30159,30150,30164,30169,30185,30129,30123,30134,30144,30139,30214,30196,30122,30117,30154,30230,30221,30235,30163,30215,30210,30143,30168,30173,30194,30138,30133,30127,30149,30119,30114,30151,30160,30232,30217,30223,30211,30205,30140,30189,30165,30170,30130,30135,30124,30145,30172,30167,30192,30132,30137,30126,30148,30213,30207,30142,30153,30121,30116,30162,30229,30220,30234,30206,30212,30141,30152,30120,30115,30161,30228,30219,30233,30166,30171,30190,30125,30136,30131,30146);
delete from `mail` where `mail`.`item_template` in (30183,30244,30243,30242,30112,30102,30110,32895,30108,30107,30621,30109,30103,30105,30111,30104,30106,30062,30061,30060,30665,30064,30066,30067,30063,30059,30058,30065,30057,33054,29947,30448,29923,29949,29918,29922,30447,29921,29920,29924,29925,32944,29948,30026,29966,29982,29976,32405,30236,30238,30237,29990,29996,29992,29994,29987,29997,29995,29988,29991,29993,29998,29989,32458,30249,30250,30248,29986,30619,29985,29984,29983,32515,30450,30245,30247,30246,30100,30090,30663,30101,30099,30626,30098,30084,30720,30075,30082,30085,30008,30081,30068,30083,30080,33058,30079,30240,30241,30239,30097,30091,30627,30095,30096,30092,30629,30056,30047,30048,30049,30054,30053,30051,30664,30052,30055,30050,32516,33055,30118,30113,30216,30231,30222,30159,30150,30164,30169,30185,30129,30123,30134,30144,30139,30214,30196,30122,30117,30154,30230,30221,30235,30163,30215,30210,30143,30168,30173,30194,30138,30133,30127,30149,30119,30114,30151,30160,30232,30217,30223,30211,30205,30140,30189,30165,30170,30130,30135,30124,30145,30172,30167,30192,30132,30137,30126,30148,30213,30207,30142,30153,30121,30116,30162,30229,30220,30234,30206,30212,30141,30152,30120,30115,30161,30228,30219,30233,30166,30171,30190,30125,30136,30131,30146);
delete from `auctionhouse` where `auctionhouse`.`item_template` in (30183,30244,30243,30242,30112,30102,30110,32895,30108,30107,30621,30109,30103,30105,30111,30104,30106,30062,30061,30060,30665,30064,30066,30067,30063,30059,30058,30065,30057,33054,29947,30448,29923,29949,29918,29922,30447,29921,29920,29924,29925,32944,29948,30026,29966,29982,29976,32405,30236,30238,30237,29990,29996,29992,29994,29987,29997,29995,29988,29991,29993,29998,29989,32458,30249,30250,30248,29986,30619,29985,29984,29983,32515,30450,30245,30247,30246,30100,30090,30663,30101,30099,30626,30098,30084,30720,30075,30082,30085,30008,30081,30068,30083,30080,33058,30079,30240,30241,30239,30097,30091,30627,30095,30096,30092,30629,30056,30047,30048,30049,30054,30053,30051,30664,30052,30055,30050,32516,33055,30118,30113,30216,30231,30222,30159,30150,30164,30169,30185,30129,30123,30134,30144,30139,30214,30196,30122,30117,30154,30230,30221,30235,30163,30215,30210,30143,30168,30173,30194,30138,30133,30127,30149,30119,30114,30151,30160,30232,30217,30223,30211,30205,30140,30189,30165,30170,30130,30135,30124,30145,30172,30167,30192,30132,30137,30126,30148,30213,30207,30142,30153,30121,30116,30162,30229,30220,30234,30206,30212,30141,30152,30120,30115,30161,30228,30219,30233,30166,30171,30190,30125,30136,30131,30146);
DELETE FROM `item_instance` WHERE guid NOT IN (SELECT `item` FROM `character_inventory` where item!=0) && (SELECT `itemguid` FROM `auctionhouse` where item!=0) && (SELECT `item_guid` FROM `mail` where item!=0);