-- Kompletni prumaz questu, quest itemu a achievementu z bugleho Mimirona HM (7.9. 16:00 - 8.9. 14:00)
-- DELETE character_questatus_rewarded
DELETE FROM `character_queststatus_rewarded` WHERE `character_queststatus_rewarded`.`quest` IN (13611, 13824) AND `character_queststatus_rewarded`.`guid` IN (SELECT `character_achievement`.`guid` FROM `character_achievement` WHERE `character_achievement`.`achievement` IN (3180, 3189) AND `character_achievement`.`date` BETWEEN 1347033600 AND 1347112800);
-- DELETE character_inventory
DELETE FROM `character_inventory` WHERE `character_inventory`.`item` IN (SELECT `item_instance`.`guid` FROM `item_instance` WHERE `item_instance`.`itemEntry` IN (45787, 45816) AND `item_instance`.`owner_guid` IN (SELECT `character_achievement`.`guid` FROM `character_achievement` WHERE `character_achievement`.`achievement` IN (3180, 3189) AND `character_achievement`.`date` BETWEEN 1347033600 AND 1347112800));
-- DELETE item_instance
DELETE FROM `item_instance` WHERE `item_instance`.`itemEntry` IN (45787, 45816) AND `item_instance`.`owner_guid` IN (SELECT `character_achievement`.`guid` FROM `character_achievement` WHERE `character_achievement`.`achievement` IN (3180, 3189) AND `character_achievement`.`date` BETWEEN 1347033600 AND 1347112800);
-- DELETE character_achievement
DELETE FROM `character_achievement` WHERE `character_achievement`.`achievement` IN (3180, 3189) AND `character_achievement`.`date` BETWEEN 1347033600 AND 1347112800;
-- DELETE character_achievement_progress
DELETE FROM `character_achievement_progress` WHERE `character_achievement_progress`.`criteria` IN (10450, 10463) AND `character_achievement_progress`.`date` BETWEEN 1347033600 AND 1347112800;