SELECT COUNT(DISTINCT barter_name) AS total, wtr_database.map_db.id as map_id FROM wtr_database.barter_db LEFT JOIN wtr_database.floating_shop_db on wtr_database.floating_shop_db.shop_name = wtr_database.barter_db.barter_name LEFT JOIN wtr_database.npc_db on wtr_database.npc_db.npc_id = wtr_database.floating_shop_db.npc_id LEFT JOIN wtr_database.map_db on wtr_database.map_db.map_name = wtr_database.npc_db.map_name WHERE map_id > 0
Found a total of 57 record(s) across 3 page(s). Displaying result(s) 41-57.
Gemcutter |
|
|---|---|
Illusion Staff of Bordeaux
|
|
Illusion Moonlight Dagger
|
|
Illusion Long Mace
|
|
Illusion Spectral Spear
|
|
Equipment Researcher |
|
|---|---|
Illusion Fancy Flower
|
|
Equipment Researcher |
|
|---|---|
Illusion Immaterial Sword
|
|
Illusion War Axe
|
|
Illusion Pole Axe
|
|
Illusion Wing Shuriken
|
|
Illusion Iron Driver
|
|
Horen |
|
|---|---|
Illusion Morrigane`s Belt
|
|
Illusion Morrigane`s Pendant
|
|
Horen |
|
|---|---|
Illusion Saint Robe
|
|
Illusion Saphien`s Armor of Ocean
|
|
Illusion Chain Mail
|
|
Horen |
|
|---|---|
Illusion Morrigane`s Manteau
|
|
Horen |
|
|---|---|
Illusion Morrigane`s Helm
|
|
Horen |
|
|---|---|
Illusion Electric Guitar
|
|
Illusion Electric Eel
|
|
Illusion Death Guidance
|
|
Illusion Katar of Frozen Icicle
|
|
Illusion Brionac
|
|
Illusion Zephyrus
|
|
Great Merchant |
|
|---|---|
Illusion Skull Ring
|
|
Illusion Ring
|
|
Great Merchant |
|
|---|---|
Illusion Ancient Cape
|
|
Great Merchant |
|
|---|---|
Illusion Infiltrator
|
|
Illusion Sharpened Legbone of Ghoul
|
|
Illusion Wizardry Staff
|
|
Illusion Ballista
|
|
Illusion Apocalypse
|
|
Commissary |
|
|---|---|
City Map
|
|
Prontera Badge
|
|
Shining Holy Water
|
|
Guardsmen`s Shield
|
|
Flattery Robe
|
|
Abusive Robe
|
|
Costume Decoration Time
|
|
Costume Fate Of Black Hand
|
|
Commissary |
|
|---|---|
Parchment City
|
|
Shining Holy Water
|
|
Parchment City
|
|
Prontera Badge
|
|
Strasse |
|
|---|---|
Agenda Robe
|
|
Consultation Robe
|
|
Republic Hat
|
|
Costume Combat Vestige
|
|
Mercenary Ring Type A
|
|
Mercenary Ring Type B
|
HUGINN2001 |
|
|---|---|
Mutating White Knight Card
|
|
Mutating Khalitzburg Card
|
|