Template:Drop enabled gem count: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
>OmegaK2
mNo edit summary
m (6 revisions imported)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<includeonly>{{#cargo_query:
<includeonly>{{#cargo_query:
|fields=COUNT(DISTINCT items.name)
|fields = COUNT(DISTINCT items.name)
|tables=items, skill_gems, versions{{#if: {{{tables|}}}|,{{{tables|}}}|}}
|tables = items, skill_gems, versions{{#if: {{{tables|}}}|, {{{tables}}}}}
|join on=items.release_version=versions.version, items._pageID=skill_gems._pageID{{#if: {{{join|}}}|,{{{join|}}}|}}
|join on = items._pageID=skill_gems._pageID, items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}}
|where=
|where = items._pageNamespace = 0
items.rarity = "Normal" AND  
  AND items.drop_enabled = true
items.drop_enabled = true AND  
  AND (items.release_version IS NULL  
(items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}}) AND  
    OR items.release_version IS NOT NULL
(items.class_id = "Active Skill Gem" OR items.class_id = "Support Skill Gem")  
    AND versions.release_date < {{CURRENTTIMESTAMP}}
{{#if: {{{where|}}}|AND ({{{where|}}})|}}  
  )  
}}</includeonly><noinclude>{{documentation}}</noinclude>
  AND items.class_id IN ("Active Skill Gem", "Support Skill Gem") {{#if: {{{where|}}}
  |AND ({{{where}}})
  }}
}}</includeonly><noinclude>
{{Documentation}}
</noinclude>

Latest revision as of 22:06, 5 November 2024

Template documentation[create] [purge]