Template:Query stat related skill gems/sandbox: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
<onlyinclude><includeonly>{{#ifeq: {{lc: {{{stat_page|{{PAGENAME}}}}} }} | {{lc: {{PAGENAME}} }} || The following [[{{#ifeq: {{lc: {{{type|}}} }} | support | support | active }} skill gem]]s have {{#if: {{{quality|}}} | [[quality]] }} [[stat]]s related to [[{{{stat_page}}}]]:<br>}}
<includeonly>The following [[{{#switch: {{{type|}}} | support = support | #default = skill}} gem]]s have [[stat]]s {{#if: {{{quality|}}} | from [[quality]]}} related to [[{{{stat_page|{{PAGENAME}}}}}|{{PAGENAMEBASE|{{{stat_page|{{PAGENAME}}}}}}}]]:
 
{{Query skill gems
{{Query skill gems
|tables = {{{tables|skill, skill_stats_per_level, skill_quality_stats}}}
|tables = skill_stats_per_level, skill_quality_stats
|join = {{{join|items._pageID=skill._pageID, items._pageID=skill_stats_per_level._pageID, items._pageID=skill_quality_stats._pageID}}}
|join = items._pageID=skill_stats_per_level._pageID, items._pageID=skill_quality_stats._pageID
|where =
|where = items.class_id="{{#switch: {{{type|}}} | support = Support | #default = Active}} Skill Gem"
    items.class_id="{{#ifeq: {{ucfirst: {{lc: {{{type|}}} }} }} | Support | Support | Active }} Skill Gem"
  AND ({{{where
AND ({{{where
    | {{#if: {{{quality|}}}
    | {{#if: {{{quality|}}}  
      | skill_quality_stats.id LIKE "{{{stat_id_query|+}}}"
        | skill_quality_stats.id LIKE "{{{stat_id_query|+}}}"
      | skill_stats_per_level.id LIKE "{{{stat_id_query|+}}}"
        | skill_stats_per_level.id LIKE "{{{stat_id_query|+}}}"
    }}
    }}  
  }}})
}}})
|default = There are no {{#switch: {{{type|}}} | support = support | #default = skill}} gems that have stats {{#if: {{{quality|}}} | from quality}} related to {{PAGENAMEBASE|{{{stat_page|{{PAGENAME}}}}}}}.
|default = There are currently no [[{{#ifeq: {{lc: {{{type|}}} }} | support | support | skill }} gem]]s that have {{#if: {{{quality|}}} | [[quality]] }} [[stat]]s related to [[{{{stat_page|{{PAGENAME}}}}}]].
}}<noinclude>
|q_limit=200
{{Documentation}}
}}</includeonly></onlyinclude>
</noinclude>
{{documentation}}

Revision as of 20:38, 2 May 2024

Retrieved from "https://www.poewiki.net/index.php?title=Template:Query_stat_related_skill_gems/sandbox&oldid=1442993"