Editing User:Korgat

Jump to navigation Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
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>
Sold by [[Arron]]
[[Druid Grove]]
<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 like "%Arron%") AND
     where_to_find NOT REGEXP "Dammon") OR
     where_to_find NOT REGEXP "Strange Ox"
     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 = (
|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 like "%Arron%") AND
     where_to_find NOT REGEXP "Dammon") OR
     where_to_find NOT REGEXP "Strange Ox"
     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 73: Line 74:
|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>
Sold by [[Auntie Ethel]]
[[The Risen Road]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = where_to_find like "%The Risen Road%"
    (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 = (
|tables=weapons; where = where_to_find like "%The Risen Road%"
    (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 92: Line 89:
|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>
Sold by [[Volo]]
[[Forest]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = where_to_find like "%Forest%"
    (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 = (
|tables=weapons; where = where_to_find like "%Forest%"
    (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 112: Line 105:
}}
}}
<hr>
<hr>
[[Druid Grove]]
[[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 "%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 = (
|tables=weapons; where = where_to_find like "%Owlbear Nest%"
    ((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 137: Line 118:
}}
}}
}}
}}
{{ImageLocation|Forest.jpg|Forest|Forest is a sub-area of the Wilderness. It is found west of the Emerald Grove.<br>
<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>
[[Forest]]
[[Rivington]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Forest%"
tables=equipment; where = (
     AND rarity != "common" AND legacy IS NULL;  
              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("[[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 "%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 151: Line 156:
|delimiter=<br>
|delimiter=<br>
}}
}}
}}
{{ImageLocation|Rivington General.jpg|Rivington General|The general store in [[Rivington]], run by a Dragonborn [[Exxvikyap]].<br>
<hr>
<hr>
[[Owlbear Nest]]
[[Rivington General]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Owlbear Nest%"
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 "%Owlbear Nest%"
|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 164: Line 179:
|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 [[Exxvikyap]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Risen Road%"
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 "%Risen Road%"
|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 180: Line 199:
}}
}}
}}
}}
{{ImageLocation|Arcane Tower.jpg|Arcane Tower|An isolated wizard tower deep in the [[Underdark]] protected by Arcane Cannons<br>
{{ImageLocation|Requisitioned Barn.jpg|Requisitioned Barn|The '''Requisitioned Barn''' is a donation center for refugees heading to Baldur's Gate.<br>
<hr>
<hr>
[[Arcane Tower]]
Sold by [[Ferg Drogher]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Arcane Tower%"
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 "%Arcane Tower%"
|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 194: Line 213:
|delimiter=<br>
|delimiter=<br>
}}
}}
|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]] ==
<br>
<hr>
<hr>
<hr>
Sold by [[Mattis]]
'''Wyrm's Crossing'''
<hr>
<hr>
{{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br>
<hr>
[[Rivington]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = (where_to_find like "%Mattis%Rivington%")
              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 = (
|tables=weapons; where = (where_to_find like "%Mattis%Rivington%")
              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 238: Line 227:
}}
}}
}}
}}
{{ImageLocation|Rivington General.jpg|Rivington General|The general store in [[Rivington]], run by a Dragonborn [[Exxvikyap]].<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 [[Exxvikyap]]
[[Circus of the Last Days]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = where_to_find like "%Circus of the Last Days%"
    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
|tables=weapons; where = (
|tables=weapons; where = where_to_find like "%Circus of the Last Days%"
    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 258: Line 241:
|delimiter=<br>
|delimiter=<br>
}}
}}
}}
<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>
[[Rivington General]]
[[Open Hand Temple]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = where_to_find like "%Open Hand Temple%"
    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 "%Open Hand Temple%"
    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 280: Line 258:
}}
}}
}}
}}
{{ImageLocation|Requisitioned Barn.jpg|Requisitioned Barn|The '''Requisitioned Barn''' is a donation center for refugees heading to Baldur's Gate.<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 [[Ferg Drogher]]
[[Angleiron's Cellar]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Ferg Drogher%")
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 "%Ferg Drogher%")
|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 294: Line 272:
|delimiter=<br>
|delimiter=<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>
Sold by [[Mattis]]
[[Wyrm's Crossing]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Mattis%Rivington%")
tables=equipment; where = where_to_find like "%Wyrm's Crossing%"
     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 "%Mattis%Rivington%")
|tables=weapons; where = where_to_find like "%Wyrm's Crossing%"
     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 308: Line 288:
}}
}}
}}
}}
{{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>
{{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>
Sold by [[Popper]]
[[Wyrm's Rock Fortress]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%")
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 "%Circus of the Last Days%" AND where_to_find like "%Popper%")
|tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Circus of the Last Days]]
<hr>
{{#cargo_compound_query:
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;
  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")
     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 337: Line 304:
}}
}}
<br>
<br>
{{ImageLocation|Open Hand Temple.jpg|Open Hand Temple|A temple dedicated to Ilmater, currently grieving the loss of their head priest.<br>
{{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br>
<hr>
<hr>
[[Open Hand Temple]]
[[Lower City]]
<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 "%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 "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes")
|tables=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;
     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 352: Line 343:
}}
}}
}}
}}
{{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>
Sold by [[Bumpnagel]]
[[Stormshore Tabernacle]]
<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 "%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 "%Angleiron's Cellar%"
|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 367: Line 358:
}}
}}
}}
}}
{{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|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 [[Entharl Danthelon]]
[[Elfsong_Tavern#Elfsong_Tavern_Basement|Elfsong Tavern Basement]]
<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 "%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 "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
|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 382: Line 373:
}}
}}
<hr>
<hr>
[[Wyrm's Crossing]]
[[Knights of the Shield Hideout]]
<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 "%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 "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
|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 395: Line 386:
}}
}}
}}
}}
{{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|Lower City Sewers North.jpg|Lower City Sewers|Entrances include manhole covers in the city streets, and inside specific buildings.<br>
<hr>
<hr>
Sold by [[Arkleia Oloril]]
[[Lower City Sewers]]
<hr>
<hr>
<i>No special equipment</i>
{{#cargo_compound_query:
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>
[[Wyrm's Rock Fortress]]
[[Undercity Ruins]]
<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 "%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 "%Wyrm's Rock Fortress%"
|tables=weapons; where = where_to_find like "%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
Line 415: 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>
'''Lower City'''
{{#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;
  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 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]]
<hr>
<hr>
{{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br>
{{#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;
  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')
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br>
<hr>
<hr>
[[Lower City]]
Sold by [[Gloomy Fentonson]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
              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 "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
              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
Line 458: Line 457:
|delimiter=<br>
|delimiter=<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 [[Fytz|Fytz The Firecracker]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Stormshore Tabernacle%"
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("[[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 "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
     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 474: Line 471:
}}
}}
}}
}}
{{ImageLocation|Elfsong Tavern Street View.jpg|Elfsong Tavern|A tavern located north-west of [[Stormshore Tabernacle]] and the Basilisk Gate [[waypoint]]<br>
{{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br>
<hr>
<hr>
[[Elfsong_Tavern#Elfsong_Tavern_Basement|Elfsong Tavern Basement]]
[[Sorcerous Sundries]]
<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 "%Sorcerous Sundries%"
     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 "%Sorcerous Sundries%"
     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 488: Line 485:
|delimiter=<br>
|delimiter=<br>
}}
}}
<hr>
}}
[[Knights of the Shield Hideout]]
 
<hr>
= 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:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Knights of the Shield Hideout%"
 
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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location,
|tables=weapons; where = where_to_find like "%Knights of the Shield Hideout%"
    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 "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
     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("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
 
}}
|tables=equipment; where = where_to_find like "%Ravaged Beach%"
{{ImageLocation|Lower City Sewers North.jpg|Lower City Sewers|Entrances include manhole covers in the city streets, and inside specific buildings.<br>
<hr>
Sold by [[Severn]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Severn%"
     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("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location,
|tables=weapons; where = where_to_find like "%Severn%"
    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 "%Ravaged Beach%"
     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("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
 
<hr>
|tables=equipment; where = where_to_find like "%Dank Crypt%"
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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location,
|tables=weapons; where = where_to_find like "%Sticky Dondo%"
    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 "%Dank Crypt%"
     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("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg   
}}
   
<hr>
|tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location,
|tables=weapons; where = where_to_find like "%Bareki%"
    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 "%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("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
   
<hr>
|tables=equipment; where = where_to_find like "%The Risen Road%"
[[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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location,
|tables=weapons; where = (
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    where_to_find like "%Lower City Sewers%" AND
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
    where_to_find NOT REGEXP "Severn" AND
|tables=weapons; where = where_to_find like "%The Risen Road%"
    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("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
<hr>
|tables=equipment; where = where_to_find like "%Forest%"
[[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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location,
|tables=weapons; where = (
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    where_to_find like "%Undercity Ruins%" AND
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
    where_to_find NOT REGEXP "Severn" AND
|tables=weapons; where = where_to_find like "%Forest%"
    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("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
 
}}
|tables=equipment; where = where_to_find like "%Owlbear Nest%"
<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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location,
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%")
    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 "%Forest%"
     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("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
   
<hr>
|tables=equipment; where = where_to_find like "%Blighted Village%"
[[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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=Location,
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon')
    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 "%Blighted Village%"
     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("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
   
}}
|tables=equipment; where = (where_to_find like "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%")
{{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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=Location,
|tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%")
    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 "%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("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
   
<hr>
|tables=equipment; where = where_to_find like "%Goblin Camp%"
[[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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=Location,
|tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik")
    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 "%Goblin Camp%"
     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("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
   
}}
|tables=equipment; where = where_to_find like "%Waukeen's Rest%"
<br>
{{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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=Location,
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
    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 "%Waukeen's Rest%"
     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("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
   
<hr>
|tables=equipment; where = where_to_find like "%Mountain Pass%"
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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location,
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
    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 "%Mountain Pass%"
     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("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
   
}}
   
{{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br>
|tables=equipment; where = where_to_find like "%Underdark%"  
<hr>
Sold by [[Lorroakan's Projection]] (or [[Rolan]])
<hr>
{{#cargo_compound_query:
tables=equipment; 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;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location,
|tables=weapons; where = (
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    where_to_find like "%Sorcerous Sundries%" AND
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
    where_to_find like "%Sold%" AND
|tables=weapons; where = where_to_find like "%Underdark%"  
    where_to_find like "%Lorroakan's Projection%")
     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("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
   
<hr>
|tables=equipment; where = where_to_find like "%Grymforge%"  
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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location,
|tables=weapons; where = (
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    where_to_find like "%Sorcerous Sundries%" AND
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
    where_to_find NOT REGEXP "Sold" AND
|tables=weapons; where = where_to_find like "%Grymforge%"  
    where_to_find NOT REGEXP "Sorcerous Vault")
     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("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
 
}}
|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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location,
|tables=weapons; where = where_to_find like "%Ramazith's Tower%"
    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 "%Rosymorn Monastery%"  
     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("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
 
}}
|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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location,
|tables=weapons; where = where_to_find like "%Sorcerous Vault%"
    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 "%Crèche Y'llek%"  
     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("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
   
|format=dynamic table
|rows per page=1000
|hidden fields=Effects, Where To Find, Type, AC, Dmg
|column widths=6%,16%,,,,13%,4%,6%
}}
}}
<br>{{RarityItem|The Tharchiate Codex|20}}
</div>
}}
 
<br>
 
{{ImageLocation|Philgrave's Mansion.jpg|Philgrave's Mansion|Located by the waterfront next to the [[Counting House]] and [[Felogyr's Fireworks]]<br>
== <span class="mw-customtoggle-1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two ==
<hr>
<div  id="mw-customcollapsible-1" class="mw-collapsible mw-collapsed">
Sold by [[Mystic Carrion]]
 
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
 
    where_to_find like "%Philgrave's Mansion%" AND
tables=equipment; 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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location,
|tables=weapons; where = (
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    where_to_find like "%Philgrave's Mansion%" AND
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
    (where_to_find like "%Sold%" OR where_to_find like "%bought%") AND
|tables=weapons; where = where_to_find like "%Ruined Battlefield%"  
    where_to_find like "%Mystic Carrion%")
     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("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
 
<hr>
|tables=equipment; where = where_to_find like "%Last Light Inn%"  
[[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;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location,
|tables=weapons; where = (
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    where_to_find like "%Philgrave's Mansion%" AND
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
    where_to_find NOT REGEXP "Sold" AND
|tables=weapons; where = where_to_find like "%Last Light Inn%"  
    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("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location,
|format=list
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|delimiter=<br>
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
}}
}}


= Equipment By Act and Region =
|tables=equipment; where = where_to_find like "%Reithwin Town%"  
 
== <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 "%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("[[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 "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
|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("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=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 "%Ravaged Beach%"
|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 One]]")=Act,CONCAT("[[Ravaged Beach]]")=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 "%Ravaged Beach%"
|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 One]]")=Act,CONCAT("[[Ravaged Beach]]")=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 "%Dank Crypt%"
|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("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=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 "%Dank Crypt%"
|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("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=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 "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
|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("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=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 "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
|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("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=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 "%The Risen Road%"
|tables=equipment; where = where_to_find like "%Shadowfell%"  
     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("[[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 "%The Risen Road%"
|tables=weapons; where = where_to_find like "%Shadowfell%"  
     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("[[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 "%Forest%"
|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("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=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 "%Forest%"
|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("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=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 "%Owlbear Nest%"
 
    AND rarity != "common" AND legacy IS NULL;
 
  fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location,  
|format=dynamic table
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|rows per page=1000
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|hidden fields=Effects, Where To Find, Type, AC, Dmg
|tables=weapons; where = where_to_find like "%Forest%"
|column widths=6%,16%,,,,13%,4%,6%
    AND rarity != "common" AND legacy IS NULL;
}}
  fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location,
</div>
    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 "%Blighted Village%"
== <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("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=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, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Blighted Village%"
|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("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=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 "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%")
|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 One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=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 "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%")
|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 One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=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 "%Goblin Camp%"
|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 One]]")=Act,CONCAT("[[Goblin Camp]]")=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 "%Goblin Camp%"
|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 One]]")=Act,CONCAT("[[Goblin Camp]]")=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 "%Waukeen's Rest%"
|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 One]]")=Act,CONCAT("[[Waukeen's Rest]]")=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 "%Waukeen's Rest%"
|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 One]]")=Act,CONCAT("[[Waukeen's Rest]]")=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, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
      
      
|tables=equipment; where = where_to_find like "%Mountain Pass%"
|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("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location,  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=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 "%Mountain Pass%"
|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("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location,
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=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 = (
|tables=equipment; 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("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location,  
   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, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Underdark%"  
|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("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location,
   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 "%Grymforge%"  
|tables=equipment; where = where_to_find like "%Wyrm's Crossing%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location,  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=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 "%Grymforge%"  
|tables=weapons; where = where_to_find like "%Wyrm's Crossing%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location,
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=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 "%Rosymorn Monastery%"  
|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("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location,  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=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 "%Rosymorn Monastery%"  
|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("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location,
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=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 "%Crèche Y'llek%"  
|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 "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 One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location,  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=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 "%Crèche Y'llek%"  
|tables=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 "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 One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location,
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=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
   
   
|format=dynamic table
|rows per page=1000
|hidden fields=Effects, Where To Find, Type, AC, Dmg
|column widths=6%,16%,,,,13%,4%,6%
}}
</div>


 
|tables=equipment; where = where_to_find like "%Lower City Sewers%"  
== <span class="mw-customtoggle-1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two ==
     AND rarity != "common" AND legacy IS NULL;  
<div  id="mw-customcollapsible-1" class="mw-collapsible mw-collapsed">
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=Location,  
 
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
{{#cargo_compound_query:
 
tables=equipment; where = where_to_find like "%Ruined Battlefield%"  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location,  
     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 "%Ruined Battlefield%"  
|tables=weapons; where = where_to_find like "%Lower City Sewers%"  
     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("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=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 "%Last Light Inn%"  
|tables=equipment; where = where_to_find like "%Forge of the Nine%"  
     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("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=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 "%Forge of the Nine%"  
     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("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=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 "%Stormshore Tabernacle%"  
     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 Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=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 "%Stormshore Tabernacle%"  
     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 Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=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 "%Stormshore Armoury%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location,  
   fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=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 "%Stormshore Armoury%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location,
   fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=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 "%Sorcerous Sundries%"  
     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("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=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 "%Sorcerous Sundries%"  
     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("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=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 "%Wine Festival%"  
     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("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=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 "%Wine Festival%"  
     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("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=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 "%Devil%Fee%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location,  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=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 "%Devil%Fee%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location,
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=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 "%The Counting House%"  
     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("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=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 "%The Counting House%"  
     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("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=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%"  
 
     AND rarity != "common" AND legacy IS NULL;  
|format=dynamic table
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location,  
|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 "%Rivington General%"  
|tables=weapons; where = where_to_find like "%Philgrave%s Mansion%"  
     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 Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=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 "%Steel Watch Foundry%"  
     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 Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=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 "%Steel Watch Foundry%"  
     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 Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=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 "%Undercity Ruins%"  
     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 Three]]")=Act,CONCAT("[[Undercity Ruins]]")=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 "%Undercity Ruins%"  
     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 Three]]")=Act,CONCAT("[[Undercity Ruins]]")=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%"
    AND rarity != "common" AND legacy IS NULL;
  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, armour_class=AC
|tables=weapons; where = where_to_find like "%Open Hand Temple%"
    AND rarity != "common" AND legacy IS NULL;
  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,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Wyrm's Crossing%"
|format=dynamic table
    AND rarity != "common" AND legacy IS NULL;
|rows per page=1000
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=Location,  
|hidden fields=Effects, Where To Find, Type, AC, Dmg
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|column widths=6%,16%,,,,13%,4%,6%
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
}}
|tables=weapons; where = where_to_find like "%Wyrm's Crossing%"
</div>
    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,
{{WeaponsTableHeader}}
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
{{#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
|tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%"  
| order by = rarity_order, name
    AND rarity != "common" AND legacy IS NULL;
| where = rarity != "common" AND legacy IS NULL AND where_to_find like "%Gauntlet of Shar%"
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location,
| default = {{WeaponsTableEmpty}}
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
| format = template
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
| template = WeaponsTableRow
|tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%"
| named args = yes
    AND rarity != "common" AND legacy IS NULL;
}}
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location,
{{WeaponsTableFooter}}
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
-->
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
 
   
= High Utility Permanent Bonuses =
|tables=equipment; where = (
 
              where_to_find like "%Lower City%" AND
See [[Permanent Bonuses]] or [[Permanent bonus table]] for a complete list of bonuses.
              where_to_find NOT REGEXP 'Lower City Sewers' AND
 
              where_to_find NOT REGEXP 'Undercity Ruins' AND
== <span class="mw-customtoggle-b0" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act One ==
              where_to_find NOT REGEXP 'Forge of the Nine' AND
<div  id="mw-customcollapsible-b0" class="mw-collapsible mw-collapsed">
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
 
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
! style="width: 14%;" | Region
              where_to_find NOT REGEXP 'Wine Festival' AND
! style="width: 17%;" | Location
              where_to_find NOT REGEXP "Devil's Fee" AND
! style="width: 21%;" | Bonus
              where_to_find NOT REGEXP "The Counting House" AND
! style="width: 48%;" | Description
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
|-
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
| <!-- Region -->[[Blighted Village]]
              where_to_find NOT REGEXP 'Undercity Ruins')
|| <!-- Location -->[[Apothecary's Cellar]]
    AND rarity != "common" AND legacy IS NULL;
|| <!-- Bonus -->{{SAI|Forbidden Knowledge}}
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=Location,
|| <!-- Description -->Gain +1 bonus to {{Ability|Wisdom}} {{SavingThrow}}s and [[Ability Checks]].
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|-
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
| <!-- Region -->[[Blighted Village]]
|tables=weapons; where = (
|| <!-- Location -->[[Apothecary's Cellar]]
              where_to_find like "%Lower City%" AND
|| <!-- Bonus -->{{SAI|Speak with Dead}}
              where_to_find NOT REGEXP 'Lower City Sewers' AND
|| <!-- Description -->Gain {{SAI|Speak with Dead}} spell once per long rest from [[Necromancy of Thay]].
              where_to_find NOT REGEXP 'Undercity Ruins' AND
|-
              where_to_find NOT REGEXP 'Forge of the Nine' AND
| <!-- Region -->[[Goblin Camp]]
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
|| <!-- Location -->[[Shattered Sanctum#Centre|Shattered Sanctum Centre]]
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
|| <!-- Bonus -->[[File:Absolute_symbol.png|25px]][[Absolute's Brand]]
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
|| <!-- Description -->Gain the use of unique special effects on [[:Category:Absolute_Equipment|Absolute Equipment]].<br>Gain unique dialogue options with followers of the [[Absolute]].
              where_to_find NOT REGEXP 'Wine Festival' AND
|-
              where_to_find NOT REGEXP "Devil's Fee" AND
| <!-- Region -->[[Goblin Camp]]
              where_to_find NOT REGEXP "The Counting House" AND
|| <!-- Location -->[[Shattered Sanctum#East|Shattered Sanctum East]]
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
|| <!-- Bonus -->{{cond|See Invisibility}}
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
|| <!-- Description -->Grants a permanent {{cond|See Invisibility}} effect from [[Volo's Ersatz Eye (passive feature)|Volo's Ersatz Eye]].
              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#East|Shattered Sanctum East]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|| <!-- Bonus -->{{cond|Loviatar's Love}}{{note|Effect is permanently lost if the character dies and is revived.}}
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|| <!-- 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%"  
== <span class="mw-customtoggle-b1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two ==
    AND rarity != "common" AND legacy IS NULL;  
<div  id="mw-customcollapsible-b1" class="mw-collapsible mw-collapsed">
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=Location,
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
! style="width: 14%;" | Region
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
! style="width: 17%;" | Location
|tables=weapons; where = where_to_find like "%Lower City Sewers%"  
! style="width: 21%;" | Bonus
    AND rarity != "common" AND legacy IS NULL;
! style="width: 48%;" | Description
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=Location,
|-
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
| <!-- Region -->[[Ruined Battlefield]]
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|| <!-- Location -->[[Seek_Protection_from_the_Shadow_Curse#The lantern's power|Kar'niss]]
   
|| <!-- Bonus -->{{cond|Pixie Blessing}}
|tables=equipment; where = where_to_find like "%Forge of the Nine%"  
|| <!-- Description -->Gain immunity to the {{cond|Shadow Curse}}.
    AND rarity != "common" AND legacy IS NULL;
|-
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=Location,
| <!-- Region -->[[Moonrise Towers]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|| <!-- Location -->[[Moonrise Towers#Main floor|Main Floor]]
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|| <!-- Bonus -->[[File:POT_Potion_of_Everlasting_Vigour_Faded.png|25px]][[Potion of Everlasting Vigour]]
|tables=weapons; where = where_to_find like "%Forge of the Nine%"
|| <!-- Description -->Gain +2 {{Ability|Strength}}.
    AND rarity != "common" AND legacy IS NULL;
|-
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=Location,
| <!-- Region -->[[Moonrise Towers]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|| <!-- Location -->[[Mind Flayer Colony]]
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|| <!-- 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.
|tables=equipment; where = where_to_find like "%Stormshore Tabernacle%"
|-
    AND rarity != "common" AND legacy IS NULL;
| <!-- Region -->[[Moonrise Towers]]
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location,
|| <!-- Location -->
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|| <!-- Bonus -->{{SAI|Bardic Inspiration|Improved Bardic Inspiration}}
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|| <!-- Description -->Gain a charge of Bardic Inspiration that is stronger than usual ({{DieIcon|d12|Slashing}}'''1d12''').
|tables=weapons; where = where_to_find like "%Stormshore Tabernacle%"
|-
    AND rarity != "common" AND legacy IS NULL;
| <!-- Region -->[[Reithwin Town]]
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location,
|| <!-- Location -->[[Find Arabella's Parents#Breaking the news|Arabella]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|| <!-- Bonus -->{{SAI|Arabella's Shadow Entangle}}
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|| <!-- Description -->Entangle an Undead or shadow creature until long rest.
   
|}
|tables=equipment; where = where_to_find like "%Stormshore Armoury%"
</div>
    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


|tables=equipment; where = where_to_find like "%Sorcerous Sundries%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=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 "%Sorcerous Sundries%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=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 "%Wine Festival%"  
== <span class="mw-customtoggle-b2" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Three ==
    AND rarity != "common" AND legacy IS NULL;
<div  id="mw-customcollapsible-b2" class="mw-collapsible mw-collapsed">
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=Location,
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
! style="width: 14%;" | Region
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
! style="width: 17%;" | Location
|tables=weapons; where = where_to_find like "%Wine Festival%"  
! style="width: 21%;" | Bonus
    AND rarity != "common" AND legacy IS NULL;
! style="width: 48%;" | Description
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=Location,
|-
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
| <!-- Region -->[[Help Your Protector|Wyrm's Lookout]]
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|| <!-- Location -->[[Astral Plane]]
 
|| <!-- Bonus -->{{SAI|Partial Ceremorphosis}}
|tables=equipment; where = where_to_find like "%Philgrave%s Mansion%"
|| <!-- 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}}.
    AND rarity != "common" AND legacy IS NULL;
|-
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location,
| <!-- Region -->[[Rivington]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|| <!-- Location -->[[Circus of the Last Days]]
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|| <!-- Bonus -->{{cond|Sweet Stone Features}}
|tables=weapons; where = where_to_find like "%Philgrave%s Mansion%"
|| <!-- Description -->Gain a {{DieIcon|d4|Slashing}} '''+1d4''' bonus to {{Attack Roll}}s and {{SavingThrow}}s.
    AND rarity != "common" AND legacy IS NULL;
|-
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location,
| <!-- Region -->[[Lower City]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|| <!-- Location -->[[Crimson Draughts]]
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|| <!-- Bonus -->{{SAI|Unstable Blood}}
   
|| <!-- Description -->Your blood is now highly flammable and will explode on contact with fire.
|tables=equipment; where = where_to_find like "%Devil%Fee%"
|-
    AND rarity != "common" AND legacy IS NULL;
| <!-- Region -->[[Lower City]]
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location,
|| <!-- Location --> [[House of Grief]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
|| <!-- Bonus -->[[Mirror of Loss|Patriar's Memory]]
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|| <!-- Description -->Gain +1 {{Ability|Charisma}}.
|tables=weapons; where = where_to_find like "%Devil%Fee%"
|-
    AND rarity != "common" AND legacy IS NULL;
| <!-- Region -->[[Lower City]]
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location,
|| <!-- Location --> [[House of Grief]]
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
|| <!-- Bonus -->[[Mirror of Loss#Using_the_mirror|<Stolen> Memory]]
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
|| <!-- Description -->Gain +2 to an [[Ability Score]] of your choice.
|-
| <!-- 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
|}


|tables=equipment; where = where_to_find like "%The Counting House%"
{{notelist}}
    AND rarity != "common" AND legacy IS NULL;
</div>
  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




|format=dynamic table
= Dye Previews =
|rows per page=1000
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
|hidden fields=Effects, Where To Find, Type, AC, Dmg
! style="width: 40%;" | Medium Armour
|column widths=6%,16%,,,,13%,4%,6%
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/medium+armour]]
}}
! style="width: 40%;" | Heavy Armour
</div>
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/heavy+armour]]
|-
| {{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}}
-->


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


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


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


{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
|imagestyle  =  
! style="width: 14%;" | Region
|captionstyle =  
! style="width: 17%;" | Location
|image        = [[File:Example-serious.jpg|200px|alt=Example alt text]]
! style="width: 21%;" | Bonus
|caption      = Caption displayed below File:Example-serious.jpg
! style="width: 48%;" | Description
 
|-
|headerstyle  = background:#ccf;
| <!-- Region -->[[Blighted Village]]
|labelstyle  = background:#ddf;
|| <!-- Location -->[[Apothecary's Cellar]]
|datastyle    =
|| <!-- Bonus -->{{SAI|Forbidden Knowledge}}
 
|| <!-- Description -->Gain +1 bonus to {{Ability|Wisdom}} {{SavingThrow}}s and [[Ability Checks]].
|header1 = Header defined alone
|-
| label1 =
| <!-- Region -->[[Blighted Village]]
| data1 =
|| <!-- Location -->[[Apothecary's Cellar]]
|header2 =
|| <!-- Bonus -->{{SAI|Speak with Dead}}
| label2 = Label defined alone does not display (needs data, or is suppressed)
|| <!-- Description -->Gain {{SAI|Speak with Dead}} spell once per long rest from [[Necromancy of Thay]].
| 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
}}
 
{| class="mw-collapsible mw-collapsed wikitable" style="margin-left:1.6em;"
|-
|-
| <!-- Region -->[[Goblin Camp]]
! Header 1
|| <!-- Location -->[[Shattered Sanctum#Centre|Shattered Sanctum Centre]]
! Header 2
|| <!-- 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]].
|-
|-
| <!-- Region -->[[Goblin Camp]]
| row 1, cell 1
|| <!-- Location -->[[Shattered Sanctum#East|Shattered Sanctum East]]
| row 1, cell 2
|| <!-- 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]]
| row 2, cell 1
|| <!-- Location -->[[Shattered Sanctum#East|Shattered Sanctum East]]
| row 2, cell 2
|| <!-- 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]]
!
!
|-
|-
| <!-- Region -->[[Sunlit Wetlands]]
! [[File:Cloak_B_Unfaded_Icon.png|50px|link=Cloaks]]
|| <!-- 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]]
! [[File:Plate_Armour_Icon.png|50px|link=Armour]]
|| <!-- Location -->[[Riverside Teahouse]]
!  
|| <!-- Bonus -->[[File:Generic_Feature_Icon.webp|25px]][[Auntie Ethel's Hair|Auntie Ethel's Boon]]
! [[File:Amulet_Necklace_A_Gold_A_1_Unfaded_Icon.png|50px|link=Amulets]]
|| <!-- Description -->Gain +1 to an [[Ability Scores|Ability Score]] of choice. Can be raised above 20.
|-
|-
| <!-- Region -->[[Underdark]]
! [[File:Metallic_Gloves_Icon.png|50px|link=Handwear]]  
|| <!-- Location -->[[Myconid Colony]]
!  
|| <!-- Bonus -->{{SAI|Survival Instinct}}
! [[File:Ring_A_Simple_Gold_Unfaded_Icon.png|50px|link=Rings]]  
|| <!-- Description -->Gain the additional [[Illithid Powers|illithid power]] {{Icon|Cleric Tadpole Survival Instinct.png|30|link=Survival Instinct}}[[Survival Instinct]]
|-
|-
| <!-- Region -->[[Underdark]]
! [[File:Metallic_Boots_Icon.png|50px|link=Footwear]]
|| <!-- Location -->[[The Festering Cove]]
!  
|| <!-- Bonus -->{{Condition inline|BOOOAL's Blessing}}
!  
|| <!-- Description -->Gain {{Advantage}} on {{Attack Roll}}s against {{cond|Bleeding}} targets.
|-
|-
| <!-- Region -->[[Rosymorn Monastery]]
! [[File:Longsword_Item_Icon.png|50px|link=Weapons]]
|| <!-- Location -->[[Crèche Y'llek#Infirmary|Crèche Y'llek Infirmary]]
! [[File:Item_WPN_HUM_Shield_D_0_Unfaded_Icon.png|50px|link=Shields]]
|| <!-- Bonus -->{{SAI|Awakened}}
! [[File:Longbow_Item_Icon.png|50px|link=Bow]]
|| <!-- Description -->You can use all of your Illithid powers as a [[Bonus Action]].
|}
|}
</div>


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


Equipment lists separated by Act.


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


{{notelist}}
</div>


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




= Dye Previews =
=== [[Headwear]] ===
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;"
{{SpoilerBox|act=2|custom=[[Headwear]].|
! style="width: 40%;" | Medium Armour
{{#cargo_query: tables = equipment
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/medium+armour]]
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
! style="width: 40%;" | Heavy Armour
| order by = rarity_order
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/heavy+armour]]
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL
|-
| 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
| {{ItemIcon|name=Chain Shirt +2|size=25|show_rarity=1}} [[Chain Shirt +1|{{RarityColor|rare|Chain Shirt +2}}]]
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
|| [https://64.media.tumblr.com/49c4560a04fc8198830c32ee6c5cae87/28a28e3124da3197-90/s1280x1920/2069c7673e58d43b89f2f6ba61d9f8efaa75e340.png Dyes]
| order by = rarity_order
|| {{ItemIcon|name=Plate Armour +2|size=25|show_rarity=1}} [[Plate Armour +1|{{RarityColor|rare|Plate Armour +2}}]]
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL
|| [https://64.media.tumblr.com/1646e63dff137f11059102d85bbc45c6/08ccd38d3d0757c6-ee/s1280x1920/de2a864edfc4faa04febb8c721a1a64b89d04cd6.png Dyes]
| format = table
|-
}}
| {{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]
=== [[Armour]] ===
|| {{ItemIcon|name=Blackguard's Plate|size=25|show_rarity=1}} [[Blackguard's Plate|{{RarityColor|very rare|Blackguard's Plate}}]]
{{SpoilerBox|act=2|custom=[[Armour]].|
|| [https://64.media.tumblr.com/b1ce0174ed6967db06d947f2e0abe3ff/d3e2e9ec4d78abec-5a/s1280x1920/26dcb8a9b4fb177c8c464b79af0e9d6c91d612c6.png Dyes]
{{#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
<!-- class="mw-collapsible mw-collapsed"-->
| format = table
<!--
}}
{{Tab
}}
|one=The Dark Urge
=== [[Handwear]] ===
|one-name=Story Spoiler Page
{{SpoilerBox|act=2|custom=[[Handwear]].|
|two=The Dark Urge (Origin)
{{#cargo_query: tables = equipment
|two-name=Origin Page
| 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
}}
}}


{{Infobox
=== [[Shields]] ===
|name        = Infobox/doc
{{SpoilerBox|act=2|custom=[[Shields]].|
|bodystyle    =  
{{#cargo_query: tables = equipment
 
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
|titlestyle  =  
| order by = rarity_order
|abovestyle  = background:#cfc;
| where =  
|subheaderstyle =
  type = "Shields"
|title        = Test Infobox
   AND rarity != "common"
|above        = Above text
  AND legacy IS NULL
|subheader   = Subheader above image
  AND (
|subheader2  = Second subheader
    where_to_find like "%Ruined Battlefield%" OR
 
    where_to_find like "%Last Light Inn%" OR
|imagestyle  =  
    where_to_find like "%Reithwin Town%" OR
|captionstyle =  
    where_to_find like "%Moonrise%" OR
|image        = [[File:Example-serious.jpg|200px|alt=Example alt text]]
    where_to_find like "%Grand Mausoleum%" OR
|caption      = Caption displayed below File:Example-serious.jpg
    where_to_find like "%Gauntlet of Shar%" OR
 
    where_to_find like "%Shadowfell%"
|headerstyle  = background:#ccf;
  )
|labelstyle  = background:#ddf;
| format = table
|datastyle   =  
}}
 
}}
|header1 = Header defined alone
=== [[Amulets]] ===
| label1 =  
{{SpoilerBox|act=2|custom=[[Amulets]].|
|  data1 =  
{{#cargo_query: tables = equipment
|header2 =  
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location
| label2 = Label defined alone does not display (needs data, or is suppressed)
| order by = rarity_order
| data2 =
| where =  
|header3 =
  type = "Amulets"
| label3 =  
   AND rarity != "common"
| data3 = Data defined alone
  AND legacy IS NULL
|header4 = All three defined (header, label, data, all with same number)
  AND (
| label4 = does not display (same number as a header)
    where_to_find like "%Ruined Battlefield%" OR
| data4 = does not display (same number as a header)
    where_to_find like "%Last Light Inn%" OR
|header5 =
    where_to_find like "%Reithwin Town%" OR
| label5 = Label and data defined (label)
    where_to_find like "%Moonrise%" OR
| data5 = Label and data defined (data)
    where_to_find like "%Grand Mausoleum%" OR
 
    where_to_find like "%Gauntlet of Shar%" OR
|belowstyle = background:#ddf;
    where_to_find like "%Shadowfell%"
|below      = Below text
  )
| format = table
}}
}}
=== [[Rings]] ===
{{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
| where =  
  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
}}
}}
}}
}}


{| class="mw-collapsible mw-collapsed wikitable" style="margin-left:1.6em;"
|-
! Header 1
! Header 2
|-
| row 1, cell 1
| row 1, cell 2
|-
| row 2, cell 1
| row 2, cell 2
|}
-->
<!--
{| class="wikitable"
|+ Equipment
! [[File:Helmet_Icon.png|50px|link=Headwear]]
!
!
|-
! [[File:Cloak_B_Unfaded_Icon.png|50px|link=Cloaks]]
!
!
|-
! [[File:Plate_Armour_Icon.png|50px|link=Armour]]
!
! [[File:Amulet_Necklace_A_Gold_A_1_Unfaded_Icon.png|50px|link=Amulets]]
|-
! [[File:Metallic_Gloves_Icon.png|50px|link=Handwear]]
!
! [[File:Ring_A_Simple_Gold_Unfaded_Icon.png|50px|link=Rings]]
|-
! [[File:Metallic_Boots_Icon.png|50px|link=Footwear]]
!
!
|-
! [[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
}}


= Equipment By Build =
== Act Three ==
=== [[Radiant]] Compound Query (testing)===
{{SpoilerBox|act=3|custom=Equipment for Act Three.|
{{#cargo_compound_query:
[[File:Chapter 3.webp|500px|link=Act Three]]
tables=equipment;
 
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
=== [[Headwear]] ===
|tables=weapons;
{{SpoilerBox|act=3|custom=[[Headwear]].|
where=rarity != "common" AND special like "%Radiant%" AND legacy IS NULL
|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 = rarity != "common" AND special like "%Radiant%" AND legacy IS NULL
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Three%" 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
=== [[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
| order by = rarity_order
| where = rarity != "common" AND special like "%Radiant%" AND legacy IS NULL
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL
| format = table
| format = table
}}
}}
 
}}
=== [[Necrotic]] ===
=== [[Armour]] ===
{{SpoilerBox|
{{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 = rarity != "common" AND special like "%Necrotic%" AND legacy IS NULL
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Three%" 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
=== [[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
| order by = rarity_order
| where = rarity != "common" AND special like "%Necrotic%" AND legacy IS NULL
| 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
| format = table
}}
}}
}}
}}


-->
=== [[Shields]] ===
<!--
{{SpoilerBox|act=3|custom=[[Shields]].|
= 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
{{#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 One%" AND legacy IS NULL
| where =  
  type = "Shields"  
  AND rarity != "common"  
  AND legacy IS NULL
  AND (
    where_to_find like "%Rivington%"
  )
| format = table
| format = table
}}
}}
}}
}}
{{SpoilerBox|act=1|custom=[[Cloaks]].|
=== [[Amulets]] ===
{{SpoilerBox|act=3|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 = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL
| where =  
  type = "Amulets"  
  AND rarity != "common"  
  AND legacy IS NULL
  AND (
    where_to_find like "%Rivington%"
  )
| format = table
| format = table
}}
}}
}}
}}
{{SpoilerBox|act=1|custom=[[Armour]].|
=== [[Rings]] ===
{{SpoilerBox|act=3|custom=[[Rings]].|
{{#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 One%" AND legacy IS NULL
| where =  
  type = "Rings"  
  AND rarity != "common"  
  AND legacy IS NULL
  AND (
    where_to_find like "%Rivington%"
  )
| format = table
| 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 (
    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
}}
}}
=== [[Amulets]] ===
{{SpoilerBox|act=2|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 "%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
}}
}}
=== [[Rings]] ===
{{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
| where =
  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]]
{{Gameplay mechanics}}
{{Gameplay mechanics}}
Please note that all contributions to Baldur's Gate 3 Wiki are considered to be released under the CC BY-NC-SA license, except when noted otherwise (see BG3Wiki:Copyrights for details). If you do not want your writing to be edited and redistributed at will, do not submit it here. Per our Content Rules, you are promising that you wrote this yourself, or copied it from a public domain or similar free resource. Do not submit copyrighted work without permission!

To edit this page, please answer the question that appears below (more info):

Cancel Editing help (opens in new window)