Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT clt.`entry` AS `DropNPC`, ct.`name` AS `NPCName`, clt.`item`, clt.`ChanceOrQuestChance` AS `DropChance%` FROM `creature_loot_template` clt LEFT JOIN `creature_template` ct ON clt.`entry` = ct.`entry` WHERE clt.`item` = '45912' ORDER BY clt.`entry`;
- +---------+------------------------------+-------+-------------+
- | DropNPC | NPCName | item | DropChance% |
- +---------+------------------------------+-------+-------------+
- | 28243 | Thrym | 45912 | 1,5 |
- | 31229 | Ancient Watcher | 45912 | 1,2 |
- | 31691 | Faceless Lurker | 45912 | 0,1 |
- | 32255 | Converted Hero | 45912 | 0,1 |
- | 33527 | Nature's Blade | 45912 | 1,3 |
- | 33732 | Guardian Lasher (1) | 45912 | 2,8 |
- | 33755 | Dark Rune Ravager | 45912 | 1,7 |
- | 34015 | Tempest Warder | 45912 | 3,4 |
- | 34069 | Molten Colossus | 45912 | 1,7 |
- | 34086 | Magma Rager | 45912 | 2,1 |
- | 34133 | Champion of Hodir | 45912 | 1,7 |
- | 34140 | Winter Jormungar (1) | 45912 | 1 |
- | 34197 | Chamber Overseer | 45912 | 1,3 |
- | 34728 | Dark Zealot | 45912 | 0,1 |
- | 34734 | Dark Ritualist | 45912 | 0,1 |
- | 35143 | Flame Warder | 45912 | 3,9 |
- | 35309 | Argent Lightwielder | 45912 | 2,1 |
- | 37034 | Kor'kron Templar | 45912 | 1,1 |
- | 37662 | Darkfallen Commander | 45912 | 1,1 |
- | 37663 | Darkfallen Noble | 45912 | 1,6 |
- | 38032 | Crown Sprayer | 45912 | 0,1 |
- | 38076 | Deathspeaker Zealot (1) | 45912 | 1,5 |
- | 38108 | Blighted Abomination (1) | 45912 | 1,6 |
- | 38110 | Pustulating Horror (1) | 45912 | 1 |
- | 38197 | Nerub'ar Champion (1) | 45912 | 1,2 |
- | 3680802 | Deathspeaker Zealot (2) | 45912 | 1,5 |
- | 3688003 | Decaying Colossus (3) | 45912 | 4 |
- | 3700303 | Skybreaker Vindicator (3) | 45912 | 23,5 |
- | 3700703 | Deathbound Ward (3) | 45912 | 1,8 |
- | 3701202 | Ancient Skeletal Soldier (2) | 45912 | 1,1 |
- | 3702202 | Blighted Abomination (2) | 45912 | 1 |
- | 3709802 | Val'kyr Herald (2) | 45912 | 5,6 |
- | 3714402 | Skybreaker Marksman (2) | 45912 | 1,8 |
- | 3714602 | Kor'kron Sniper (2) | 45912 | 3,3 |
- | 3721703 | Precious (3) | 45912 | 1,1 |
- | 3759502 | Darkfallen Blood Knight (2) | 45912 | 3 |
- +---------+------------------------------+-------+-------------+
- 36 rows in set
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement