Template:Drop enabled base item count/sandbox: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
(Create sandbox version of Template:Drop enabled base item 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, 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 10:49, 7 June 2024

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



Usage

{{Drop enabled base item count}}

Examples