Template:Drop enabled item count: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<includeonly>{{#cargo_query: |fields = COUNT(DISTINCT items.name) |tables = items{{#if: {{{tables|}}}|, {{{tables}}}}} |join on = {{#if: {{{join|}}}|{{{join}}}}} |where = items._pageNamespace = 0 AND items.drop_enabled = true {{#if: {{{where|}}} |AND ({{{where}}}) }} }}</includeonly><noinclude> {{Documentation}} </noinclude>") |
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{{#if: {{{tables|}}}|, {{{tables}}}}} | |tables = items, versions{{#if: {{{tables|}}}|, {{{tables}}}}} | ||
|join on = {{#if: {{{join|}}}|{{{join}}}}} | |join on = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}} | ||
|where = items._pageNamespace = 0 | |where = items._pageNamespace = 0 | ||
AND items.drop_enabled = true | AND items.drop_enabled = true | ||
{{#if: {{{where|}}} | AND (items.release_version IS NULL | ||
OR items.release_version IS NOT NULL | |||
AND versions.release_date < {{CURRENTTIMESTAMP}} | |||
) {{#if: {{{where|}}} | |||
|AND ({{{where}}}) | |AND ({{{where}}}) | ||
}} | }} | ||
Revision as of 19:44, 28 October 2024
The above documentation is transcluded from Template:Drop enabled item count/doc.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.