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 = 18382 order by itemlevel desc;
+--------+-----------------------------------------+-------+--------------+---------+-----------+
| itemid | itemname                                | price | extendedcost | quality | itemlevel |
+--------+-----------------------------------------+-------+--------------+---------+-----------+
|  25827 | Muck-Covered Drape                      |     0 |          103 |       3 |        97 |
|  25828 | Petrified Lichen Guard                  |     0 |          104 |       3 |        91 |
|  29149 | Sporeling's Firestick                   |     0 |         1076 |       3 |        91 |
|  29150 | Hardened Stone Shard                    |     0 |         1077 |       3 |        91 |
|  38229 | Pattern: Mycah's Botanical Bag          |     0 |          103 |       1 |        75 |
|  34478 | Tiny Sporebat                           |     0 |          388 |       3 |        70 |
|  22916 | Recipe: Transmute Primal Earth to Water |     0 |          103 |       2 |        70 |
|  22906 | Recipe: Shrouding Potion                |     0 |          388 |       2 |        67 |
|  24539 | Marsh Lichen                            |     0 |          102 |       1 |        65 |
|  27689 | Recipe: Sporeling Snack                 |     0 |          102 |       1 |        62 |
|  30156 | Recipe: Clam Bar                        |     0 |          100 |       1 |        60 |
|  25550 | Redcap Toadstool                        |     0 |          100 |       1 |        50 |
|  25548 | Tallstalk Mushroom                      |     0 |          100 |       1 |        50 |
|  31775 | Sporeggar Tabard                        |     0 |         1994 |       1 |        20 |
+--------+-----------------------------------------+-------+--------------+---------+-----------+
14 rows in set

mysql>