User:Teamtoto/Sandbox: Difference between revisions

Jump to navigation Jump to search
m
no edit summary
mNo edit summary
mNo edit summary
Line 1: Line 1:
<pre>{{#cargo_query:table=ItemsTable|fields=ItemsTable._pageName=Page|where=WornOn='Arm' AND ItemsTable._pageNamespace='0'|format=list|delimiter=<nowiki> - </nowiki>}}</pre>
{{#cargo_query:table=_pageData,CreatureFactions,GeneralData|join on=_pageData._pageName=CreatureFactions._pageName,_pageData._pageName=GeneralData._pageName|fields=CONCAT('[[File:',GeneralData.Image,'|16px]] [[',CreatureFactions._pageName,']]')|format=list|delimiter=<nowiki> - </nowiki>|where=Faction="Barathrumites" AND CreatureFactions._pageNamespace ='0' AND _categories HOLDS NOT "Unique_Characters"|order by=CreatureFactions._pageName}}
{{#cargo_query:table=ItemsTable|fields=ItemsTable._pageName=Page|where=WornOn='Arm' AND ItemsTable._pageNamespace='0'|format=list|delimiter=<nowiki> - </nowiki>}}
<pre>
<pre>{{#cargo_query:table=ItemsTable|fields=ItemsTable._pageName=Page|where=WornOn='Arm' AND Skill = 'Shield' AND ItemsTable._pageNamespace='0'|format=list|delimiter=<nowiki> - </nowiki>}}</pre>
{{#cargo_query:table=CreatureFactions,_pageData|join on=CreatureFactions._pageName=_pageData._pageName|fields=CONCAT('[[',CreatureFactions._pageName,']]'),_categories|where=Faction="Barathrumites" AND CreatureFactions._pageNamespace ='0' AND _categories HOLDS NOT "Unique_Characters"|order by=CreatureFactions._pageName}}</pre>
{{#cargo_query:table=ItemsTable|fields=ItemsTable._pageName=Page|where=WornOn='Arm' AND Skill = 'Shield' AND ItemsTable._pageNamespace='0'|format=list|delimiter=<nowiki> - </nowiki>}}
{{#cargo_query:table=CreatureFactions,_pageData|join on=CreatureFactions._pageName=_pageData._pageName|fields=CONCAT('[[',CreatureFactions._pageName,']]'),_categories|where=Faction="Barathrumites" AND CreatureFactions._pageNamespace ='0' AND _categories HOLDS NOT "Unique_Characters"|order by=CreatureFactions._pageName}}
<pre>{{#cargo_query:table=ItemsTable|fields=ItemsTable._pageName=Page|where=WornOn='Arm' AND Skill <> 'Shield' AND ItemsTable._pageNamespace='0'|format=list|delimiter=<nowiki> - </nowiki>}}</pre>
{{#cargo_query:table=ItemsTable|fields=ItemsTable._pageName=Page|where=WornOn='Arm' AND Skill <> 'Shield' AND ItemsTable._pageNamespace='0'|format=list|delimiter=<nowiki> - </nowiki>}}

Navigation menu