Template:Drop enabled gem count/sandbox: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
(Create sandbox version of Template:Gem count)
 
No edit summary
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_id = "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|}}})|}}  
  ) {{#if: {{{where|}}}
}}</includeonly><noinclude>{{documentation}}</noinclude>
  |AND ({{{where}}})
  }}
}}</includeonly><noinclude>
{{Documentation}}
</noinclude>

Revision as of 19:36, 9 May 2024

This is the template sandbox page for Template:Drop enabled gem count (diff).

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 (edit | diff) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.
Retrieved from "https://www.poewiki.net/index.php?title=Template:Drop_enabled_gem_count/sandbox&oldid=1443338"