View source for Template:Query stat related skill gems

<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>}}
{{Query skill gems
|tables = {{{tables|skill, 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}}}
|where =
     items.class_id="{{#ifeq: {{ucfirst: {{lc: {{{type|}}} }} }} | Support | Support | Active }} Skill Gem"
 AND ({{{where
     | {{#if: {{{quality|}}} 
         | skill_quality_stats.id LIKE "{{{stat_id_query|+}}}"
         | skill_stats_per_level.id LIKE "{{{stat_id_query|+}}}"
     }} 
 }}})
|default = There are currently no [[{{#ifeq: {{lc: {{{type|}}} }} | support | support | active }} skill gem]]s that have {{#if: {{{quality|}}} | [[quality]] }} [[stat]]s related to [[{{{stat_page|{{PAGENAME}}}}}]].
|q_limit=200
}}</includeonly></onlyinclude>
{{documentation}}