Template:Drop enabled base item count: Difference between revisions

From Path of Exile 2 Wiki
Jump to navigation Jump to search
>Illviljan
(Created page with "<includeonly>{{#cargo_query: |fields=COUNT(DISTINCT items.name) |tables=items, versions{{#if: {{{tables|}}}|,{{{tables|}}}|}} |join on=items.release_version=versions.version{#...")
 
m (7 revisions imported)
 
(6 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, 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.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}})  
    OR items.release_version IS NOT NULL
{{#if: {{{where|}}}|AND ({{{where|}}})|}}
    AND versions.release_date < {{CURRENTTIMESTAMP}}
}}</includeonly><noinclude>{{documentation}}</noinclude>
  ) AND items.base_item IS NULL
  AND items.base_item_id IS NULL
  AND items.base_item_page IS NULL
  {{#if: {{{where|}}}
  |AND ({{{where}}})
  }}
}}</includeonly><noinclude>
{{Documentation}}
</noinclude>

Latest revision as of 04:42, 22 November 2024

Template documentation[create] [purge]
You might want to create a documentation page for this template.
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_base_item_count&oldid=9995"