Template:Drop enabled gem count: Difference between revisions
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. | |join on = items._pageID=skill_gems._pageID, items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}} | ||
|where= | |where = items._pageNamespace = 0 | ||
AND items.drop_enabled = true | |||
AND (items.release_version IS NULL | |||
OR items.release_version IS NOT NULL | |||
AND versions.release_date < {{CURRENTTIMESTAMP}} | |||
) | |||
}}</includeonly><noinclude>{{ | AND items.class_id IN ("Active Skill Gem", "Support Skill Gem") {{#if: {{{where|}}} | ||
|AND ({{{where}}}) | |||
}} | |||
}}</includeonly><noinclude> | |||
{{Documentation}} | |||
</noinclude> |