Drilldown: Shops
Choose a table:
- Achievements (0)
- Bounties (44)
- Currencies (1)
- Dialogue (10)
- Drops (16)
- Effects (1)
- EquipmentStats (55)
- Events (0)
- GuideMethods (7)
- Items (133)
- LocationObjects (8)
- Locations (6)
- Mechanics (14)
- Mobs (25)
- MoneyMakingMethods (1)
- NPCs (13)
- OnChainItems (0)
- QuestRequirements (1)
- QuestRewards (3)
- QuestSteps (26)
- Quests (6)
- RecipeIngredients (57)
- RecipeOutputs (30)
- Recipes (30)
- ResourceNodes (34)
- Routes (1)
- Services (7)
- ShopStock (14)
- Shops (7)
- Skills (18)
- SourceEvidence (410)
- Spawns (43)
- ToolRequirements (3)
- ToolStats (2)
- TrainingMethods (5)
- UpdateChanges (49)
- Updates (7)
Use the filters below to narrow your results.
shop id:
name: (Click arrow to add another value)
location:
currency:
npc ids:
keeper:
keeper npc id:
shop type:
map image:
exterior image:
interior image:
sells:
buys:
verification status:
Showing below up to 7 results in range #1 to #7.
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Shards' OR `Shops_alias`.`name` = 'Wise Old Man\'s Shards') AND (`Shops_alias_' at line 1
Function: CargoSQLQuery::run
Query: SELECT `Shops_alias`.`_pageName` AS `_pageName` FROM `cargo__Shops` `Shops_alias` LEFT OUTER JOIN `cargo__Shops__sells` `Shops_alias__sells` ON ((`Shops_alias`.`_ID`=`Shops_alias__sells`.`_rowID`)) WHERE (`Shops_alias`.`name` = 'Wise Old Man's Shards' OR `Shops_alias`.`name` = 'Wise Old Man\'s Shards') AND (`Shops_alias__sells`.`_value` < 10 ) ORDER BY `Shops_alias`.`_pageName` LIMIT 250