Template:Query keystone passive skills and Template:Query keystone passive skills/sandbox: Difference between pages

(Difference between pages)
Jump to navigation Jump to search
Page 1
Page 2
No edit summary
 
(Created page with "<includeonly>{{#invoke:Passive skill table/sandbox|passive_skill_table |q_tables=passive_skill_stats |q_join=passive_skills._pageID=passive_skill_stats._pageID |q_where= passive_skills.is_in_game = true AND (passive_skills.ascendancy_class <= "" OR passive_skills.ascendancy_class is NULL) AND passive_skills.is_keystone = true AND passive_skills.stat_text > "" {{#if: {{{where|}}}|AND ({{{where|}}})|}} |q_orderBy={{{q_orderBy|passive_skills.name}}} |stat_text=1 |...")
 
Line 1: Line 1:
<includeonly>{{#invoke:Passive skill table|passive_skill_table
<includeonly>{{#invoke:Passive skill table/sandbox|passive_skill_table
|q_tables=passive_skill_stats
|q_tables=passive_skill_stats
|q_join=passive_skills._pageID=passive_skill_stats._pageID
|q_join=passive_skills._pageID=passive_skill_stats._pageID
Line 7: Line 7:
   AND passive_skills.is_keystone = true
   AND passive_skills.is_keystone = true
   AND passive_skills.stat_text > ""
   AND passive_skills.stat_text > ""
  AND ((passive_skills.id NOT LIKE "karui_keystone%" AND passive_skills.id NOT LIKE "eternal_keystone%" AND passive_skills.id NOT LIKE "vaal_keystone%" AND passive_skills.id NOT LIKE "templar_keystone%" AND passive_skills.id NOT LIKE "maraketh_keystone%")
  OR (passive_skills.name = "vaal_keystone_2" OR passive_skills.name = "karui_keystone_3"))
   {{#if: {{{where|}}}|AND ({{{where|}}})|}}
   {{#if: {{{where|}}}|AND ({{{where|}}})|}}
|q_orderBy={{{q_orderBy|passive_skills.name}}}
|q_orderBy={{{q_orderBy|passive_skills.name}}}