User:Korgat: Difference between revisions

From bg3.wiki
Jump to navigation Jump to search
No edit summary
 
(17 intermediate revisions by the same user not shown)
Line 34: Line 34:
}}
}}
}}
}}
<hr>
{{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br>
{{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br>
<hr>
<hr>
[[Druid Grove]]
Sold by [[Arron]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = (
     ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND  
     (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND  
     where_to_find NOT REGEXP "Dammon") OR
     where_to_find like "%Arron%") AND
     where_to_find like "%Strange Ox%")
     where_to_find NOT REGEXP "Strange Ox"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
|tables=weapons; where = (
     ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND  
     (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND  
     where_to_find NOT REGEXP "Dammon") OR
     where_to_find like "%Arron%") AND
     where_to_find like "%Strange Ox%")
     where_to_find NOT REGEXP "Strange Ox"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 74: Line 73:
|delimiter=<br>
|delimiter=<br>
}}
}}
}}
{{ImageLocation|The Risen Road.jpg|The Risen Road|'''The Risen Road''' is a long stretch of road that connects [[Elturel]] and [[Baldur's Gate]].<br>
<hr>
<hr>
[[The Risen Road]]
Sold by [[Auntie Ethel]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%The Risen Road%"
tables=equipment; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Auntie Ethel%") AND
    where_to_find NOT REGEXP "Strange Ox"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%The Risen Road%"
|tables=weapons; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Auntie Ethel%") AND
    where_to_find NOT REGEXP "Strange Ox"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 89: Line 92:
|delimiter=<br>
|delimiter=<br>
}}
}}
}}
{{ImageLocation|Forest.jpg|Forest|Forest is a sub-area of the Wilderness. It is found west of the Emerald Grove.<br>
<hr>
<hr>
[[Forest]]
Sold by [[Volo]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Forest%"
tables=equipment; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Volo%") AND
    where_to_find NOT REGEXP "Strange Ox"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Forest%"
|tables=weapons; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Volo%") AND
    where_to_find NOT REGEXP "Strange Ox"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 105: Line 112:
}}
}}
<hr>
<hr>
[[Owlbear Nest]]
[[Druid Grove]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Owlbear Nest%"
tables=equipment; where = (
    ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find NOT REGEXP "Dammon" AND
    where_to_find NOT REGEXP "Arron" AND
    where_to_find NOT REGEXP "Auntie Ethel" AND
    where_to_find NOT REGEXP "Volo") OR
    where_to_find like "%Strange Ox%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Owlbear Nest%"
|tables=weapons; where = (
    ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find NOT REGEXP "Dammon" AND
    where_to_find NOT REGEXP "Arron" AND
    where_to_find NOT REGEXP "Auntie Ethel" AND
    where_to_find NOT REGEXP "Volo") OR
    where_to_find like "%Strange Ox%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 118: Line 137:
}}
}}
}}
}}
<br>
{{ImageLocation|Forest.jpg|Forest|Forest is a sub-area of the Wilderness. It is found west of the Emerald Grove.<br>
{{ImageLocation|Arcane Tower.jpg|Arcane Tower|An isolated wizard tower protected by Arcane Cannons|tall=y}}
 
== [[Act Two]] ==
 
{{ImageLocation|Grand Mausoleum Vestibule.jpg|Grand Mausoleum|The Thorm family mausoleum, resting place of Melodia Thorm and entrance to the Gauntlet of Shar<br>
[[Gauntlet of Shar]]
}}
 
== [[Act Three]] ==
{{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br>
<hr>
<hr>
[[Rivington]]
[[Forest]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = where_to_find like "%Forest%"
              where_to_find like "%Rivington%" AND
     AND rarity != "common" AND legacy IS NULL;  
              where_to_find NOT REGEXP "Rivington General" AND
              where_to_find NOT REGEXP "Ferg Drogher" AND
              where_to_find NOT REGEXP "Mattis" AND
              where_to_find NOT REGEXP "Circus of the Last Days" AND
              where_to_find NOT REGEXP "Open Hand Temple" AND
              where_to_find NOT REGEXP "Angleiron's Cellar")
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
|tables=weapons; where = where_to_find like "%Forest%"
              where_to_find like "%Rivington%" AND
              where_to_find NOT REGEXP "Rivington General" AND
              where_to_find NOT REGEXP "Ferg Drogher" AND
              where_to_find NOT REGEXP "Mattis" AND
              where_to_find NOT REGEXP "Circus of the Last Days" AND
              where_to_find NOT REGEXP "Open Hand Temple" AND
              where_to_find NOT REGEXP "Angleiron's Cellar")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 156: Line 151:
|delimiter=<br>
|delimiter=<br>
}}
}}
}}
{{ImageLocation|Rivington General.jpg|Rivington General|The general store in [[Rivington]], run by a Dragonborn [[Exxvikyap]].<br>
<hr>
<hr>
Sold by [[Exxvikyap]]
[[Owlbear Nest]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = where_to_find like "%Owlbear Nest%"
    where_to_find like "%Rivington General%" AND
    where_to_find like "%Exxvikyap%" AND
    (where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%"))
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
|tables=weapons; where = where_to_find like "%Owlbear Nest%"
    where_to_find like "%Rivington General%" AND
     AND rarity != "common" AND legacy IS NULL;
    where_to_find like "%Exxvikyap%" AND
    (where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%"))
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|format=list
|delimiter=<br>
|delimiter=<br>
}}
}}
}}
{{ImageLocation|The Risen Road.jpg|The Risen Road|'''The Risen Road''' is a long stretch of road that connects [[Elturel]] and [[Baldur's Gate]].<br>
<hr>
<hr>
[[Rivington General]]
[[The Risen Road]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = where_to_find like "%Risen Road%"
    where_to_find like "%Rivington General%" AND
    where_to_find NOT REGEXP "Purchased" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
|tables=weapons; where = where_to_find like "%Risen Road%"
    where_to_find like "%Rivington General%" AND
    where_to_find NOT REGEXP "Purchased" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 199: Line 180:
}}
}}
}}
}}
{{ImageLocation|Requisitioned Barn.jpg|Requisitioned Barn|The '''Requisitioned Barn''' is a donation center for refugees heading to Baldur's Gate.<br>
{{ImageLocation|Arcane Tower.jpg|Arcane Tower|An isolated wizard tower deep in the [[Underdark]] protected by Arcane Cannons<br>
<hr>
<hr>
Sold by [[Ferg Drogher]]
[[Arcane Tower]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Ferg Drogher%")
tables=equipment; where = where_to_find like "%Arcane Tower%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Ferg Drogher%")
|tables=weapons; where = where_to_find like "%Arcane Tower%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 213: Line 194:
|delimiter=<br>
|delimiter=<br>
}}
}}
<hr>
|tall=y}}
Sold by [[Mattis]]
 
<hr>
== [[Act Two]] ==
{{#cargo_compound_query:
 
tables=equipment; where = (where_to_find like "%Mattis%Rivington%")
{{ImageLocation|Grand Mausoleum Vestibule.jpg|Grand Mausoleum|The Thorm family mausoleum, resting place of Melodia Thorm and entrance to the Gauntlet of Shar<br>
    AND rarity != "common" AND legacy IS NULL;
[[Gauntlet of Shar]]
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Mattis%Rivington%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
}}
 
{{ImageLocation|Circus of the Last Days.jpg|Circus of the Last Days|An extraplanar circus which moves from plane to plane, "thrilling all" who stop by.<br>
== [[Act Three]] ==
<br>
<hr>
<hr>
<hr>
Sold by [[Popper]]
'''Wyrm's Crossing'''
<hr>
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
<hr>
[[Circus of the Last Days]]
{{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br>
<hr>
<hr>
{{#cargo_compound_query:
[[Rivington]]
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper")
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
              where_to_find like "%Rivington%" AND
              where_to_find NOT REGEXP "Rivington General" AND
              where_to_find NOT REGEXP "Ferg Drogher" AND
              where_to_find NOT REGEXP "Mattis" AND
              where_to_find NOT REGEXP "Circus of the Last Days" AND  
              where_to_find NOT REGEXP "Open Hand Temple" AND
              where_to_find NOT REGEXP "Angleiron's Cellar")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper")
|tables=weapons; where = (
              where_to_find like "%Rivington%" AND
              where_to_find NOT REGEXP "Rivington General" AND
              where_to_find NOT REGEXP "Ferg Drogher" AND
              where_to_find NOT REGEXP "Mattis" AND
              where_to_find NOT REGEXP "Circus of the Last Days" AND  
              where_to_find NOT REGEXP "Open Hand Temple" AND
              where_to_find NOT REGEXP "Angleiron's Cellar")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 255: Line 238:
}}
}}
}}
}}
<br>
{{ImageLocation|Rivington General.jpg|Rivington General|The general store in [[Rivington]], run by a Dragonborn [[Exxvikyap]].<br>
{{ImageLocation|Open Hand Temple.jpg|Open Hand Temple|A temple dedicated to Ilmater, currently grieving the loss of their head priest.<br>
<hr>
<hr>
[[Open Hand Temple]]
Sold by [[Exxvikyap]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes")
tables=equipment; where = (
    where_to_find like "%Rivington General%" AND  
    where_to_find like "%Exxvikyap%" AND  
    (where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%"))
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes")
|tables=weapons; where = (
    where_to_find like "%Rivington General%" AND  
    where_to_find like "%Exxvikyap%" AND  
    (where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%"))
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 270: Line 258:
|delimiter=<br>
|delimiter=<br>
}}
}}
}}
{{ImageLocation|Ironhand_Cave_Location_Blocked.png|Angleiron's Cellar|The [[Clan Ironhand|Ironhand Gnomes]] who escaped the [[Grymforge]] have taken up residence in this cellar.<br>
<hr>
<hr>
Sold by [[Bumpnagel]]
[[Rivington General]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Angleiron's Cellar%"
tables=equipment; where = (
    where_to_find like "%Rivington General%" AND
    where_to_find NOT REGEXP "Purchased" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Angleiron's Cellar%"
|tables=weapons; where = (
    where_to_find like "%Rivington General%" AND
    where_to_find NOT REGEXP "Purchased" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 286: Line 280:
}}
}}
}}
}}
{{ImageLocation|Wyrm's Crossing Side.jpg|Wyrm's Crossing|Sits between [[Rivington]] and the [[Wyrm's Rock Fortress]], and must be crossed to enter the [[Lower City|City]].<br>
{{ImageLocation|Requisitioned Barn.jpg|Requisitioned Barn|The '''Requisitioned Barn''' is a donation center for refugees heading to Baldur's Gate.<br>
<hr>
<hr>
Sold by [[Entharl Danthelon]]
Sold by [[Ferg Drogher]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
tables=equipment; where = (where_to_find like "%Ferg Drogher%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
|tables=weapons; where = (where_to_find like "%Ferg Drogher%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 301: Line 295:
}}
}}
<hr>
<hr>
[[Wyrm's Crossing]]
Sold by [[Mattis]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
tables=equipment; where = (where_to_find like "%Mattis%Rivington%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
|tables=weapons; where = (where_to_find like "%Mattis%Rivington%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 314: Line 308:
}}
}}
}}
}}
{{ImageLocation|Wyrm's Rock Fortress.jpg|Wyrm's Rock Fortress|Connected to the south by [[Wyrm's Crossing]], and the north by the [[Lower City]].<br>
{{ImageLocation|Circus of the Last Days.jpg|Circus of the Last Days|An extraplanar circus which moves from plane to plane, "thrilling all" who stop by.<br>
<hr>
<hr>
Sold by [[Arkleia Oloril]]
Sold by [[Popper]]
<hr>
<hr>
<i>No special equipment</i>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
<hr>
[[Wyrm's Rock Fortress]]
[[Circus of the Last Days]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%"
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%"
|tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 334: Line 337:
}}
}}
<br>
<br>
{{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br>
{{ImageLocation|Open Hand Temple.jpg|Open Hand Temple|A temple dedicated to Ilmater, currently grieving the loss of their head priest.<br>
<hr>
<hr>
[[Lower City]]
[[Open Hand Temple]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = (where_to_find like "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes")
              where_to_find like "%Lower City%" AND  
              where_to_find NOT REGEXP 'Lower City Sewers' AND
              where_to_find NOT REGEXP 'Undercity Ruins' AND
              where_to_find NOT REGEXP 'Forge of the Nine' AND
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
              where_to_find NOT REGEXP 'Wine Festival' AND
              where_to_find NOT REGEXP "Devil's Fee" AND  
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
              where_to_find NOT REGEXP 'Undercity Ruins')
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
|tables=weapons; where = (where_to_find like "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes")
              where_to_find like "%Lower City%" AND  
     AND rarity != "common" AND legacy IS NULL;
              where_to_find NOT REGEXP 'Lower City Sewers' AND
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
              where_to_find NOT REGEXP 'Undercity Ruins' AND
|format=list
              where_to_find NOT REGEXP 'Forge of the Nine' AND
|delimiter=<br>
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
}}
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
              where_to_find NOT REGEXP 'Wine Festival' AND
              where_to_find NOT REGEXP "Devil's Fee" AND  
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
              where_to_find NOT REGEXP 'Undercity Ruins')
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
}}
{{ImageLocation|Ironhand_Cave_Location_Blocked.png|Angleiron's Cellar|The [[Clan Ironhand|Ironhand Gnomes]] who escaped the [[Grymforge]] have taken up residence in this cellar.<br>
{{ImageLocation|Stormshore tabernacle.jpg|Stormshore Tabernacle|A house of worship located in the northeastern part of the [[Lower City]], near the Basilisk Gate.<br>
<hr>
<hr>
[[Stormshore Tabernacle]]
Sold by [[Bumpnagel]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Stormshore Tabernacle%"
tables=equipment; where = where_to_find like "%Angleiron's Cellar%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Stormshore Tabernacle%"
|tables=weapons; where = where_to_find like "%Angleiron's Cellar%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 388: Line 367:
}}
}}
}}
}}
{{ImageLocation|Elfsong Tavern Street View.jpg|Elfsong Tavern|A tavern located north-west of [[Stormshore Tabernacle]] and the Basilisk Gate [[waypoint]]<br>
{{ImageLocation|Wyrm's Crossing Side.jpg|Wyrm's Crossing|Sits between [[Rivington]] and the [[Wyrm's Rock Fortress]], and must be crossed to enter the [[Lower City|City]].<br>
<hr>
<hr>
[[Elfsong_Tavern#Elfsong_Tavern_Basement|Elfsong Tavern Basement]]
Sold by [[Entharl Danthelon]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Elfsong Tavern Basement%"
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Elfsong Tavern Basement%"
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 403: Line 382:
}}
}}
<hr>
<hr>
[[Knights of the Shield Hideout]]
[[Wyrm's Crossing]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Knights of the Shield Hideout%"
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Knights of the Shield Hideout%"
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 416: Line 395:
}}
}}
}}
}}
{{ImageLocation|Lower City Sewers North.jpg|Lower City Sewers|Entrances include manhole covers in the city streets, and inside specific buildings.<br>
{{ImageLocation|Wyrm's Rock Fortress.jpg|Wyrm's Rock Fortress|Connected to the south by [[Wyrm's Crossing]], and the north by the [[Lower City]].<br>
<hr>
<hr>
[[Lower City Sewers]]
Sold by [[Arkleia Oloril]]
<hr>
<hr>
{{#cargo_compound_query:
<i>No special equipment</i>
tables=equipment; where = where_to_find like "%Lower City Sewers%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Lower City Sewers%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
<hr>
[[Undercity Ruins]]
[[Wyrm's Rock Fortress]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Undercity Ruins%"
tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Undercity Ruins%"
|tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 445: Line 415:
}}
}}
<br>
<br>
{{ImageLocation|Forge of the Nine.jpg|Forge of the Nine|The outside of the Forge of the Nine. A stone patio is equipped with a forge and smithing station.<br>
<hr>
<hr>
Sold by [[Dammon]]
<hr>
<hr>
{{#cargo_compound_query:
'''Lower City'''
tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%")
<hr>
    AND rarity != "common" AND legacy IS NULL;
<hr>
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
{{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br>
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
<hr>
[[Forge of the Nine|Basement]]
[[Lower City]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon')
tables=equipment; where = (
              where_to_find like "%Lower City%" AND
              where_to_find NOT REGEXP 'Lower City Sewers' AND
              where_to_find NOT REGEXP 'Undercity Ruins' AND
              where_to_find NOT REGEXP 'Forge of the Nine' AND
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
              where_to_find NOT REGEXP 'Wine Festival' AND
              where_to_find NOT REGEXP "Devil's Fee" AND
              where_to_find NOT REGEXP "Philgrave's Mansion" AND  
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
              where_to_find NOT REGEXP 'Undercity Ruins')
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon')
|tables=weapons; where = (
     AND rarity != "common" AND legacy IS NULL;
              where_to_find like "%Lower City%" AND
              where_to_find NOT REGEXP 'Lower City Sewers' AND
              where_to_find NOT REGEXP 'Undercity Ruins' AND
              where_to_find NOT REGEXP 'Forge of the Nine' AND
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
              where_to_find NOT REGEXP 'Wine Festival' AND
              where_to_find NOT REGEXP "Devil's Fee" AND
              where_to_find NOT REGEXP "Philgrave's Mansion" AND  
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
              where_to_find NOT REGEXP 'Undercity Ruins')
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|format=list
Line 473: Line 459:
}}
}}
}}
}}
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br>
{{ImageLocation|Stormshore tabernacle.jpg|Stormshore Tabernacle|A house of worship located in the northeastern part of the [[Lower City]], near the Basilisk Gate.<br>
<hr>
<hr>
Sold by [[Gloomy Fentonson]]
[[Stormshore Tabernacle]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
tables=equipment; where = where_to_find like "%Stormshore Tabernacle%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
|tables=weapons; where = where_to_find like "%Stormshore Tabernacle%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 487: Line 473:
|delimiter=<br>
|delimiter=<br>
}}
}}
}}
{{ImageLocation|Elfsong Tavern Street View.jpg|Elfsong Tavern|A tavern located north-west of [[Stormshore Tabernacle]] and the Basilisk Gate [[waypoint]]<br>
<hr>
<hr>
Sold by [[Fytz|Fytz The Firecracker]]
[[Elfsong_Tavern#Elfsong_Tavern_Basement|Elfsong Tavern Basement]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
tables=equipment; where = where_to_find like "%Elfsong Tavern Basement%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
|tables=weapons; where = where_to_find like "%Elfsong Tavern Basement%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 500: Line 488:
|delimiter=<br>
|delimiter=<br>
}}
}}
}}
<hr>
{{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br>
[[Knights of the Shield Hideout]]
<hr>
[[Sorcerous Sundries]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Sorcerous Sundries%"
tables=equipment; where = where_to_find like "%Knights of the Shield Hideout%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Sorcerous Sundries%"
|tables=weapons; where = where_to_find like "%Knights of the Shield Hideout%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 516: Line 502:
}}
}}
}}
}}
 
{{ImageLocation|Lower City Sewers North.jpg|Lower City Sewers|Entrances include manhole covers in the city streets, and inside specific buildings.<br>
= Equipment By Act and Region =
<hr>
 
Sold by [[Severn]]
== <span class="mw-customtoggle-0" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act One ==
<hr>
<div  id="mw-customcollapsible-0" class="mw-collapsible mw-collapsed">
 
{{#cargo_compound_query:
{{#cargo_compound_query:
 
tables=equipment; where = where_to_find like "%Severn%"
tables=equipment; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = where_to_find like "%Severn%"
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
 
}}
|tables=equipment; where = where_to_find like "%Ravaged Beach%"
<hr>
Sold by [[Sticky Dondo]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Sticky Dondo%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = where_to_find like "%Sticky Dondo%"
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Ravaged Beach%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
 
}}
|tables=equipment; where = where_to_find like "%Dank Crypt%"
<hr>
Sold by [[Voiceless Penitent Bareki]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Bareki%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = where_to_find like "%Bareki%"
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Dank Crypt%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg   
|delimiter=<br>
   
}}
|tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
<hr>
[[Lower City Sewers]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Lower City Sewers%" AND
    where_to_find NOT REGEXP "Severn" AND
    where_to_find NOT REGEXP "Sticky Dondo" AND
    where_to_find NOT REGEXP "Bareki")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = (
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
    where_to_find like "%Lower City Sewers%" AND
|tables=weapons; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
    where_to_find NOT REGEXP "Severn" AND
    where_to_find NOT REGEXP "Sticky Dondo" AND
    where_to_find NOT REGEXP "Bareki")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
   
}}
|tables=equipment; where = where_to_find like "%The Risen Road%"
<hr>
[[Undercity Ruins]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Undercity Ruins%" AND
    where_to_find NOT REGEXP "Severn" AND
    where_to_find NOT REGEXP "Sticky Dondo" AND
    where_to_find NOT REGEXP "Bareki")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = (
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
    where_to_find like "%Undercity Ruins%" AND
|tables=weapons; where = where_to_find like "%The Risen Road%"
    where_to_find NOT REGEXP "Severn" AND
    where_to_find NOT REGEXP "Sticky Dondo" AND
    where_to_find NOT REGEXP "Bareki")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
}}
|tables=equipment; where = where_to_find like "%Forest%"
}}
<br>
{{ImageLocation|Forge of the Nine.jpg|Forge of the Nine|The outside of the Forge of the Nine. A stone patio is equipped with a forge and smithing station.<br>
<hr>
Sold by [[Dammon]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%")
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Forest%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
 
}}
|tables=equipment; where = where_to_find like "%Owlbear Nest%"
<hr>
[[Forge of the Nine|Basement]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon')
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon')
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Forest%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
   
}}
|tables=equipment; where = where_to_find like "%Blighted Village%"
}}
{{ImageLocation|Devil's Fee.jpg|Devil's Fee|Owned by [[Helsik]], there are all sorts of devilish artifacts and curios on display around the store.<br>
<hr>
Sold by [[Helsik]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%")
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Blighted Village%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
   
}}
|tables=equipment; where = (where_to_find like "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%")
<hr>
[[Devil's Fee]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik")
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
     AND rarity != "common" AND legacy IS NULL;
|tables=weapons; where = (where_to_find like "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%")
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
     AND rarity != "common" AND legacy IS NULL;
|format=list
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=Location,
|delimiter=<br>
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
}}
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
   
<br>
|tables=equipment; where = where_to_find like "%Goblin Camp%"
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br>
<hr>
Sold by [[Gloomy Fentonson]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Goblin Camp%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
   
}}
|tables=equipment; where = where_to_find like "%Waukeen's Rest%"
<hr>
Sold by [[Fytz|Fytz The Firecracker]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Waukeen's Rest%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
   
}}
|tables=equipment; where = where_to_find like "%Mountain Pass%"
}}
    AND rarity != "common" AND legacy IS NULL;
{{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br>
  fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location,
<hr>
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
Sold by [[Lorroakan's Projection]] (or [[Rolan]])
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
<hr>
|tables=weapons; where = where_to_find like "%Mountain Pass%"
{{#cargo_compound_query:
     AND rarity != "common" AND legacy IS NULL;
tables=equipment; where = (
  fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location,
    where_to_find like "%Sorcerous Sundries%" AND
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     where_to_find like "%Sold%" AND
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     where_to_find like "%Lorroakan's Projection%")
   
   
|tables=equipment; where = where_to_find like "%Underdark%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = (
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
    where_to_find like "%Sorcerous Sundries%" AND
|tables=weapons; where = where_to_find like "%Underdark%"  
    where_to_find like "%Sold%" AND
    where_to_find like "%Lorroakan's Projection%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
   
}}
|tables=equipment; where = where_to_find like "%Grymforge%"  
<hr>
Sold by [[Tolna Tome-Monger]]
<hr>
<i>No special equipment</i>
<hr>
[[Sorcerous Sundries]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Sorcerous Sundries%" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "Sorcerous Vault")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = (
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
    where_to_find like "%Sorcerous Sundries%" AND
|tables=weapons; where = where_to_find like "%Grymforge%"  
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "Sorcerous Vault")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
 
}}
|tables=equipment; where = where_to_find like "%Rosymorn Monastery%"  
}}
{{ImageLocation|Ramazith's View.jpg|Ramazith's Tower|The home of the wizard [[Lorroakan]], only accessible from [[Sorcerous Sundries]].<br>
<hr>
[[Ramazith's Tower]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Ramazith's Tower%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = where_to_find like "%Ramazith's Tower%"
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Rosymorn Monastery%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
 
}}
|tables=equipment; where = where_to_find like "%Crèche Y'llek%"  
}}
{{ImageLocation|Sorcerous Vault.webp|Sorcerous Vault|A secret vault within [[Sorcerous Sundries]] accessible from [[Ramazith's Tower]].<br>
<hr>
[[Sorcerous Vault]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Sorcerous Vault%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = where_to_find like "%Sorcerous Vault%"
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Crèche Y'llek%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
   
}}
   
<br>{{RarityItem|The Tharchiate Codex|20}}
|format=dynamic table
|rows per page=1000
|hidden fields=Effects, Where To Find, Type, AC, Dmg
|column widths=6%,16%,,,,13%,4%,6%
}}
}}
</div>
<br>
 
{{ImageLocation|Philgrave's Mansion.jpg|Philgrave's Mansion|Located by the waterfront next to the [[Counting House]] and [[Felogyr's Fireworks]]<br>
 
<hr>
== <span class="mw-customtoggle-1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two ==
Sold by [[Mystic Carrion]]
<div  id="mw-customcollapsible-1" class="mw-collapsible mw-collapsed">
<hr>
 
{{#cargo_compound_query:
{{#cargo_compound_query:
 
tables=equipment; where = (
tables=equipment; where = where_to_find like "%Ruined Battlefield%"  
    where_to_find like "%Philgrave's Mansion%" AND
    (where_to_find like "%Sold%" OR where_to_find like "%bought%") AND
    where_to_find like "%Mystic Carrion%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|tables=weapons; where = (
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
    where_to_find like "%Philgrave's Mansion%" AND
|tables=weapons; where = where_to_find like "%Ruined Battlefield%"  
    (where_to_find like "%Sold%" OR where_to_find like "%bought%") AND
    where_to_find like "%Mystic Carrion%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location,
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|format=list
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|delimiter=<br>
}}
<hr>
[[Philgrave's Mansion]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Philgrave's Mansion%" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    where_to_find like "%Philgrave's Mansion%" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
     AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
 
= Equipment By Act and Region =
 
== <span class="mw-customtoggle-0" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act One ==
<div  id="mw-customcollapsible-0" class="mw-collapsible mw-collapsed">
 
{{#cargo_compound_query:


|tables=equipment; where = where_to_find like "%Last Light Inn%"  
tables=equipment; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location,  
   fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Last Light Inn%"  
|tables=weapons; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location,
   fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Reithwin Town%"  
|tables=equipment; where = where_to_find like "%Ravaged Beach%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Reithwin Town]]")=Location,  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Reithwin Town%"  
|tables=weapons; where = where_to_find like "%Ravaged Beach%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Reithwin Town]]")=Location,
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Moonrise%"  
|tables=equipment; where = where_to_find like "%Dank Crypt%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location,  
   fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Moonrise%"  
|tables=weapons; where = where_to_find like "%Dank Crypt%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location,
   fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg  
      
      
|tables=equipment; where = where_to_find like "%Grand Mausoleum%"  
|tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location,  
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Grand Mausoleum%"  
|tables=weapons; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location,
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
      
      
|tables=equipment; where = where_to_find like "%Gauntlet of Shar%"  
|tables=equipment; where = where_to_find like "%The Risen Road%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Gauntlet of Shar]]")=Location,  
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Gauntlet of Shar%"  
|tables=weapons; where = where_to_find like "%The Risen Road%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Gauntlet of Shar]]")=Location,
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = where_to_find like "%Shadowfell%"  
|tables=equipment; where = where_to_find like "%Forest%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location,  
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Shadowfell%"  
|tables=weapons; where = where_to_find like "%Forest%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location,
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
 
 
|tables=equipment; where = where_to_find like "%Mind Flayer Colony%"  
|tables=equipment; where = where_to_find like "%Owlbear Nest%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Mind Flayer Colony]]")=Location,  
   fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Mind Flayer Colony%"  
|tables=weapons; where = where_to_find like "%Forest%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Mind Flayer Colony]]")=Location,
   fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
 
   
 
|tables=equipment; where = where_to_find like "%Blighted Village%"
 
|format=dynamic table
|rows per page=1000
|hidden fields=Effects, Where To Find, Type, AC, Dmg
|column widths=6%,16%,,,,13%,4%,6%
}}
</div>
 
 
 
== <span class="mw-customtoggle-2" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Three ==
<div  id="mw-customcollapsible-2" class="mw-collapsible mw-collapsed">
 
 
{{#cargo_compound_query:
 
 
tables=equipment; where = where_to_find like "%Rivington General%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location,  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Rivington General%"  
|tables=weapons; where = where_to_find like "%Blighted Village%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location,
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
      
      
|tables=equipment; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%")
|tables=equipment; where = (where_to_find like "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location,  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%")
|tables=weapons; where = (where_to_find like "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location,
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
 
   
|tables=equipment; where = where_to_find like "%Circus of the Last Days%"  
|tables=equipment; where = where_to_find like "%Goblin Camp%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location,  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Circus of the Last Days%"  
|tables=weapons; where = where_to_find like "%Goblin Camp%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location,
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
 
   
|tables=equipment; where = where_to_find like "%Open Hand Temple%"  
|tables=equipment; where = where_to_find like "%Waukeen's Rest%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=Location,  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Open Hand Temple%"  
|tables=weapons; where = where_to_find like "%Waukeen's Rest%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=Location,
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
      
      
|tables=equipment; where = where_to_find like "%Angleiron's Cellar%"  
|tables=equipment; where = where_to_find like "%Mountain Pass%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location,  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Angleiron's Cellar%"  
|tables=weapons; where = where_to_find like "%Mountain Pass%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location,
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
      
      
|tables=equipment; where = (
   
              where_to_find like "%Rivington%" AND
|tables=equipment; where = where_to_find like "%Underdark%"  
              where_to_find NOT REGEXP "Rivington General" AND
              where_to_find NOT REGEXP "Ferg Drogher" AND
              where_to_find NOT REGEXP "Mattis" AND
              where_to_find NOT REGEXP "Circus of the Last Days" AND
              where_to_find NOT REGEXP "Open Hand Temple" AND
              where_to_find NOT REGEXP "Angleiron's Cellar")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=Location,  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = (
|tables=weapons; where = where_to_find like "%Underdark%"  
              where_to_find like "%Rivington%" AND
              where_to_find NOT REGEXP "Rivington General" AND
              where_to_find NOT REGEXP "Ferg Drogher" AND
              where_to_find NOT REGEXP "Mattis" AND
              where_to_find NOT REGEXP "Circus of the Last Days" AND
              where_to_find NOT REGEXP "Open Hand Temple" AND
              where_to_find NOT REGEXP "Angleiron's Cellar")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=Location,
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = where_to_find like "%Grymforge%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Grymforge%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Wyrm's Crossing%"  
|tables=equipment; where = where_to_find like "%Rosymorn Monastery%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=Location,  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Wyrm's Crossing%"  
|tables=weapons; where = where_to_find like "%Rosymorn Monastery%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=Location,
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%"  
|tables=equipment; where = where_to_find like "%Crèche Y'llek%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location,  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%"  
|tables=weapons; where = where_to_find like "%Crèche Y'llek%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location,
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
      
      
|tables=equipment; where = (
   
              where_to_find like "%Lower City%" AND
|format=dynamic table
              where_to_find NOT REGEXP 'Lower City Sewers' AND
|rows per page=1000
              where_to_find NOT REGEXP 'Undercity Ruins' AND
|hidden fields=Effects, Where To Find, Type, AC, Dmg
              where_to_find NOT REGEXP 'Forge of the Nine' AND
|column widths=6%,16%,,,,13%,4%,6%
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
}}
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
</div>
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
 
              where_to_find NOT REGEXP 'Wine Festival' AND
 
              where_to_find NOT REGEXP "Devil's Fee" AND
== <span class="mw-customtoggle-1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two ==
              where_to_find NOT REGEXP "The Counting House" AND
<div  id="mw-customcollapsible-1" class="mw-collapsible mw-collapsed">
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
 
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
{{#cargo_compound_query:
              where_to_find NOT REGEXP 'Undercity Ruins')
 
tables=equipment; where = where_to_find like "%Ruined Battlefield%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=Location,  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = (
|tables=weapons; where = where_to_find like "%Ruined Battlefield%"  
              where_to_find like "%Lower City%" AND
              where_to_find NOT REGEXP 'Lower City Sewers' AND
              where_to_find NOT REGEXP 'Undercity Ruins' AND
              where_to_find NOT REGEXP 'Forge of the Nine' AND
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
              where_to_find NOT REGEXP 'Wine Festival' AND
              where_to_find NOT REGEXP "Devil's Fee" AND
              where_to_find NOT REGEXP "The Counting House" AND
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
              where_to_find NOT REGEXP 'Undercity Ruins')
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=Location,
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Lower City Sewers%"  
|tables=equipment; where = where_to_find like "%Last Light Inn%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=Location,  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Lower City Sewers%"  
|tables=weapons; where = where_to_find like "%Last Light Inn%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=Location,
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
 
|tables=equipment; where = where_to_find like "%Forge of the Nine%"  
|tables=equipment; where = where_to_find like "%Reithwin Town%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=Location,  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Reithwin Town]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Forge of the Nine%"  
|tables=weapons; where = where_to_find like "%Reithwin Town%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=Location,
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Reithwin Town]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
 
|tables=equipment; where = where_to_find like "%Stormshore Tabernacle%"  
|tables=equipment; where = where_to_find like "%Moonrise%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location,  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Stormshore Tabernacle%"  
|tables=weapons; where = where_to_find like "%Moonrise%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location,
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
      
      
|tables=equipment; where = where_to_find like "%Stormshore Armoury%"  
|tables=equipment; where = where_to_find like "%Grand Mausoleum%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=Location,  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Stormshore Armoury%"  
|tables=weapons; where = where_to_find like "%Grand Mausoleum%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=Location,
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
 
   
|tables=equipment; where = where_to_find like "%Sorcerous Sundries%"  
|tables=equipment; where = where_to_find like "%Gauntlet of Shar%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=Location,  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Gauntlet of Shar]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Sorcerous Sundries%"  
|tables=weapons; where = where_to_find like "%Gauntlet of Shar%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=Location,
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Gauntlet of Shar]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
 
   
|tables=equipment; where = where_to_find like "%Wine Festival%"  
|tables=equipment; where = where_to_find like "%Shadowfell%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=Location,  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Wine Festival%"  
|tables=weapons; where = where_to_find like "%Shadowfell%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=Location,
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
 
 
|tables=equipment; where = where_to_find like "%Devil%Fee%"  
|tables=equipment; where = where_to_find like "%Mind Flayer Colony%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location,  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Mind Flayer Colony]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Devil%Fee%"  
|tables=weapons; where = where_to_find like "%Mind Flayer Colony%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location,
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Mind Flayer Colony]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%The Counting House%"  
 
     AND rarity != "common" AND legacy IS NULL;  
 
   fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=Location,  
|format=dynamic table
|rows per page=1000
|hidden fields=Effects, Where To Find, Type, AC, Dmg
|column widths=6%,16%,,,,13%,4%,6%
}}
</div>
 
 
 
== <span class="mw-customtoggle-2" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Three ==
<div  id="mw-customcollapsible-2" class="mw-collapsible mw-collapsed">
 
 
{{#cargo_compound_query:
 
 
tables=equipment; where = where_to_find like "%Rivington General%"  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%The Counting House%"  
|tables=weapons; where = where_to_find like "%Rivington General%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=Location,
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
 
   
|tables=equipment; where = where_to_find like "%Philgrave%s Mansion%"  
|tables=equipment; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location,  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Philgrave%s Mansion%"  
|tables=weapons; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location,
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
 
|tables=equipment; where = where_to_find like "%Steel Watch Foundry%"  
|tables=equipment; where = where_to_find like "%Circus of the Last Days%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=Location,  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Steel Watch Foundry%"  
|tables=weapons; where = where_to_find like "%Circus of the Last Days%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=Location,
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Undercity Ruins%"  
|tables=equipment; where = where_to_find like "%Open Hand Temple%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=Location,  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Undercity Ruins%"  
|tables=weapons; where = where_to_find like "%Open Hand Temple%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=Location,
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = where_to_find like "%Angleiron's Cellar%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Angleiron's Cellar%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = (
              where_to_find like "%Rivington%" AND
              where_to_find NOT REGEXP "Rivington General" AND
              where_to_find NOT REGEXP "Ferg Drogher" AND
              where_to_find NOT REGEXP "Mattis" AND
              where_to_find NOT REGEXP "Circus of the Last Days" AND
              where_to_find NOT REGEXP "Open Hand Temple" AND
              where_to_find NOT REGEXP "Angleiron's Cellar")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = (
              where_to_find like "%Rivington%" AND
              where_to_find NOT REGEXP "Rivington General" AND
              where_to_find NOT REGEXP "Ferg Drogher" AND
              where_to_find NOT REGEXP "Mattis" AND
              where_to_find NOT REGEXP "Circus of the Last Days" AND
              where_to_find NOT REGEXP "Open Hand Temple" AND
              where_to_find NOT REGEXP "Angleiron's Cellar")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Wyrm's Crossing%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Wyrm's Crossing%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|format=dynamic table
|tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%"
|rows per page=1000
    AND rarity != "common" AND legacy IS NULL;
|hidden fields=Effects, Where To Find, Type, AC, Dmg
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location,
|column widths=6%,16%,,,,13%,4%,6%
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
}}
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
</div>
|tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%"  
 
    AND rarity != "common" AND legacy IS NULL;
<!--
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location,
{{WeaponsTableHeader}}
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
{{#cargo_query: tables = weapons
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
| fields = _pageName=page, name, uid, image, rarity, enchantment, damage, damage_type, extra_damage, extra_damage_type, weight_kg, weight_lb, price, special, special_weapon_actions
   
| order by = rarity_order, name
|tables=equipment; where = (
| where = rarity != "common" AND legacy IS NULL AND where_to_find like "%Gauntlet of Shar%"
              where_to_find like "%Lower City%" AND
| default = {{WeaponsTableEmpty}}
              where_to_find NOT REGEXP 'Lower City Sewers' AND
| format = template
              where_to_find NOT REGEXP 'Undercity Ruins' AND
| template = WeaponsTableRow
              where_to_find NOT REGEXP 'Forge of the Nine' AND
| named args = yes
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
}}
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
{{WeaponsTableFooter}}
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
-->
              where_to_find NOT REGEXP 'Wine Festival' AND
 
              where_to_find NOT REGEXP "Devil's Fee" AND
= High Utility Permanent Bonuses =
              where_to_find NOT REGEXP "The Counting House" AND
 
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
See [[Permanent Bonuses]] or [[Permanent bonus table]] for a complete list of bonuses.
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
 
              where_to_find NOT REGEXP 'Undercity Ruins')
== <span class="mw-customtoggle-b0" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act One ==
    AND rarity != "common" AND legacy IS NULL;
<div  id="mw-customcollapsible-b0" class="mw-collapsible mw-collapsed">
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=Location,
 
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
! style="width: 14%;" | Region
|tables=weapons; where = (
! style="width: 17%;" | Location
              where_to_find like "%Lower City%" AND
! style="width: 21%;" | Bonus
              where_to_find NOT REGEXP 'Lower City Sewers' AND
! style="width: 48%;" | Description
              where_to_find NOT REGEXP 'Undercity Ruins' AND
|-
              where_to_find NOT REGEXP 'Forge of the Nine' AND
| <!-- Region -->[[Blighted Village]]
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
|| <!-- Location -->[[Apothecary's Cellar]]
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
|| <!-- Bonus -->{{SAI|Forbidden Knowledge}}
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
|| <!-- Description -->Gain +1 bonus to {{Ability|Wisdom}} {{SavingThrow}}s and [[Ability Checks]].
              where_to_find NOT REGEXP 'Wine Festival' AND
|-
              where_to_find NOT REGEXP "Devil's Fee" AND
| <!-- Region -->[[Blighted Village]]
              where_to_find NOT REGEXP "The Counting House" AND
|| <!-- Location -->[[Apothecary's Cellar]]
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
|| <!-- Bonus -->{{SAI|Speak with Dead}}
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
|| <!-- Description -->Gain {{SAI|Speak with Dead}} spell once per long rest from [[Necromancy of Thay]].
              where_to_find NOT REGEXP 'Undercity Ruins')
|-
    AND rarity != "common" AND legacy IS NULL;
| <!-- Region -->[[Goblin Camp]]
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=Location,
|| <!-- Location -->[[Shattered Sanctum#Centre|Shattered Sanctum Centre]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|| <!-- Bonus -->[[File:Absolute_symbol.png|25px]][[Absolute's Brand]]
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|| <!-- Description -->Gain the use of unique special effects on [[:Category:Absolute_Equipment|Absolute Equipment]].<br>Gain unique dialogue options with followers of the [[Absolute]].
|-
| <!-- Region -->[[Goblin Camp]]
|| <!-- Location -->[[Shattered Sanctum#East|Shattered Sanctum East]]
|| <!-- Bonus -->{{cond|See Invisibility}}
|| <!-- Description -->Grants a permanent {{cond|See Invisibility}} effect from [[Volo's Ersatz Eye (passive feature)|Volo's Ersatz Eye]].
|-
| <!-- Region -->[[Goblin Camp]]
|| <!-- Location -->[[Shattered Sanctum#East|Shattered Sanctum East]]
|| <!-- Bonus -->{{cond|Loviatar's Love}}{{note|Effect is permanently lost if the character dies and is revived.}}
|| <!-- Description -->When you have 30% [[Hit Points]] or less, you gain a '''+2''' bonus to {{Attack Roll}}s and {{Ability|Wisdom}} {{SavingThrow}}s for 3 turns.
|-
| <!-- Region -->[[Sunlit Wetlands]]
|| <!-- Location -->[[Riverside Teahouse]]
|| <!-- Bonus -->{{cond|Paid the Price}}
|| <!-- Description -->Gain +1 bonus to [[Intimidation]] checks.<br>Gain {{Disadvantage}} on [[Perception]] checks.<br>Gain {{Disadvantage}} when attacking Hags.
|-
| <!-- Region -->[[Sunlit Wetlands]]
|| <!-- Location -->[[Riverside Teahouse]]
|| <!-- Bonus -->[[File:Generic_Feature_Icon.webp|25px]][[Auntie Ethel's Hair|Auntie Ethel's Boon]]
|| <!-- Description -->Gain +1 to an [[Ability Scores|Ability Score]] of choice. Can be raised above 20.
|-
| <!-- Region -->[[Underdark]]
|| <!-- Location -->[[Myconid Colony]]
|| <!-- Bonus -->{{SAI|Survival Instinct}}
|| <!-- Description -->Gain the additional [[Illithid Powers|illithid power]] {{Icon|Cleric Tadpole Survival Instinct.png|30|link=Survival Instinct}}[[Survival Instinct]]
|-
| <!-- Region -->[[Underdark]]
|| <!-- Location -->[[The Festering Cove]]
|| <!-- Bonus -->{{Condition inline|BOOOAL's Blessing}}
|| <!-- Description -->Gain {{Advantage}} on {{Attack Roll}}s against {{cond|Bleeding}} targets.
|-
| <!-- Region -->[[Rosymorn Monastery]]
|| <!-- Location -->[[Crèche Y'llek#Infirmary|Crèche Y'llek Infirmary]]
|| <!-- Bonus -->{{SAI|Awakened}}
|| <!-- Description -->You can use all of your Illithid powers as a [[Bonus Action]].
|}
</div>


|tables=equipment; where = where_to_find like "%Lower City Sewers%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Lower City Sewers%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = where_to_find like "%Forge of the Nine%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Forge of the Nine%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = where_to_find like "%Stormshore Tabernacle%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Stormshore Tabernacle%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = where_to_find like "%Stormshore Armoury%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Stormshore Armoury%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


== <span class="mw-customtoggle-b1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two ==
|tables=equipment; where = where_to_find like "%Sorcerous Sundries%"
<div  id="mw-customcollapsible-b1" class="mw-collapsible mw-collapsed">
    AND rarity != "common" AND legacy IS NULL;
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=Location,
! style="width: 14%;" | Region
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
! style="width: 17%;" | Location
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
! style="width: 21%;" | Bonus
|tables=weapons; where = where_to_find like "%Sorcerous Sundries%"  
! style="width: 48%;" | Description
    AND rarity != "common" AND legacy IS NULL;
|-
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=Location,
| <!-- Region -->[[Ruined Battlefield]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|| <!-- Location -->[[Seek_Protection_from_the_Shadow_Curse#The lantern's power|Kar'niss]]
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|| <!-- Bonus -->{{cond|Pixie Blessing}}
|| <!-- Description -->Gain immunity to the {{cond|Shadow Curse}}.
|-
| <!-- Region -->[[Moonrise Towers]]
|| <!-- Location -->[[Moonrise Towers#Main floor|Main Floor]]
|| <!-- Bonus -->[[File:POT_Potion_of_Everlasting_Vigour_Faded.png|25px]][[Potion of Everlasting Vigour]]
|| <!-- Description -->Gain +2 {{Ability|Strength}}.
|-
| <!-- Region -->[[Moonrise Towers]]
|| <!-- Location -->[[Mind Flayer Colony]]
|| <!-- Bonus -->{{cond|Githzerai Mind Barrier}}{{note|Effect is permanently lost if the character dies and is revived.}}
|| <!-- Description -->Gain {{Advantage}} on {{Ability|Intelligence}} {{SavingThrow}}s.
|-
| <!-- Region -->[[Moonrise Towers]]
|| <!-- Location -->
|| <!-- Bonus -->{{SAI|Bardic Inspiration|Improved Bardic Inspiration}}
|| <!-- Description -->Gain a charge of Bardic Inspiration that is stronger than usual ({{DieIcon|d12|Slashing}}'''1d12''').
|-
| <!-- Region -->[[Reithwin Town]]
|| <!-- Location -->[[Find Arabella's Parents#Breaking the news|Arabella]]
|| <!-- Bonus -->{{SAI|Arabella's Shadow Entangle}}
|| <!-- Description -->Entangle an Undead or shadow creature until long rest.
|}
</div>
 


== <span class="mw-customtoggle-b2" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Three ==
|tables=equipment; where = where_to_find like "%Wine Festival%"  
<div  id="mw-customcollapsible-b2" class="mw-collapsible mw-collapsed">
    AND rarity != "common" AND legacy IS NULL;  
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=Location,
! style="width: 14%;" | Region
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
! style="width: 17%;" | Location
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
! style="width: 21%;" | Bonus
|tables=weapons; where = where_to_find like "%Wine Festival%"  
! style="width: 48%;" | Description
    AND rarity != "common" AND legacy IS NULL;
|-
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=Location,
| <!-- Region -->[[Help Your Protector|Wyrm's Lookout]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|| <!-- Location -->[[Astral Plane]]
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|| <!-- Bonus -->{{SAI|Partial Ceremorphosis}}
 
|| <!-- Description -->Gain all 5 inner ring [[Illithid_powers#List_of_illithid_powers|Tier 1 Illithid Powers]].<br>Gain access to [[Illithid_powers#Elite_Powers|Tier 3 Illithid Powers]].<br>Gain {{SAI|Fly (Illithid Power)|Fly}}.
|tables=equipment; where = where_to_find like "%Philgrave%s Mansion%"
|-
    AND rarity != "common" AND legacy IS NULL;
| <!-- Region -->[[Rivington]]
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location,
|| <!-- Location -->[[Circus of the Last Days]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|| <!-- Bonus -->{{cond|Sweet Stone Features}}
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|| <!-- Description -->Gain a {{DieIcon|d4|Slashing}} '''+1d4''' bonus to {{Attack Roll}}s and {{SavingThrow}}s.
|tables=weapons; where = where_to_find like "%Philgrave%s Mansion%"
|-
    AND rarity != "common" AND legacy IS NULL;
| <!-- Region -->[[Lower City]]
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location,
|| <!-- Location -->[[Crimson Draughts]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|| <!-- Bonus -->{{SAI|Unstable Blood}}
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|| <!-- Description -->Your blood is now highly flammable and will explode on contact with fire.
   
|-
|tables=equipment; where = where_to_find like "%Devil%Fee%"
| <!-- Region -->[[Lower City]]
    AND rarity != "common" AND legacy IS NULL;
|| <!-- Location --> [[House of Grief]]
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location,
|| <!-- Bonus -->[[Mirror of Loss|Patriar's Memory]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|| <!-- Description -->Gain +1 {{Ability|Charisma}}.
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|-
|tables=weapons; where = where_to_find like "%Devil%Fee%"
| <!-- Region -->[[Lower City]]
    AND rarity != "common" AND legacy IS NULL;
|| <!-- Location --> [[House of Grief]]
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location,
|| <!-- Bonus -->[[Mirror of Loss#Using_the_mirror|<Stolen> Memory]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|| <!-- Description -->Gain +2 to an [[Ability Score]] of your choice.
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|-
| <!-- Region -->[[Lower City]]
|| <!-- Location -->[[Ramazith's Tower]]
|| <!-- Bonus -->{{SAI|Danse Macabre}}
|| <!-- Description -->Create 4 [[ghoul|ghouls]] that fight alongside you.
|-
| <!-- Region -->[[Lower City]]
|| <!-- Location -->[[Ramazith's Tower]]
|| <!-- Bonus -->{{cond|Tharchiate Withering}}
|| <!-- Description -->Gain -5 {{Ability|Constitution}} and a sickly green aura.
|-
| <!-- Region -->[[Lower City]]
|| <!-- Location -->[[Ramazith's Tower]]
|| <!-- Bonus -->{{SAI|The Tharchiate Codex: Blessing|Tharchiate Codex: Blessing}}
|| <!-- Description -->Gain {{Cond|Tharchiate Vigour}} immediately and also once after every [[Long Rest]].
|-
| <!-- Region -->[[Lower City]]
|| <!-- Location -->[[Steel Watch Foundry]]
|| <!-- Bonus -->[[Slayer Knowledge]]
|| <!-- Description -->Gain {{Advantage}} on [[Saving Throws]] against being {{Cond|Frightened}} by a [[Bhaalspawn]] Slayer
|}


{{notelist}}
|tables=equipment; where = where_to_find like "%The Counting House%"
</div>
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%The Counting House%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = where_to_find like "%Steel Watch Foundry%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Steel Watch Foundry%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Undercity Ruins%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Undercity Ruins%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg




= Dye Previews =
|format=dynamic table
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
|rows per page=1000
! style="width: 40%;" | Medium Armour
|hidden fields=Effects, Where To Find, Type, AC, Dmg
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/medium+armour]]
|column widths=6%,16%,,,,13%,4%,6%
! style="width: 40%;" | Heavy Armour
}}
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/heavy+armour]]
</div>
|-
| {{ItemIcon|name=Chain Shirt +1|size=25|show_rarity=1}} [[Chain Shirt +1|{{RarityColor|uncommon|Chain Shirt +1}}]]
|| [https://64.media.tumblr.com/46b29ffd14bece381933372cb6a0227b/00edac1c71a28b5f-ab/s1280x1920/644dff86c07dd2ba17b768bfd1120408eccadae2.png Dyes]
||
||
|-
| {{ItemIcon|name=Chain Shirt +2|size=25|show_rarity=1}} [[Chain Shirt +1|{{RarityColor|rare|Chain Shirt +2}}]]
|| [https://64.media.tumblr.com/49c4560a04fc8198830c32ee6c5cae87/28a28e3124da3197-90/s1280x1920/2069c7673e58d43b89f2f6ba61d9f8efaa75e340.png Dyes]
|| {{ItemIcon|name=Plate Armour +2|size=25|show_rarity=1}} [[Plate Armour +1|{{RarityColor|rare|Plate Armour +2}}]]
|| [https://64.media.tumblr.com/1646e63dff137f11059102d85bbc45c6/08ccd38d3d0757c6-ee/s1280x1920/de2a864edfc4faa04febb8c721a1a64b89d04cd6.png Dyes]
|-
| {{ItemIcon|name=Dark Justiciar Half-Plate (Very Rare)|size=25|show_rarity=1}} [[Dark Justiciar Half-Plate (Very Rare)|{{RarityColor|very rare|Dark Justiciar Half Plate}}]]
|| [https://64.media.tumblr.com/f1bfc59b449900e95c0fe37bb0430560/1a42314c8972fc71-02/s1280x1920/4f0e185e431ad6f6d4f1a286c03b799330042751.png Dyes]
|| {{ItemIcon|name=Blackguard's Plate|size=25|show_rarity=1}} [[Blackguard's Plate|{{RarityColor|very rare|Blackguard's Plate}}]]
|| [https://64.media.tumblr.com/b1ce0174ed6967db06d947f2e0abe3ff/d3e2e9ec4d78abec-5a/s1280x1920/26dcb8a9b4fb177c8c464b79af0e9d6c91d612c6.png Dyes]
|}


<!--
{{WeaponsTableHeader}}
{{#cargo_query: tables = weapons
| fields = _pageName=page, name, uid, image, rarity, enchantment, damage, damage_type, extra_damage, extra_damage_type, weight_kg, weight_lb, price, special, special_weapon_actions
| order by = rarity_order, name
| where = rarity != "common" AND legacy IS NULL AND where_to_find like "%Gauntlet of Shar%"
| default = {{WeaponsTableEmpty}}
| format = template
| template = WeaponsTableRow
| named args = yes
}}
{{WeaponsTableFooter}}
-->


<!-- class="mw-collapsible mw-collapsed"-->
= High Utility Permanent Bonuses =
<!--
{{Tab
|one=The Dark Urge
|one-name=Story Spoiler Page
|two=The Dark Urge (Origin)
|two-name=Origin Page
}}


{{Infobox
See [[Permanent Bonuses]] or [[Permanent bonus table]] for a complete list of bonuses.
|name        = Infobox/doc
|bodystyle    =


|titlestyle  =  
== <span class="mw-customtoggle-b0" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act One ==
|abovestyle  = background:#cfc;
<div id="mw-customcollapsible-b0" class="mw-collapsible mw-collapsed">
|subheaderstyle =
|title        = Test Infobox
|above        = Above text
  |subheader    = Subheader above image
|subheader2  = Second subheader


|imagestyle  =  
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
|captionstyle =  
! style="width: 14%;" | Region
|image        = [[File:Example-serious.jpg|200px|alt=Example alt text]]
! style="width: 17%;" | Location
|caption      = Caption displayed below File:Example-serious.jpg
! style="width: 21%;" | Bonus
 
! style="width: 48%;" | Description
|headerstyle  = background:#ccf;
|-
|labelstyle  = background:#ddf;
| <!-- Region -->[[Blighted Village]]
|datastyle    =
|| <!-- Location -->[[Apothecary's Cellar]]
 
|| <!-- Bonus -->{{SAI|Forbidden Knowledge}}
|header1 = Header defined alone
|| <!-- Description -->Gain +1 bonus to {{Ability|Wisdom}} {{SavingThrow}}s and [[Ability Checks]].
| label1 =
|-
| data1 =
| <!-- Region -->[[Blighted Village]]
|header2 =
|| <!-- Location -->[[Apothecary's Cellar]]
| label2 = Label defined alone does not display (needs data, or is suppressed)
|| <!-- Bonus -->{{SAI|Speak with Dead}}
| data2 =
|| <!-- Description -->Gain {{SAI|Speak with Dead}} spell once per long rest from [[Necromancy of Thay]].
|header3 =
| label3 =
| data3 = Data defined alone
|header4 = All three defined (header, label, data, all with same number)
| label4 = does not display (same number as a header)
| data4 = does not display (same number as a header)
|header5 =
| label5 = Label and data defined (label)
| data5 = Label and data defined (data)
 
|belowstyle = background:#ddf;
|below      = Below text
}}
 
{| class="mw-collapsible mw-collapsed wikitable" style="margin-left:1.6em;"
|-
|-
! Header 1
| <!-- Region -->[[Goblin Camp]]
! Header 2
|| <!-- Location -->[[Shattered Sanctum#Centre|Shattered Sanctum Centre]]
|| <!-- Bonus -->[[File:Absolute_symbol.png|25px]][[Absolute's Brand]]
|| <!-- Description -->Gain the use of unique special effects on [[:Category:Absolute_Equipment|Absolute Equipment]].<br>Gain unique dialogue options with followers of the [[Absolute]].
|-
|-
| row 1, cell 1
| <!-- Region -->[[Goblin Camp]]
| row 1, cell 2
|| <!-- Location -->[[Shattered Sanctum#East|Shattered Sanctum East]]
|| <!-- Bonus -->{{cond|See Invisibility}}
|| <!-- Description -->Grants a permanent {{cond|See Invisibility}} effect from [[Volo's Ersatz Eye (passive feature)|Volo's Ersatz Eye]].
|-
|-
| row 2, cell 1
| <!-- Region -->[[Goblin Camp]]
| row 2, cell 2
|| <!-- Location -->[[Shattered Sanctum#East|Shattered Sanctum East]]
|}
|| <!-- Bonus -->{{cond|Loviatar's Love}}{{note|Effect is permanently lost if the character dies and is revived.}}
-->
|| <!-- Description -->When you have 30% [[Hit Points]] or less, you gain a '''+2''' bonus to {{Attack Roll}}s and {{Ability|Wisdom}} {{SavingThrow}}s for 3 turns.
 
<!--
 
{| class="wikitable"
|+ Equipment
! [[File:Helmet_Icon.png|50px|link=Headwear]]
!
!
|-
|-
! [[File:Cloak_B_Unfaded_Icon.png|50px|link=Cloaks]]
| <!-- Region -->[[Sunlit Wetlands]]
!  
|| <!-- Location -->[[Riverside Teahouse]]
!  
|| <!-- Bonus -->{{cond|Paid the Price}}
|| <!-- Description -->Gain +1 bonus to [[Intimidation]] checks.<br>Gain {{Disadvantage}} on [[Perception]] checks.<br>Gain {{Disadvantage}} when attacking Hags.
|-
|-
! [[File:Plate_Armour_Icon.png|50px|link=Armour]]
| <!-- Region -->[[Sunlit Wetlands]]
!  
|| <!-- Location -->[[Riverside Teahouse]]
! [[File:Amulet_Necklace_A_Gold_A_1_Unfaded_Icon.png|50px|link=Amulets]]
|| <!-- Bonus -->[[File:Generic_Feature_Icon.webp|25px]][[Auntie Ethel's Hair|Auntie Ethel's Boon]]
|| <!-- Description -->Gain +1 to an [[Ability Scores|Ability Score]] of choice. Can be raised above 20.
|-
|-
! [[File:Metallic_Gloves_Icon.png|50px|link=Handwear]]  
| <!-- Region -->[[Underdark]]
!  
|| <!-- Location -->[[Myconid Colony]]
! [[File:Ring_A_Simple_Gold_Unfaded_Icon.png|50px|link=Rings]]  
|| <!-- Bonus -->{{SAI|Survival Instinct}}
|| <!-- Description -->Gain the additional [[Illithid Powers|illithid power]] {{Icon|Cleric Tadpole Survival Instinct.png|30|link=Survival Instinct}}[[Survival Instinct]]
|-
|-
! [[File:Metallic_Boots_Icon.png|50px|link=Footwear]]
| <!-- Region -->[[Underdark]]
!  
|| <!-- Location -->[[The Festering Cove]]
!  
|| <!-- Bonus -->{{Condition inline|BOOOAL's Blessing}}
|| <!-- Description -->Gain {{Advantage}} on {{Attack Roll}}s against {{cond|Bleeding}} targets.
|-
|-
! [[File:Longsword_Item_Icon.png|50px|link=Weapons]]
| <!-- Region -->[[Rosymorn Monastery]]
! [[File:Item_WPN_HUM_Shield_D_0_Unfaded_Icon.png|50px|link=Shields]]
|| <!-- Location -->[[Crèche Y'llek#Infirmary|Crèche Y'llek Infirmary]]
! [[File:Longbow_Item_Icon.png|50px|link=Bow]]
|| <!-- Bonus -->{{SAI|Awakened}}
|| <!-- Description -->You can use all of your Illithid powers as a [[Bonus Action]].
|}
|}
</div>


= Resistance Equipment =


{{#cargo_query: tables = equipment
== <span class="mw-customtoggle-b1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two ==
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
<div  id="mw-customcollapsible-b1" class="mw-collapsible mw-collapsed">
| order by = rarity_order
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
| where = rarity != "common" AND special like "%Resistance%" AND legacy IS NULL
! style="width: 14%;" | Region
| format = table
! style="width: 17%;" | Location
}}
! style="width: 21%;" | Bonus
 
! style="width: 48%;" | Description
= Equipment By Build =
|-
=== [[Radiant]] Compound Query (testing)===
| <!-- Region -->[[Ruined Battlefield]]
{{#cargo_compound_query:
|| <!-- Location -->[[Seek_Protection_from_the_Shadow_Curse#The lantern's power|Kar'niss]]
tables=equipment;
|| <!-- Bonus -->{{cond|Pixie Blessing}}
where=rarity != "common" AND special like "%Radiant%" AND legacy IS NULL;
|| <!-- Description -->Gain immunity to the {{cond|Shadow Curse}}.
fields=CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
|-
|tables=weapons;
| <!-- Region -->[[Moonrise Towers]]
where=rarity != "common" AND special like "%Radiant%" AND legacy IS NULL
|| <!-- Location -->[[Moonrise Towers#Main floor|Main Floor]]
|format=table
|| <!-- Bonus -->[[File:POT_Potion_of_Everlasting_Vigour_Faded.png|25px]][[Potion of Everlasting Vigour]]
}}
|| <!-- Description -->Gain +2 {{Ability|Strength}}.
=== [[Radiant]] ===
|-
{{#cargo_query: tables = equipment
| <!-- Region -->[[Moonrise Towers]]
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
|| <!-- Location -->[[Mind Flayer Colony]]
| order by = rarity_order
|| <!-- Bonus -->{{cond|Githzerai Mind Barrier}}{{note|Effect is permanently lost if the character dies and is revived.}}
| where = rarity != "common" AND special like "%Radiant%" AND legacy IS NULL
|| <!-- Description -->Gain {{Advantage}} on {{Ability|Intelligence}} {{SavingThrow}}s.
| format = table
|-
}}
| <!-- Region -->[[Moonrise Towers]]
{{#cargo_query: tables = weapons
|| <!-- Location -->
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
|| <!-- Bonus -->{{SAI|Bardic Inspiration|Improved Bardic Inspiration}}
| order by = rarity_order
|| <!-- Description -->Gain a charge of Bardic Inspiration that is stronger than usual ({{DieIcon|d12|Slashing}}'''1d12''').
| where = rarity != "common" AND special like "%Radiant%" AND legacy IS NULL
|-
| format = table
| <!-- Region -->[[Reithwin Town]]
}}
|| <!-- Location -->[[Find Arabella's Parents#Breaking the news|Arabella]]
|| <!-- Bonus -->{{SAI|Arabella's Shadow Entangle}}
|| <!-- Description -->Entangle an Undead or shadow creature until long rest.
|}
</div>


=== [[Necrotic]] ===
{{SpoilerBox|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = rarity != "common" AND special like "%Necrotic%" AND legacy IS NULL
| format = table
}}
{{#cargo_query: tables = weapons
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = rarity != "common" AND special like "%Necrotic%" AND legacy IS NULL
| format = table
}}
}}


-->
== <span class="mw-customtoggle-b2" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Three ==
<!--
<div  id="mw-customcollapsible-b2" class="mw-collapsible mw-collapsed">
= Equipment By Act =
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
 
! style="width: 14%;" | Region
Equipment lists separated by Act.
! style="width: 17%;" | Location
 
! style="width: 21%;" | Bonus
== Act One ==
! style="width: 48%;" | Description
{{SpoilerBox|act=1|custom=Equipment for Act One.|
|-
[[File:Chapter 1.webp|500px|link=Act One]]
| <!-- Region -->[[Help Your Protector|Wyrm's Lookout]]
 
|| <!-- Location -->[[Astral Plane]]
{{SpoilerBox|act=1|custom=[[Headwear]].|
|| <!-- Bonus -->{{SAI|Partial Ceremorphosis}}
{{#cargo_query: tables = equipment
|| <!-- Description -->Gain all 5 inner ring [[Illithid_powers#List_of_illithid_powers|Tier 1 Illithid Powers]].<br>Gain access to [[Illithid_powers#Elite_Powers|Tier 3 Illithid Powers]].<br>Gain {{SAI|Fly (Illithid Power)|Fly}}.
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
|-
| order by = rarity_order
| <!-- Region -->[[Rivington]]
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL
|| <!-- Location -->[[Circus of the Last Days]]
| format = table
|| <!-- Bonus -->{{cond|Sweet Stone Features}}
}}
|| <!-- Description -->Gain a {{DieIcon|d4|Slashing}} '''+1d4''' bonus to {{Attack Roll}}s and {{SavingThrow}}s.
}}
|-
{{SpoilerBox|act=1|custom=[[Cloaks]].|
| <!-- Region -->[[Lower City]]
{{#cargo_query: tables = equipment
|| <!-- Location -->[[Crimson Draughts]]
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
|| <!-- Bonus -->{{SAI|Unstable Blood}}
| order by = rarity_order
|| <!-- Description -->Your blood is now highly flammable and will explode on contact with fire.
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL
|-
| format = table
| <!-- Region -->[[Lower City]]
}}
|| <!-- Location --> [[House of Grief]]
}}
|| <!-- Bonus -->[[Mirror of Loss|Patriar's Memory]]
{{SpoilerBox|act=1|custom=[[Armour]].|
|| <!-- Description -->Gain +1 {{Ability|Charisma}}.
{{#cargo_query: tables = equipment
|-
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| <!-- Region -->[[Lower City]]
| order by = rarity_order
|| <!-- Location --> [[House of Grief]]
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL
|| <!-- Bonus -->[[Mirror of Loss#Using_the_mirror|<Stolen> Memory]]
| format = table
|| <!-- Description -->Gain +2 to an [[Ability Score]] of your choice.
}}
|-
}}
| <!-- Region -->[[Lower City]]
{{SpoilerBox|act=1|custom=[[Handwear]].|
|| <!-- Location -->[[Ramazith's Tower]]
{{#cargo_query: tables = equipment
|| <!-- Bonus -->{{SAI|Danse Macabre}}
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
|| <!-- Description -->Create 4 [[ghoul|ghouls]] that fight alongside you.  
| order by = rarity_order
|-
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL
| <!-- Region -->[[Lower City]]
| format = table
|| <!-- Location -->[[Ramazith's Tower]]
}}
|| <!-- Bonus -->{{cond|Tharchiate Withering}}
}}
|| <!-- Description -->Gain -5 {{Ability|Constitution}} and a sickly green aura.
{{SpoilerBox|act=1|custom=[[Weapons]].|
|-
{{#cargo_query: tables = weapons
| <!-- Region -->[[Lower City]]
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, type=Type, special=Effects, where_to_find=Location
|| <!-- Location -->[[Ramazith's Tower]]
| order by = type
|| <!-- Bonus -->{{SAI|The Tharchiate Codex: Blessing|Tharchiate Codex: Blessing}}
| where =
|| <!-- Description -->Gain {{Cond|Tharchiate Vigour}} immediately and also once after every [[Long Rest]].
  rarity != "common"
|-
  AND legacy IS NULL
| <!-- Region -->[[Lower City]]
  AND (
|| <!-- Location -->[[Steel Watch Foundry]]
    where_to_find like "%Wilderness%" OR
|| <!-- Bonus -->[[Slayer Knowledge]]
    where_to_find like "%Underdark%" OR
|| <!-- Description -->Gain {{Advantage}} on [[Saving Throws]] against being {{Cond|Frightened}} by a [[Bhaalspawn]] Slayer
    where_to_find like "%Grymforge%" OR
|}
    where_to_find like "%Rosymorn Monastery%"
  )
| format = table
}}
}}
}}


{{notelist}}
</div>


== Act Two ==
{{SpoilerBox|act=2|custom=Equipment for Act Two.|
[[File:Chapter 2.webp|500px|link=Act Two]]




=== [[Headwear]] ===
= Dye Previews =
{{SpoilerBox|act=2|custom=[[Headwear]].|
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
{{#cargo_query: tables = equipment
! style="width: 40%;" | Medium Armour
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/medium+armour]]
| order by = rarity_order
! style="width: 40%;" | Heavy Armour
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/heavy+armour]]
| format = table
|-
}}
| {{ItemIcon|name=Chain Shirt +1|size=25|show_rarity=1}} [[Chain Shirt +1|{{RarityColor|uncommon|Chain Shirt +1}}]]
}}
|| [https://64.media.tumblr.com/46b29ffd14bece381933372cb6a0227b/00edac1c71a28b5f-ab/s1280x1920/644dff86c07dd2ba17b768bfd1120408eccadae2.png Dyes]
=== [[Cloaks]] ===
||
{{SpoilerBox|act=2|custom=[[Cloaks]].|
||
{{#cargo_query: tables = equipment
|-
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| {{ItemIcon|name=Chain Shirt +2|size=25|show_rarity=1}} [[Chain Shirt +1|{{RarityColor|rare|Chain Shirt +2}}]]
| order by = rarity_order
|| [https://64.media.tumblr.com/49c4560a04fc8198830c32ee6c5cae87/28a28e3124da3197-90/s1280x1920/2069c7673e58d43b89f2f6ba61d9f8efaa75e340.png Dyes]
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL
|| {{ItemIcon|name=Plate Armour +2|size=25|show_rarity=1}} [[Plate Armour +1|{{RarityColor|rare|Plate Armour +2}}]]
| format = table
|| [https://64.media.tumblr.com/1646e63dff137f11059102d85bbc45c6/08ccd38d3d0757c6-ee/s1280x1920/de2a864edfc4faa04febb8c721a1a64b89d04cd6.png Dyes]
}}
|-
}}
| {{ItemIcon|name=Dark Justiciar Half-Plate (Very Rare)|size=25|show_rarity=1}} [[Dark Justiciar Half-Plate (Very Rare)|{{RarityColor|very rare|Dark Justiciar Half Plate}}]]
=== [[Armour]] ===
|| [https://64.media.tumblr.com/f1bfc59b449900e95c0fe37bb0430560/1a42314c8972fc71-02/s1280x1920/4f0e185e431ad6f6d4f1a286c03b799330042751.png Dyes]
{{SpoilerBox|act=2|custom=[[Armour]].|
|| {{ItemIcon|name=Blackguard's Plate|size=25|show_rarity=1}} [[Blackguard's Plate|{{RarityColor|very rare|Blackguard's Plate}}]]
{{#cargo_query: tables = equipment
|| [https://64.media.tumblr.com/b1ce0174ed6967db06d947f2e0abe3ff/d3e2e9ec4d78abec-5a/s1280x1920/26dcb8a9b4fb177c8c464b79af0e9d6c91d612c6.png Dyes]
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
|}
| order by = rarity_order
 
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL
 
| format = table
<!-- class="mw-collapsible mw-collapsed"-->
}}
<!--
}}
{{Tab
=== [[Handwear]] ===
|one=The Dark Urge
{{SpoilerBox|act=2|custom=[[Handwear]].|
|one-name=Story Spoiler Page
{{#cargo_query: tables = equipment
|two=The Dark Urge (Origin)
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
|two-name=Origin Page
| order by = rarity_order
}}
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL
 
| format = table
{{Infobox
}}
|name        = Infobox/doc
}}
|bodystyle    =  
=== [[Weapons]] ===
{{SpoilerBox|act=2|custom=[[Weapons]].|
{{#cargo_query: tables = weapons
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = type
| where =
  rarity != "common"  
  AND legacy IS NULL
  AND (
    where_to_find like "%Ruined Battlefield%" OR
    where_to_find like "%Last Light Inn%" OR
    where_to_find like "%Reithwin Town%" OR
    where_to_find like "%Moonrise%" OR
    where_to_find like "%Grand Mausoleum%" OR
    where_to_find like "%Gauntlet of Shar%" OR
    where_to_find like "%Shadowfell%"
  )
| format = table
}}
}}


=== [[Shields]] ===
|titlestyle  =  
{{SpoilerBox|act=2|custom=[[Shields]].|
|abovestyle  = background:#cfc;
{{#cargo_query: tables = equipment
|subheaderstyle =
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
|title        = Test Infobox
| order by = rarity_order
|above        = Above text
| where =  
|subheader    = Subheader above image
  type = "Shields"
|subheader2  = Second subheader
  AND rarity != "common"
 
  AND legacy IS NULL
|imagestyle  =  
  AND (
|captionstyle =  
    where_to_find like "%Ruined Battlefield%" OR
|image        = [[File:Example-serious.jpg|200px|alt=Example alt text]]
    where_to_find like "%Last Light Inn%" OR
|caption      = Caption displayed below File:Example-serious.jpg
    where_to_find like "%Reithwin Town%" OR
 
    where_to_find like "%Moonrise%" OR
|headerstyle  = background:#ccf;
    where_to_find like "%Grand Mausoleum%" OR
|labelstyle  = background:#ddf;
    where_to_find like "%Gauntlet of Shar%" OR
|datastyle    =  
    where_to_find like "%Shadowfell%"
 
  )
|header1 = Header defined alone
| format = table
| label1 =  
|  data1 =  
|header2 =
| label2 = Label defined alone does not display (needs data, or is suppressed)
|  data2 =
|header3 =
| label3 =
|  data3 = Data defined alone
|header4 = All three defined (header, label, data, all with same number)
| label4 = does not display (same number as a header)
|  data4 = does not display (same number as a header)
|header5 =
| label5 = Label and data defined (label)
|  data5 = Label and data defined (data)
 
|belowstyle = background:#ddf;
|below      = Below text
}}
}}
}}
 
=== [[Amulets]] ===
{| class="mw-collapsible mw-collapsed wikitable" style="margin-left:1.6em;"
{{SpoilerBox|act=2|custom=[[Amulets]].|
|-
{{#cargo_query: tables = equipment
! Header 1
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
! Header 2
| order by = rarity_order
|-
| where =  
| row 1, cell 1
  type = "Amulets"
| row 1, cell 2
  AND rarity != "common"
|-
  AND legacy IS NULL
| row 2, cell 1
  AND (
| row 2, cell 2
    where_to_find like "%Ruined Battlefield%" OR
|}
    where_to_find like "%Last Light Inn%" OR
-->
    where_to_find like "%Reithwin Town%" OR
 
    where_to_find like "%Moonrise%" OR
<!--
    where_to_find like "%Grand Mausoleum%" OR
 
    where_to_find like "%Gauntlet of Shar%" OR
{| class="wikitable"
    where_to_find like "%Shadowfell%"
|+ Equipment
  )
! [[File:Helmet_Icon.png|50px|link=Headwear]]
| format = table
!
}}
!
}}
|-
=== [[Rings]] ===
! [[File:Cloak_B_Unfaded_Icon.png|50px|link=Cloaks]]
{{SpoilerBox|act=2|custom=[[Rings]].|
!
{{#cargo_query: tables = equipment
!
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
|-
| order by = rarity_order
! [[File:Plate_Armour_Icon.png|50px|link=Armour]]
| where =  
!
  type = "Rings"
! [[File:Amulet_Necklace_A_Gold_A_1_Unfaded_Icon.png|50px|link=Amulets]]
  AND rarity != "common"  
|-
  AND legacy IS NULL
! [[File:Metallic_Gloves_Icon.png|50px|link=Handwear]]
  AND (
!
    where_to_find like "%Ruined Battlefield%" OR
! [[File:Ring_A_Simple_Gold_Unfaded_Icon.png|50px|link=Rings]]
    where_to_find like "%Last Light Inn%" OR
|-
    where_to_find like "%Reithwin Town%" OR
! [[File:Metallic_Boots_Icon.png|50px|link=Footwear]]
    where_to_find like "%Moonrise%" OR
!
    where_to_find like "%Grand Mausoleum%" OR
!
    where_to_find like "%Gauntlet of Shar%" OR
|-
    where_to_find like "%Shadowfell%"
! [[File:Longsword_Item_Icon.png|50px|link=Weapons]]
  )
! [[File:Item_WPN_HUM_Shield_D_0_Unfaded_Icon.png|50px|link=Shields]]
! [[File:Longbow_Item_Icon.png|50px|link=Bow]]
|}
 
= Resistance Equipment =
 
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = rarity != "common" AND special like "%Resistance%" AND legacy IS NULL
| format = table
| format = table
}}
}}
}}
}}


 
= Equipment By Build =
 
=== [[Radiant]] Compound Query (testing)===
== Act Three ==
{{#cargo_compound_query:
{{SpoilerBox|act=3|custom=Equipment for Act Three.|
tables=equipment;
[[File:Chapter 3.webp|500px|link=Act Three]]
where=rarity != "common" AND special like "%Radiant%" AND legacy IS NULL;
 
fields=CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
 
|tables=weapons;
=== [[Headwear]] ===
where=rarity != "common" AND special like "%Radiant%" AND legacy IS NULL
{{SpoilerBox|act=3|custom=[[Headwear]].|
|format=table
}}
=== [[Radiant]] ===
{{#cargo_query: tables = equipment
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| order by = rarity_order
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL
| where = rarity != "common" AND special like "%Radiant%" AND legacy IS NULL
| format = table
| format = table
}}
}}
{{#cargo_query: tables = weapons
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = rarity != "common" AND special like "%Radiant%" AND legacy IS NULL
| format = table
}}
}}
=== [[Cloaks]] ===
 
{{SpoilerBox|act=3|custom=[[Cloaks]].|
=== [[Necrotic]] ===
{{#cargo_query: tables = equipment
{{SpoilerBox|
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL
| format = table
}}
}}
=== [[Armour]] ===
{{SpoilerBox|act=3|custom=[[Armour]].|
{{#cargo_query: tables = equipment
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| order by = rarity_order
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL
| where = rarity != "common" AND special like "%Necrotic%" AND legacy IS NULL
| format = table
| format = table
}}
}}
}}
{{#cargo_query: tables = weapons
=== [[Handwear]] ===
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location
{{SpoilerBox|act=3|custom=[[Handwear]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| order by = rarity_order
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL
| where = rarity != "common" AND special like "%Necrotic%" AND legacy IS NULL
| format = table
| format = table
}}
}}
}}
}}
=== [[Weapons]] ===
 
{{SpoilerBox|act=3|custom=[[Weapons]].|
-->
{{#cargo_query: tables = weapons
<!--
= Equipment By Act =
 
Equipment lists separated by Act.
 
== Act One ==
{{SpoilerBox|act=1|custom=Equipment for Act One.|
[[File:Chapter 1.webp|500px|link=Act One]]
 
{{SpoilerBox|act=1|custom=[[Headwear]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = type
| order by = rarity_order
| where =  
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL
  rarity != "common"  
  AND legacy IS NULL
  AND (
    where_to_find like "%Rivington%"
  )
| format = table
| format = table
}}
}}
}}
}}
 
{{SpoilerBox|act=1|custom=[[Cloaks]].|
=== [[Shields]] ===
{{SpoilerBox|act=3|custom=[[Shields]].|
{{#cargo_query: tables = equipment
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| order by = rarity_order
| where =  
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL
  type = "Shields"  
| format = table
   AND rarity != "common"  
}}
}}
{{SpoilerBox|act=1|custom=[[Armour]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL
| format = table
}}
}}
{{SpoilerBox|act=1|custom=[[Handwear]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL
| format = table
}}
}}
{{SpoilerBox|act=1|custom=[[Weapons]].|
{{#cargo_query: tables = weapons
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, type=Type, special=Effects, where_to_find=Location
| order by = type
| where =
   rarity != "common"  
   AND legacy IS NULL
   AND legacy IS NULL
   AND (
   AND (
     where_to_find like "%Rivington%"
     where_to_find like "%Wilderness%" OR
    where_to_find like "%Underdark%" OR
    where_to_find like "%Grymforge%" OR
    where_to_find like "%Rosymorn Monastery%"
  )
| format = table
}}
}}
}}
 
 
== Act Two ==
{{SpoilerBox|act=2|custom=Equipment for Act Two.|
[[File:Chapter 2.webp|500px|link=Act Two]]
 
 
=== [[Headwear]] ===
{{SpoilerBox|act=2|custom=[[Headwear]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL
| format = table
}}
}}
=== [[Cloaks]] ===
{{SpoilerBox|act=2|custom=[[Cloaks]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL
| format = table
}}
}}
=== [[Armour]] ===
{{SpoilerBox|act=2|custom=[[Armour]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL
| format = table
}}
}}
=== [[Handwear]] ===
{{SpoilerBox|act=2|custom=[[Handwear]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL
| format = table
}}
}}
=== [[Weapons]] ===
{{SpoilerBox|act=2|custom=[[Weapons]].|
{{#cargo_query: tables = weapons
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = type
| where =
  rarity != "common"
  AND legacy IS NULL
  AND (
    where_to_find like "%Ruined Battlefield%" OR
    where_to_find like "%Last Light Inn%" OR
    where_to_find like "%Reithwin Town%" OR
    where_to_find like "%Moonrise%" OR
    where_to_find like "%Grand Mausoleum%" OR
    where_to_find like "%Gauntlet of Shar%" OR
    where_to_find like "%Shadowfell%"
  )
| format = table
}}
}}
 
=== [[Shields]] ===
{{SpoilerBox|act=2|custom=[[Shields]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where =
  type = "Shields"
  AND rarity != "common"
  AND legacy IS NULL
  AND (
    where_to_find like "%Ruined Battlefield%" OR
    where_to_find like "%Last Light Inn%" OR
    where_to_find like "%Reithwin Town%" OR
    where_to_find like "%Moonrise%" OR
    where_to_find like "%Grand Mausoleum%" OR
    where_to_find like "%Gauntlet of Shar%" OR
    where_to_find like "%Shadowfell%"
   )
   )
| format = table
| format = table
Line 1,691: Line 1,845:
}}
}}
=== [[Amulets]] ===
=== [[Amulets]] ===
{{SpoilerBox|act=3|custom=[[Amulets]].|
{{SpoilerBox|act=2|custom=[[Amulets]].|
{{#cargo_query: tables = equipment
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| order by = rarity_order
| where =  
| where =
   type = "Amulets"  
  type = "Amulets"
   AND rarity != "common"  
  AND rarity != "common"
   AND legacy IS NULL
  AND legacy IS NULL
   AND (
  AND (
     where_to_find like "%Rivington%"
    where_to_find like "%Ruined Battlefield%" OR
   )
    where_to_find like "%Last Light Inn%" OR
| format = table
    where_to_find like "%Reithwin Town%" OR
}}
    where_to_find like "%Moonrise%" OR
}}
    where_to_find like "%Grand Mausoleum%" OR
=== [[Rings]] ===
    where_to_find like "%Gauntlet of Shar%" OR
{{SpoilerBox|act=3|custom=[[Rings]].|
    where_to_find like "%Shadowfell%"
{{#cargo_query: tables = equipment
  )
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| format = table
| order by = rarity_order
}}
| where =  
}}
   type = "Rings"  
=== [[Rings]] ===
   AND rarity != "common"  
{{SpoilerBox|act=2|custom=[[Rings]].|
   AND legacy IS NULL
{{#cargo_query: tables = equipment
   AND (
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
     where_to_find like "%Rivington%"
| order by = rarity_order
   )
| where =
| format = table
  type = "Rings"
}}
  AND rarity != "common"
  AND legacy IS NULL
  AND (
    where_to_find like "%Ruined Battlefield%" OR
    where_to_find like "%Last Light Inn%" OR
    where_to_find like "%Reithwin Town%" OR
    where_to_find like "%Moonrise%" OR
    where_to_find like "%Grand Mausoleum%" OR
    where_to_find like "%Gauntlet of Shar%" OR
    where_to_find like "%Shadowfell%"
  )
| format = table
}}
}}
}}
 
 
 
== Act Three ==
{{SpoilerBox|act=3|custom=Equipment for Act Three.|
[[File:Chapter 3.webp|500px|link=Act Three]]
 
 
=== [[Headwear]] ===
{{SpoilerBox|act=3|custom=[[Headwear]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL
| format = table
}}
}}
=== [[Cloaks]] ===
{{SpoilerBox|act=3|custom=[[Cloaks]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL
| format = table
}}
}}
=== [[Armour]] ===
{{SpoilerBox|act=3|custom=[[Armour]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL
| format = table
}}
}}
=== [[Handwear]] ===
{{SpoilerBox|act=3|custom=[[Handwear]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL
| format = table
}}
}}
=== [[Weapons]] ===
{{SpoilerBox|act=3|custom=[[Weapons]].|
{{#cargo_query: tables = weapons
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = type
| where =
  rarity != "common"
  AND legacy IS NULL
  AND (
    where_to_find like "%Rivington%"
  )
| format = table
}}
}}
 
=== [[Shields]] ===
{{SpoilerBox|act=3|custom=[[Shields]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where =
  type = "Shields"
  AND rarity != "common"
  AND legacy IS NULL
  AND (
    where_to_find like "%Rivington%"
  )
| format = table
}}
}}
=== [[Amulets]] ===
{{SpoilerBox|act=3|custom=[[Amulets]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where =  
   type = "Amulets"  
   AND rarity != "common"  
   AND legacy IS NULL
   AND (
     where_to_find like "%Rivington%"
   )
| format = table
}}
}}
=== [[Rings]] ===
{{SpoilerBox|act=3|custom=[[Rings]].|
{{#cargo_query: tables = equipment
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| order by = rarity_order
| where =  
   type = "Rings"  
   AND rarity != "common"  
   AND legacy IS NULL
   AND (
     where_to_find like "%Rivington%"
   )
| format = table
}}
}}
}}
 
-->
 
= Stats Equipment =
 
{{ImageLocation|Strength_Score_Icon.png|Strength|
<hr>
'''Bonus'''
<hr>
{{RarityItem|Gauntlets of Hill Giant Strength|20}}
{{RarityItem|The Mighty Cloth|20}}
<hr>
'''Advantage'''
<hr>
{{RarityItem|The Mighty Cloth|20}}
}}
{{ImageLocation|Dexterity_Score_Icon.png|Dexterity|
<hr>
'''Bonus'''
<hr>
{{RarityItem|Gloves of Dexterity|20}}<br>
{{RarityItem|The Graceful Cloth|20}}
<hr>
'''Advantage'''
<hr>
{{RarityItem|The Graceful Cloth|20}}
}}
{{ImageLocation|Intelligence_Score_Icon.png|Intelligence|
<hr>
'''Bonus'''
<hr>
{{RarityItem|Warped Headband of Intellect|20}}
}}
<hr>
{{ImageLocation|Stealth_Icon.png|Stealth|Dexterity
<hr>
'''Bonus'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
'''Advantage'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
'''No Disadvantage'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Stealth%" AND special like "%Disadvantage%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Stealth%" AND special like "%Disadvantage%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Sleight_of_Hand_Icon.png|Sleight of Hand|Dexterity
<hr>
'''Bonus'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Sleight%" AND special NOT REGEXP "Advantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Sleight%" AND special NOT REGEXP "Advantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
'''Advantage'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Sleight%" AND special like "%Advantage%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Sleight%" AND special like "%Advantage%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Arcana_Icon.png|Arcana|Intelligence
<hr>
'''Bonus'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
}}
}}


-->
[[Template:ImageLocation]]
[[Template:ImageLocation]]
[[Special:CargoTables]] [[Special:Drilldown]]
[[Special:CargoTables]] [[Special:Drilldown]]
{{Gameplay mechanics}}
{{Gameplay mechanics}}

Latest revision as of 05:39, 19 February 2024


Chronology[edit | edit source]

Act One[edit | edit source]

An image of the location "Prologue"

Prologue

The player arrives on the Nautiloid immediately after character creation.

Nautiloid

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Overgrown Ruins"

Overgrown Ruins

The remnants of what appears to have once been a chapel, eroded by time.

Dank Crypt

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Dank Crypt%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Emerald Grove"

Emerald Grove

The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.

Sold by Arron

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND 
   where_to_find like "%Arron%") AND 
   where_to_find NOT REGEXP "Strange Ox"
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Sold by Dammon

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND 
   where_to_find like "%Dammon%") AND 
   where_to_find NOT REGEXP "Strange Ox"
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Sold by Auntie Ethel

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND 
   where_to_find like "%Auntie Ethel%") AND 
   where_to_find NOT REGEXP "Strange Ox"
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Sold by Volo

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND 
   where_to_find like "%Volo%") AND 
   where_to_find NOT REGEXP "Strange Ox"
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Druid Grove

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND 
   where_to_find NOT REGEXP "Dammon" AND 
   where_to_find NOT REGEXP "Arron" AND 
   where_to_find NOT REGEXP "Auntie Ethel" AND 
   where_to_find NOT REGEXP "Volo") OR
   where_to_find like "%Strange Ox%")
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Forest"

Forest

Forest is a sub-area of the Wilderness. It is found west of the Emerald Grove.

Forest

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Forest%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Owlbear Nest

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Owlbear Nest%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "The Risen Road"

The Risen Road

The Risen Road is a long stretch of road that connects Elturel and Baldur's Gate.

The Risen Road

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Risen Road%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Arcane Tower"

Arcane Tower

An isolated wizard tower deep in the Underdark protected by Arcane Cannons

Arcane Tower

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Arcane Tower%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100


Act Two[edit | edit source]

An image of the location "Grand Mausoleum"

Grand Mausoleum

The Thorm family mausoleum, resting place of Melodia Thorm and entrance to the Gauntlet of Shar
Gauntlet of Shar


Act Three[edit | edit source]


Wyrm's Crossing

An image of the location "Rivington"

Rivington

The southern-most district of Baldur's Gate, located south of Wyrm's Crossing.

Rivington

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

             where_to_find like "%Rivington%" AND 
             where_to_find NOT REGEXP "Rivington General" AND 
             where_to_find NOT REGEXP "Ferg Drogher" AND 
             where_to_find NOT REGEXP "Mattis" AND 
             where_to_find NOT REGEXP "Circus of the Last Days" AND 
             where_to_find NOT REGEXP "Open Hand Temple" AND 
             where_to_find NOT REGEXP "Angleiron's Cellar")
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Rivington General"

Rivington General

The general store in Rivington, run by a Dragonborn Exxvikyap.

Sold by Exxvikyap

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   where_to_find like "%Rivington General%" AND 
   where_to_find like "%Exxvikyap%" AND 
   (where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%"))
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Rivington General

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   where_to_find like "%Rivington General%" AND 
   where_to_find NOT REGEXP "Purchased" AND 
   where_to_find NOT REGEXP "Sold" AND 
   where_to_find NOT REGEXP "bought")
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Requisitioned Barn"

Requisitioned Barn

The Requisitioned Barn is a donation center for refugees heading to Baldur's Gate.

Sold by Ferg Drogher

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Ferg Drogher%") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Sold by Mattis

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Mattis%Rivington%") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Circus of the Last Days"

Circus of the Last Days

An extraplanar circus which moves from plane to plane, "thrilling all" who stop by.

Sold by Popper

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Circus of the Last Days

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100


An image of the location "Open Hand Temple"

Open Hand Temple

A temple dedicated to Ilmater, currently grieving the loss of their head priest.

Open Hand Temple

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Angleiron's Cellar"

Angleiron's Cellar

The Ironhand Gnomes who escaped the Grymforge have taken up residence in this cellar.

Sold by Bumpnagel

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Angleiron's Cellar%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Wyrm's Crossing"

Wyrm's Crossing

Sits between Rivington and the Wyrm's Rock Fortress, and must be crossed to enter the City.

Sold by Entharl Danthelon

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Wyrm's Crossing

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Wyrm's Rock Fortress"

Wyrm's Rock Fortress

Connected to the south by Wyrm's Crossing, and the north by the Lower City.

Sold by Arkleia Oloril

No special equipment

Wyrm's Rock Fortress

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Wyrm's Rock Fortress%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100


Lower City

An image of the location "Lower City"

Lower City

The Lower City is accessed after passing through Wyrm's Rock Fortress.

Lower City

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

             where_to_find like "%Lower City%" AND 
             where_to_find NOT REGEXP 'Lower City Sewers' AND 
             where_to_find NOT REGEXP 'Undercity Ruins' AND 
             where_to_find NOT REGEXP 'Forge of the Nine' AND 
             where_to_find NOT REGEXP 'Stormshore Tabernacle' AND 
             where_to_find NOT REGEXP 'Stormshore Armoury' AND 
             where_to_find NOT REGEXP 'Sorcerous Sundries' AND 
             where_to_find NOT REGEXP 'Wine Festival' AND 
             where_to_find NOT REGEXP "Devil's Fee" AND 
             where_to_find NOT REGEXP "Philgrave's Mansion" AND 
             where_to_find NOT REGEXP 'Steel Watch Foundry' AND 
             where_to_find NOT REGEXP 'Undercity Ruins')
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Stormshore Tabernacle"

Stormshore Tabernacle

A house of worship located in the northeastern part of the Lower City, near the Basilisk Gate.

Stormshore Tabernacle

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Stormshore Tabernacle%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Elfsong Tavern"

Elfsong Tavern

A tavern located north-west of Stormshore Tabernacle and the Basilisk Gate waypoint

Elfsong Tavern Basement

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Elfsong Tavern Basement%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Knights of the Shield Hideout

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Knights of the Shield Hideout%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Lower City Sewers"

Lower City Sewers

Entrances include manhole covers in the city streets, and inside specific buildings.

Sold by Severn

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Severn%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Sold by Sticky Dondo

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Sticky Dondo%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Sold by Voiceless Penitent Bareki

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Bareki%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Lower City Sewers

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   where_to_find like "%Lower City Sewers%" AND
   where_to_find NOT REGEXP "Severn" AND
   where_to_find NOT REGEXP "Sticky Dondo" AND
   where_to_find NOT REGEXP "Bareki")
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Undercity Ruins

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   where_to_find like "%Undercity Ruins%" AND
   where_to_find NOT REGEXP "Severn" AND
   where_to_find NOT REGEXP "Sticky Dondo" AND
   where_to_find NOT REGEXP "Bareki")
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100


An image of the location "Forge of the Nine"

Forge of the Nine

The outside of the Forge of the Nine. A stone patio is equipped with a forge and smithing station.

Sold by Dammon

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Basement

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon') 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Devil's Fee"

Devil's Fee

Owned by Helsik, there are all sorts of devilish artifacts and curios on display around the store.

Sold by Helsik

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Devil's Fee

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100


An image of the location "Stormshore Armoury"

Stormshore Armoury

An outdoor smithy with a glowing red hot furnace in the back corner.

Sold by Gloomy Fentonson

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Sold by Fytz The Firecracker

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%") 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Sorcerous Sundries"

Sorcerous Sundries

A large magical marketplace, and home to the wizard Lorroakan

Sold by Lorroakan's Projection (or Rolan)

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   where_to_find like "%Sorcerous Sundries%" AND
   where_to_find like "%Sold%" AND
   where_to_find like "%Lorroakan's Projection%")
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Sold by Tolna Tome-Monger

No special equipment

Sorcerous Sundries

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   where_to_find like "%Sorcerous Sundries%" AND
   where_to_find NOT REGEXP "Sold" AND
   where_to_find NOT REGEXP "Sorcerous Vault")
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Ramazith's Tower"

Ramazith's Tower

The home of the wizard Lorroakan, only accessible from Sorcerous Sundries.

Ramazith's Tower

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Ramazith's Tower%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

An image of the location "Sorcerous Vault"

Sorcerous Vault

A secret vault within Sorcerous Sundries accessible from Ramazith's Tower.

Sorcerous Vault

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Sorcerous Vault%" 

   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100


The Tharchiate Codex


An image of the location "Philgrave's Mansion"

Philgrave's Mansion

Located by the waterfront next to the Counting House and Felogyr's Fireworks

Sold by Mystic Carrion

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   where_to_find like "%Philgrave's Mansion%" AND
   (where_to_find like "%Sold%" OR where_to_find like "%bought%") AND
   where_to_find like "%Mystic Carrion%")
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100

Philgrave's Mansion

Error 1054: Unknown column 'where_to_find' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE ( 

   where_to_find like "%Philgrave's Mansion%" AND
   where_to_find NOT REGEXP "Sold" AND
   where_to_find NOT REGEXP "bought")
   AND rarity != "common" AND legacy IS NULL  ORDER BY `type` LIMIT 100


Equipment By Act and Region[edit | edit source]

[Show/hide] Act One[edit | edit source]

Error: No field named "where_to_find" found for any of the specified database tables.


[Show/hide] Act Two[edit | edit source]

Error: No field named "where_to_find" found for any of the specified database tables.


[Show/hide] Act Three[edit | edit source]


Error: No field named "where_to_find" found for any of the specified database tables.


High Utility Permanent Bonuses[edit | edit source]

See Permanent Bonuses or Permanent bonus table for a complete list of bonuses.

[Show/hide] Act One[edit | edit source]

Region Location Bonus Description
Blighted Village Apothecary's Cellar Forbidden Knowledge Forbidden Knowledge Gain +1 bonus to Wisdom Wisdom Saving throws and Ability Checks.
Blighted Village Apothecary's Cellar Speak with Dead Speak with Dead Gain Speak with Dead Speak with Dead spell once per long rest from Necromancy of Thay.
Goblin Camp Shattered Sanctum Centre Absolute symbol.pngAbsolute's Brand Gain the use of unique special effects on Absolute Equipment.
Gain unique dialogue options with followers of the Absolute.
Goblin Camp Shattered Sanctum East See Invisibility See Invisibility Grants a permanent See Invisibility See Invisibility effect from Volo's Ersatz Eye.
Goblin Camp Shattered Sanctum East Loviatar's Love Loviatar's Love[note 1] When you have 30% Hit Points or less, you gain a +2 bonus to Attack rolls and Wisdom Wisdom Saving throws for 3 turns.
Sunlit Wetlands Riverside Teahouse Paid the Price Paid the Price Gain +1 bonus to Intimidation checks.
Gain Disadvantage Icon.png Disadvantage on Perception checks.
Gain Disadvantage Icon.png Disadvantage when attacking Hags.
Sunlit Wetlands Riverside Teahouse Generic Feature Icon.webpAuntie Ethel's Boon Gain +1 to an Ability Score of choice. Can be raised above 20.
Underdark Myconid Colony Survival Instinct Survival Instinct Gain the additional illithid power Survival InstinctSurvival Instinct
Underdark The Festering Cove BOOOAL's Blessing BOOOAL's Blessing Gain Advantage Icon.png Advantage on Attack rolls against Bleeding Bleeding targets.
Rosymorn Monastery Crèche Y'llek Infirmary Awakened Awakened You can use all of your Illithid powers as a Bonus Action.


[Show/hide] Act Two[edit | edit source]

Region Location Bonus Description
Ruined Battlefield Kar'niss Pixie Blessing Pixie Blessing Gain immunity to the Shadow Curse Shadow Curse.
Moonrise Towers Main Floor POT Potion of Everlasting Vigour Faded.pngPotion of Everlasting Vigour Gain +2 Strength Strength.
Moonrise Towers Mind Flayer Colony Githzerai Mind Barrier Githzerai Mind Barrier[note 2] Gain Advantage Icon.png Advantage on Intelligence Intelligence Saving throws.
Moonrise Towers Improved Bardic Inspiration Improved Bardic Inspiration Gain a charge of Bardic Inspiration that is stronger than usual (D12 Slashing.png1d12).
Reithwin Town Arabella Arabella's Shadow Entangle Arabella's Shadow Entangle Entangle an Undead or shadow creature until long rest.


[Show/hide] Act Three[edit | edit source]

Region Location Bonus Description
Wyrm's Lookout Astral Plane Partial Ceremorphosis Partial Ceremorphosis Gain all 5 inner ring Tier 1 Illithid Powers.
Gain access to Tier 3 Illithid Powers.
Gain Fly Fly.
Rivington Circus of the Last Days Sweet Stone Features Sweet Stone Features Gain a D4 Slashing.png +1d4 bonus to Attack rolls and Saving throws.
Lower City Crimson Draughts Unstable Blood Unstable Blood Your blood is now highly flammable and will explode on contact with fire.
Lower City House of Grief Patriar's Memory Gain +1 Charisma Charisma.
Lower City House of Grief <Stolen> Memory Gain +2 to an Ability Score of your choice.
Lower City Ramazith's Tower Danse Macabre Danse Macabre Create 4 ghouls that fight alongside you.
Lower City Ramazith's Tower Tharchiate Withering Tharchiate Withering Gain -5 Constitution Constitution and a sickly green aura.
Lower City Ramazith's Tower Tharchiate Codex: Blessing Tharchiate Codex: Blessing Gain Tharchiate Vigour Tharchiate Vigour immediately and also once after every Long Rest.
Lower City Steel Watch Foundry Slayer Knowledge Gain Advantage Icon.png Advantage on Saving Throws against being Frightened Frightened by a Bhaalspawn Slayer
  1. ↑ Effect is permanently lost if the character dies and is revived.
  2. ↑ Effect is permanently lost if the character dies and is revived.


Dye Previews[edit | edit source]

Medium Armour Dark Amethyst Dye Detail.png Heavy Armour Dark Amethyst Dye Detail.png
Chain Shirt +1 Dyes
Chain Shirt +2 Dyes Plate Armour +2 Dyes
Dark Justiciar Half Plate Dyes Blackguard's Plate Dyes



Stats Equipment[edit | edit source]

An image of the location "Strength"

Strength

Bonus

Gauntlets of Hill Giant Strength The Mighty Cloth

Advantage

The Mighty Cloth

An image of the location "Dexterity"

Dexterity

Bonus

Gloves of Dexterity
The Graceful Cloth

Advantage

The Graceful Cloth

An image of the location "Intelligence"

Intelligence

Bonus

Warped Headband of Intellect

An image of the location "Stealth"

Stealth

Dexterity

Bonus

Scarlet Leather Armour Icon.pngShadeclinger Armour
Drow Studded Leather Armour Icon.pngDrow Studded Leather Armour
Ring I 1 Faded.pngSmuggler's Ring
Safeguard Shield Icon.pngGloomstrand Shield

Advantage

Elegant Studded Leather Icon.pngElegant Studded Leather
Shortsword PlusOne Icon.pngAssassin's Shortsword

No Disadvantage

Plate Armour Icon.pngProtective Plate

An image of the location "Sleight of Hand"

Sleight of Hand

Dexterity

Bonus

Gloves Leather 2 Faded.pngWinkling Gloves
Gloves Leather H Faded.pngDark Displacement Gloves
Gloves Leather G Faded.pngNimblefinger Gloves
Gloves Leather 2 Faded.pngKnock Knuckle Gloves
Gloves Leather 1 Faded.pngGloves of Power
Gloves Monk Faded.pngUnlucky Thief's Gloves
Ring I 1 Faded.pngSmuggler's Ring

Advantage

Gloves of Thievery Icon.pngGloves of Thievery

An image of the location "Arcana"

Arcana

Intelligence

Bonus

Ring C Silver A Faded.pngMage's Friend


Template:ImageLocation Special:CargoTables Special:Drilldown

Retrieved from "https://bg3.wiki/w/index.php?title=User:Korgat&oldid=153815"