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
Synicasm (talk | contribs)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
  +
Currently Listing too many recs due to 1 to many
  +
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=items,vendor_rewards,quest_rewards
 
tables=items,vendor_rewards,quest_rewards
 
|join on=items._pageName=vendor_rewards.reward,vendor_rewards.reward=quest_rewards.reward
 
|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
 
|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%"
+
|where=items.class_id = "Active Skill Gem" and vendor_rewards.classes Like "%Witch%" or quest_rewards.classes like '%Witch%'
   
 
|order by=items.required_level,items._pageName
 
|order by=items.required_level,items._pageName

Latest revision as of 23:52, 27 February 2020

Currently Listing too many recs due to 1 to many

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