Path of Exile Wiki

Please consider helping keep the wiki up to date. Check the to-do list of updates needed for version 3.14.0.

Game data exports will becoming later as the technical changes in addition to regular changes take some more time.

READ MORE

Path of Exile Wiki
m (Illviljan moved page Synicasm Sandbox to User:Synicasm/Sandbox without leaving a redirect: Don't create sandbox pages in the main namespace. Use your own namespace for that.)
Synicasm (talk | contribs)
Line 1: Line 1:
  +
{{#cargo_query:
  +
tables=items,vendor_rewards,quest_rewards
  +
|join on=items._pageName=vendor_rewards.reward,vendor_rewards.reward=quest_rewards.reward
  +
|fields=items._pageName=Skill Gem,items.required_level=Level,CONCAT(vendor_rewards.quest,' - Act:',vendor_rewards.act)=Able to Buy After,CONCAT(quest_rewards.quest,' - Act:',quest_rewards.act)=Quest Reward
  +
|where=items.class_id = "Active Skill Gem" and vendor_rewards.classes Like "%Witch%"
   
  +
|order by=items.required_level,items._pageName
   
  +
}}
<onlyinclude><div align="center">A [[list of support skill gems]] is displayed below.</div>
 
<div style="vertical-align:top; display:inline-block;">{{Query skill gems
 
|tables=skill_gems
 
|join=items._pageID=skill_gems._pageID
 
|where=items.class="Active Skill Gems"
 
|q_orderBy=items.name
 
|q_limit=5000
 
|level=yes
 
|icon=yes
 
 
}}</div><div style="vertical-align:top; display:inline-block;">.</div><div style="vertical-align:top; display:inline-block;">{{Query skill gems
 
|tables=skill_gems
 
|join=items._pageID=skill_gems._pageID
 
|where=items.class="Support Skill Gems"
 
|q_orderBy=items.name
 
|q_limit=5000
 
|level=yes
 
|icon=yes
 
 
}}</div></onlyinclude>
 

Revision as of 20:51, 27 February 2020

Error: operator for the virtual field 'vendor_rewards.classes' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.