99
edits
mNo edit summary |
(holds not -> join value) |
||
Line 13: | Line 13: | ||
| group1 = [[Axe]] | | group1 = [[Axe]] | ||
| list1 = <span style="display:inline-block">{{#cargo_query: | | list1 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Axe' AND _pageName <> 'Axe' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group2 = [[Bow and Rifle]] | | group2 = [[Bow and Rifle]] | ||
| list2 = <span style="display:inline-block">{{#cargo_query: | | list2 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Bow and Rifle' AND _pageName <> 'Bow and Rifle' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group3 = [[Cudgel]] | | group3 = [[Cudgel]] | ||
| list3 = <span style="display:inline-block">{{#cargo_query: | | list3 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Cudgel' AND _pageName <> 'Cudgel' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group4 = [[Heavy Weapon]] | | group4 = [[Heavy Weapon]] | ||
| list4 = <span style="display:inline-block">{{#cargo_query: | | list4 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Heavy Weapon' AND _pageName <> 'Heavy Weapon' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group5 = [[Long Blade]] | | group5 = [[Long Blade]] | ||
| list5 = <span style="display:inline-block">{{#cargo_query: | | list5 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Long Blade' AND _pageName <> 'Long Blade' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group6 = [[Pistol]] | | group6 = [[Pistol]] | ||
| list6 = <span style="display:inline-block">{{#cargo_query: | | list6 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Pistol' AND _pageName <> 'Pistol' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group7 = [[Shield]] | | group7 = [[Shield]] | ||
| list7 = <span style="display:inline-block">{{#cargo_query: | | list7 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Shield' AND _pageName <> 'Shield' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group8 = [[Short Blade]] | | group8 = [[Short Blade]] | ||
| list8 = <span style="display:inline-block">{{#cargo_query: | | list8 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Short Blade' AND _pageName <> 'Short Blade' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
}} | }} | ||
Line 46: | Line 46: | ||
| group1 = [[Acrobatics]] | | group1 = [[Acrobatics]] | ||
| list1 = <span style="display:inline-block">{{#cargo_query: | | list1 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Acrobatics' AND _pageName <> 'Acrobatics' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group2 = [[Cooking and Gathering]] | | group2 = [[Cooking and Gathering]] | ||
| list2 = <span style="display:inline-block">{{#cargo_query: | | list2 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Cooking and Gathering' AND _pageName <> 'Cooking and Gathering' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group3 = [[Customs and Folklore]] | | group3 = [[Customs and Folklore]] | ||
| list3 = <span style="display:inline-block">{{#cargo_query: | | list3 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Customs and Folklore' AND _pageName <> 'Customs and Folklore' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group4 = [[Dual Wield]] | | group4 = [[Dual Wield]] | ||
| list4 = <span style="display:inline-block">{{#cargo_query: | | list4 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Dual Wield' AND _pageName <> 'Dual Wield' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group5 = [[Endurance]] | | group5 = [[Endurance]] | ||
| list5 = <span style="display:inline-block">{{#cargo_query: | | list5 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Endurance' AND _pageName <> 'Endurance' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group6 = [[First Aid]] | | group6 = [[First Aid]] | ||
| list6 = <span style="display:inline-block">{{#cargo_query: | | list6 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'First Aid' AND _pageName <> 'First Aid' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group7 = [[Persuasion]] | | group7 = [[Persuasion]] | ||
| list7 = <span style="display:inline-block">{{#cargo_query: | | list7 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Persuasion' AND _pageName <> 'Persuasion' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group8 = [[Self-discipline]] | | group8 = [[Self-discipline]] | ||
| list8 = <span style="display:inline-block">{{#cargo_query: | | list8 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Self-discipline' AND _pageName <> 'Self-discipline' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group9 = [[Tactics]] | | group9 = [[Tactics]] | ||
| list9 = <span style="display:inline-block">{{#cargo_query: | | list9 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Tactics' AND _pageName <> 'Tactics' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group10 = [[Tinkering]] | | group10 = [[Tinkering]] | ||
| list10 = <span style="display:inline-block">{{#cargo_query: | | list10 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Tinkering' AND _pageName <> 'Tinkering' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
| group11 = [[Wayfaring]] | | group11 = [[Wayfaring]] | ||
| list11 = <span style="display:inline-block">{{#cargo_query: | | list11 = <span style="display:inline-block">{{#cargo_query:tables=Skills,Skills__RequiredStats|join on=Skills._ID=Skills__RequiredStats._rowID|fields=_pageName=Skill|where=Class HOLDS 'Wayfaring' AND _pageName <> 'Wayfaring' AND Skills__RequiredStats._value != ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter= - </span><span style="display:inline-block">}}</span> | ||
}} | }} | ||
}}<noinclude>[[Category:Navigation]]</noinlude> | }}<noinclude>[[Category:Navigation]]</noinlude> |