Template:Query base items: Difference between revisions
Jump to navigation
Jump to search
(Vinifera7 moved page Template:Query base items to Template:Drop enabled base item table) |
(Created page with "<includeonly>{{#invoke: Item table|item_table |mode=item |q_tables = versions{{#if: {{{tables|}}}|, {{{tables}}}}} |q_join = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}} |q_where = items.drop_enabled = true AND (items.release_version IS NULL OR items.release_version IS NOT NULL AND versions.release_date < {{CURRENTTIMESTAMP}} ) AND items.base_item IS NULL AND items.base_item_id IS NULL AND items.base_item_page IS NULL {{#if:...") Tag: Reverted |
||
| Line 1: | Line 1: | ||
# | <includeonly>{{#invoke: Item table|item_table | ||
|mode=item | |||
|q_tables = versions{{#if: {{{tables|}}}|, {{{tables}}}}} | |||
|q_join = items.release_version=versions.version{{#if: {{{join|}}}|, {{{join}}}}} | |||
|q_where = items.drop_enabled = true | |||
AND (items.release_version IS NULL | |||
OR items.release_version IS NOT NULL | |||
AND versions.release_date < {{CURRENTTIMESTAMP}} | |||
) AND items.base_item IS NULL | |||
AND items.base_item_id IS NULL | |||
AND items.base_item_page IS NULL | |||
{{#if: {{{where|}}} | |||
|AND ({{{where}}}) | |||
}} | |||
|q_orderBy = {{{orderby|items.required_level_range_maximum}}}, items.name | |||
|default=No results found [[Category:Item tables without results]] | |||
}}{{#if:{{{q_tables|}}}{{{q_fields|}}}{{{q_join|}}}{{{q_where|}}}{{{q_groupBy|}}}{{{q_having|}}}{{{q_orderBy|}}}{{{q_limit|}}}{{{q_offset|}}}|[[Category:Pages incorrectly using item table templates]]}}</includeonly><noinclude> | |||
{{Documentation}} | |||
</noinclude> | |||
