User:Korgat: Difference between revisions

Jump to navigation Jump to search

User:Korgat (edit)

Revision as of 06:39, 19 February 2024

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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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




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


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


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


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


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


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


= Resistance Equipment =


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


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


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


{{notelist}}
</div>


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




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


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


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


-->
[[Template:ImageLocation]]
[[Template:ImageLocation]]
[[Special:CargoTables]] [[Special:Drilldown]]
[[Special:CargoTables]] [[Special:Drilldown]]
{{Gameplay mechanics}}
{{Gameplay mechanics}}
Korgat
308
edits
Retrieved from "https://bg3.wiki/wiki/Special:MobileDiff/153675...153815"

Navigation menu