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...")
 
m (6 revisions imported)
(5 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 = "Active Skill Gems" OR items.class = "Support Skill Gems")  
    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>

Revision as of 22:06, 5 November 2024

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.
The above documentation is transcluded from Template:Drop enabled gem count/doc. (edit | history)
Editors can experiment in this template's sandbox (create | mirror) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.
Retrieved from "https://www.poe2wiki.net/index.php?title=Template:Drop_enabled_gem_count&oldid=9110"