The wiki is currently a work in progress. If you'd like to help out, please check the Community Portal and our getting started guide. Also, check out our sister project on poewiki.net.

Template:Drop enabled gem count: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
>OmegaK2
(Created page with "<includeonly>{{#cargo_query: |fields=COUNT(DISTINCT items.name) |tables=items, skill_gems, versions{{#if: {{{tables|}}}|,{{{tables|}}}|}} |join on=items.release_version=versio...")
 
>OmegaK2
mNo edit summary
Line 7: Line 7:
  items.drop_enabled = true AND  
  items.drop_enabled = true AND  
  (items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}}) AND  
  (items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}}) AND  
  (items.class = "Active Skill Gems" OR items.class = "Support Skill Gems")  
  (items.class_id = "Active Skill Gem" OR items.class_id = "Support Skill Gem")  
  {{#if: {{{where|}}}|AND ({{{where|}}})|}}  
  {{#if: {{{where|}}}|AND ({{{where|}}})|}}  
}}</includeonly><noinclude>{{documentation}}</noinclude>
}}</includeonly><noinclude>{{documentation}}</noinclude>

Revision as of 14:09, 18 October 2019

Template documentation[view] [edit] [history] [purge]


For regular item table queries, see Template:Query skill gems.

Overview

This template queries for skill gems, ignoring drop disabled and future skill gems.

For more information, see Template:Item table.

Parameters

Parameters that can be specified in addition to the default {{item table}} parameters.

Parameter Value Description
tables str Any extra tables.
where str Any extra conditions.
join str any extra joins.