Template:Item count: Difference between revisions

Revision as of 19:48, 9 April 2024

Template documentation[view] [edit] [history] [purge]

The above documentation is transcluded from Template: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.

@@ Line 1: / Line 1: @@
 <includeonly>{{#cargo_query:
-|fields=COUNT(DISTINCT items.name)
+|fields = COUNT(DISTINCT items.name)
-|tables=items, versions{{#if: {{{tables|}}}|,{{{tables|}}}|}}
+|tables = items, versions{{#if: {{{tables|}}}|, {{{tables}}}}}
-|join on=items.release_version=versions.version{{#if: {{{join|}}}|,{{{join|}}}|}}
+|join on = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}}
-|where=
+|where = items._pageNamespace IN (0, {{NAMESPACENUMBER:Map:1}})
- (items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}})
+  AND items.is_in_game = true
- {{#if: {{{where|}}}|AND ({{{where|}}})|}}
+  AND (items.release_version IS NULL
-}}</includeonly><noinclude>{{documentation}}</noinclude>
+    OR items.release_version IS NOT NULL
+    AND versions.release_date < {{CURRENTTIMESTAMP}}
+  ) {{#if: {{{where|}}}
+  |AND ({{{where}}})
+  }}
+}}</includeonly><noinclude>
+{{Documentation}}
+</noinclude>