Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select entry,name from trinity.item_template where entry NOT in (select id from tempworld.dbc_Item);
- +-------+-----------------------------------+
- | entry | name |
- +-------+-----------------------------------+
- | 2719 | Small Brass Key |
- | 3467 | Dull Iron Key |
- | 3499 | Burnished Gold Key |
- | 3704 | Rusted Iron Key |
- | 3930 | Maury's Key |
- | 4882 | Benedict's Key |
- | 5396 | Key to Searing Gorge |
- | 5397 | Defias Gunpowder |
- | 7681 | Obsidian Golem Shard |
- | 7716 | Shattered Necklace |
- | 7923 | Defias Tower Key |
- | 8072 | Silixiz's Tower Key |
- | 9299 | Thermaplugg's Safe Combination |
- | 10460 | Hakkari Blood |
- | 10757 | Ward of the Defiler |
- | 11000 | Shadowforge Key |
- | 11079 | Gor'tesh's Lopped Off Head |
- | 12144 | Eggscilloscope |
- | 12301 | Bamboo Cage Key |
- | 13302 | Market Row Postbox Key |
- | 13303 | Crusaders' Square Postbox Key |
- | 13304 | Festival Lane Postbox Key |
- | 13305 | Elders' Square Postbox Key |
- | 13306 | King's Square Postbox Key |
- | 13307 | Fras Siabi's Postbox Key |
- | 13704 | Skeleton Key |
- | 13873 | Viewing Room Key |
- | 16315 | Sergeant Major's Cape |
- | 16334 | Sergeant's Insignia |
- | 16336 | Sergeant Major's Cape |
- | 16337 | Sergeant Major's Cape |
- | 16340 | First Sergeant's Cloak |
- | 17242 | Key to Salem's Chest |
- | 17262 | James' Key |
- | 18266 | Gordok Courtyard Key |
- | 18268 | Gordok Inner Door Key |
- | 21761 | Scarab Coffer Key |
- | 21762 | Greater Scarab Coffer Key |
- | 24490 | The Master's Key |
- | 27808 | Jump-a-tron 4000 Key |
- | 30438 | Cache of the Legion Key |
- | 30622 | Flamewrought Key |
- | 30623 | Reservoir Key |
- | 30633 | Auchenai Key |
- | 30634 | Warpforged Key |
- | 30635 | Key of Time |
- | 30637 | Flamewrought Key |
- | 31704 | The Tempest Key |
- | 10580 | Goblin "Boom" Box |
- | 40232 | Test Dazzling Talasite |
- | 42482 | The Violet Hold Key |
- | 43650 | Rusty Prison Key |
- | 44581 | Heroic Key to the Focusing Iris |
- | 44582 | Key to the Focusing Iris |
- | 44852 | Cornmeal |
- | 45796 | Celestial Planetarium Key |
- | 34117 | Rusty Iron Key |
- | 20591 | Sturdy Male Dwarf Mask |
- | 20596 | Sturdy Male Tauren Mask |
- | 20880 | Golden Token |
- | 23683 | Crystal Flake Throat Lozenge |
- | 32911 | Empty Brewfest Stein |
- | 32972 | Beer Goggles |
- | 33063 | Really Tough Brewfest Bread |
- | 33147 | Formula: Enchant Cloak - Subtlety |
- | 34835 | Omar's Gem of POWAH |
- | 41750 | Brunnhildar Harpoon |
- | 41753 | Brunnhildar Great Axe |
- | 41900 | LK Honor 5 Caster DPS Belt |
- | 41911 | LK Honor 5 Caster DPS Bracers |
- | 41995 | LK Arena 6 Warlock Helm |
- | 42000 | LK Arena 6 Warlock Chest |
- | 42007 | LK Arena 6 Warlock Legs |
- | 42013 | LK Arena 6 Warlock Shoulders |
- | 42019 | LK Arena 6 Warlock Gloves |
- | 42083 | LK Honor 5 Caster DPS Crit Cloak |
- | 42474 | Glyph of Arcane Explosion |
- | 43517 | Penguin Egg |
- | 45049 | Jousting Lance [PH] |
- | 45728 | Thalassian Lance [PH] |
- | 45729 | Raider's Lance [PH] |
- | 45730 | Forsaken Lance [PH] |
- | 45748 | Darkspear Lance [PH] |
- | 45749 | Brave's Lance [PH] |
- | 45750 | Elekk Lance [PH] |
- | 45751 | Spring-Loaded Mechano-Lance [PH] |
- | 45752 | Mountaineer's Lance [PH] |
- | 45754 | Darnassian Lance [PH] |
- | 45759 | Cavalry Lance [PH] |
Advertisement
Add Comment
Please, Sign In to add comment