Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select i.entry as itemid, i.name as itemname, i.buyprice as price, v.extendedcost as extendedcost, i.quality as quality, i.itemlevel as itemlevel from item_template i, npc_vendor v where v.item = i.entry and v.entry = 34060 order by itemlevel desc;
- +--------+-----------------------------------------------+-------+--------------+---------+-----------+
- | itemid | itemname | price | extendedcost | quality | itemlevel |
- +--------+-----------------------------------------------+-------+--------------+---------+-----------+
- | 51327 | Wrathful Gladiator's Cord of Dominance | 0 | 2961 | 4 | 264 |
- | 51343 | Wrathful Gladiator's Belt of Dominance | 0 | 2961 | 4 | 264 |
- | 51359 | Wrathful Gladiator's Girdle of Salvation | 0 | 2961 | 4 | 264 |
- | 51375 | Wrathful Gladiator's Sabatons of Dominance | 0 | 2961 | 4 | 264 |
- | 51328 | Wrathful Gladiator's Treads of Dominance | 0 | 2961 | 4 | 264 |
- | 51344 | Wrathful Gladiator's Boots of Dominance | 0 | 2961 | 4 | 264 |
- | 51360 | Wrathful Gladiator's Greaves of Salvation | 0 | 2961 | 4 | 264 |
- | 51376 | Wrathful Gladiator's Wristguards of Dominance | 0 | 2963 | 4 | 264 |
- | 51329 | Wrathful Gladiator's Cuffs of Dominance | 0 | 2963 | 4 | 264 |
- | 51345 | Wrathful Gladiator's Armwraps of Dominance | 0 | 2963 | 4 | 264 |
- | 51361 | Wrathful Gladiator's Bracers of Salvation | 0 | 2963 | 4 | 264 |
- | 51378 | Medallion of the Horde | 0 | 2961 | 4 | 264 |
- | 51330 | Wrathful Gladiator's Cloak of Dominance | 0 | 2964 | 4 | 264 |
- | 51346 | Wrathful Gladiator's Cloak of Salvation | 0 | 2964 | 4 | 264 |
- | 51362 | Wrathful Gladiator's Girdle of Triumph | 0 | 2961 | 4 | 264 |
- | 51331 | Wrathful Gladiator's Pendant of Dominance | 0 | 2964 | 4 | 264 |
- | 51347 | Wrathful Gladiator's Pendant of Salvation | 0 | 2964 | 4 | 264 |
- | 51363 | Wrathful Gladiator's Greaves of Triumph | 0 | 2961 | 4 | 264 |
- | 51332 | Wrathful Gladiator's Cloak of Subjugation | 0 | 2964 | 4 | 264 |
- | 51348 | Wrathful Gladiator's Cloak of Deliverance | 0 | 2964 | 4 | 264 |
- | 51364 | Wrathful Gladiator's Bracers of Triumph | 0 | 2963 | 4 | 264 |
- | 51333 | Wrathful Gladiator's Pendant of Subjugation | 0 | 2964 | 4 | 264 |
- | 51349 | Wrathful Gladiator's Pendant of Deliverance | 0 | 2964 | 4 | 264 |
- | 51365 | Wrathful Gladiator's Cord of Salvation | 0 | 2961 | 4 | 264 |
- | 51334 | Wrathful Gladiator's Cloak of Ascendancy | 0 | 2964 | 4 | 264 |
- | 51350 | Wrathful Gladiator's Waistguard of Triumph | 0 | 2961 | 4 | 264 |
- | 51366 | Wrathful Gladiator's Treads of Salvation | 0 | 2961 | 4 | 264 |
- | 51335 | Wrathful Gladiator's Pendant of Ascendancy | 0 | 2964 | 4 | 264 |
- | 51351 | Wrathful Gladiator's Sabatons of Triumph | 0 | 2961 | 4 | 264 |
- | 51367 | Wrathful Gladiator's Cuffs of Salvation | 0 | 2963 | 4 | 264 |
- | 51336 | Wrathful Gladiator's Band of Dominance | 0 | 2964 | 4 | 264 |
- | 51352 | Wrathful Gladiator's Wristguards of Triumph | 0 | 2963 | 4 | 264 |
- | 51368 | Wrathful Gladiator's Belt of Triumph | 0 | 2961 | 4 | 264 |
- | 51337 | Wrathful Gladiator's Cord of Alacrity | 0 | 2961 | 4 | 264 |
- | 51353 | Wrathful Gladiator's Pendant of Sundering | 0 | 2964 | 4 | 264 |
- | 51369 | Wrathful Gladiator's Boots of Triumph | 0 | 2961 | 4 | 264 |
- | 51338 | Wrathful Gladiator's Treads of Alacrity | 0 | 2961 | 4 | 264 |
- | 51354 | Wrathful Gladiator's Cloak of Triumph | 0 | 2964 | 4 | 264 |
- | 51370 | Wrathful Gladiator's Armwraps of Triumph | 0 | 2963 | 4 | 264 |
- | 51339 | Wrathful Gladiator's Cuffs of Alacrity | 0 | 2963 | 4 | 264 |
- | 51355 | Wrathful Gladiator's Pendant of Triumph | 0 | 2964 | 4 | 264 |
- | 51371 | Wrathful Gladiator's Waistguard of Salvation | 0 | 2961 | 4 | 264 |
- | 51340 | Wrathful Gladiator's Belt of Salvation | 0 | 2961 | 4 | 264 |
- | 51356 | Wrathful Gladiator's Cloak of Victory | 0 | 2964 | 4 | 264 |
- | 51372 | Wrathful Gladiator's Sabatons of Salvation | 0 | 2961 | 4 | 264 |
- | 51341 | Wrathful Gladiator's Boots of Salvation | 0 | 2961 | 4 | 264 |
- | 51357 | Wrathful Gladiator's Pendant of Victory | 0 | 2964 | 4 | 264 |
- | 51373 | Wrathful Gladiator's Wristguards of Salvation | 0 | 2963 | 4 | 264 |
- | 51342 | Wrathful Gladiator's Armwraps of Salvation | 0 | 2963 | 4 | 264 |
- | 51358 | Wrathful Gladiator's Band of Triumph | 0 | 2964 | 4 | 264 |
- | 51374 | Wrathful Gladiator's Waistguard of Dominance | 0 | 2961 | 4 | 264 |
- +--------+-----------------------------------------------+-------+--------------+---------+-----------+
- 51 rows in set
- mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement