Template:Drop enabled gem count: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
>OmegaK2
mNo edit summary
>OmegaK2
mNo edit summary
Line 4: Line 4:
|join on=items.release_version=versions.version, items._pageID=skill_gems._pageID{{#if: {{{join|}}}|,{{{join|}}}|}}
|join on=items.release_version=versions.version, items._pageID=skill_gems._pageID{{#if: {{{join|}}}|,{{{join|}}}|}}
|where=
|where=
  items.rarity = "Normal" AND  
  items.rarity_id = "normal" AND  
  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  

Revision as of 14:14, 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.