Template:Skills overview: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
mNo edit summary
(holds not -> join value)
Line 2: Line 2:
{{qud quote|{{#cargo_query:table=Skills|fields=Description|where=_pageName='{{{1|}}}' AND Cost <> ''}}}}
{{qud quote|{{#cargo_query:table=Skills|fields=Description|where=_pageName='{{{1|}}}' AND Cost <> ''}}}}
<span style="text-size:large;"><b>Skills in the {{{1|}}} skill tree</b></span>
<span style="text-size:large;"><b>Skills in the {{{1|}}} skill tree</b></span>
{{#cargo_query:table=Skills|fields=_pageName=Skill,Cost, RequiredStats=Stat, PrerequisiteSkill=Skill Required,Description|where=Class HOLDS '{{{1|}}}' AND _pageName <> '{{{1|}}}' AND RequiredStats HOLDS NOT ''|order by=Stat, Cost ASC|group by=_pageName}}</includeonly><noinclude>[[Category:Query Templates]]</noinclude>
{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill,Cost, RequiredStats=Stat, PrerequisiteSkill=Skill Required,Description|where=Class HOLDS '{{{1|}}}' AND _pageName <> '{{{1|}}}' AND Skills__RequiredStats._value != ''''|order by=Stat, Cost ASC|group by=_pageName}}</includeonly><noinclude>[[Category:Query Templates]]</noinclude>

Revision as of 18:58, 26 July 2021