User:Teamtoto/Sandbox: Difference between revisions

Jump to navigation Jump to search
1,392 bytes added ,  22:54, 9 September 2019
m
no edit summary
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{#invoke:CargoQuery| main |q?tables=CreatureFactions,GeneralData|q?join=CreatureFactions._pageName=GeneralData._pageName|q?fields=CONCAT(CreatureFactions._pageName)=Page|q?where=Faction="{{{1|Crabs}}}" AND CreatureFactions._pageNamespace ='0'|q?orderBy=CreatureFactions._pageName|q?groupBy=CreatureFactions._pageName|format=template|template=favilink|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}
{{#invoke:CargoQuery| main |q?tables=CreatureFactions,GeneralData|q?join=CreatureFactions._pageName=GeneralData._pageName|q?fields=CONCAT(CreatureFactions._pageName)=Page|q?where=Faction="{{{1|Crabs}}}" AND CreatureFactions._pageNamespace ='0'|q?orderBy=CreatureFactions._pageName|q?groupBy=CreatureFactions._pageName|format=template|template=favilink|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}
{{Navbox
| name      = Creature Navbox
| title      = Creatures in the {{{1|}}} Faction
| listclass  = hlist
| state      = {{{state|collapsed}}}
| titlestyle = background:rgba(6,28,23,0.9); font-family:Source Code Pro;
| groupstyle = background:rgba(6,28,23,0.8); font-family:Source Code Pro;
| innerstyle = font-family:Source Code Pro;
| group1style = background:rgba(6,28,23,0.2);
| list1      =<span style="display:inline-block">{{#invoke:CargoQuery| main |q?tables=GeneralData,CreatureFactions,_pageData
|q?join=_pageData._pageName=GeneralData._pageName,GeneralData._pageName=CreatureFactions._pageName
|q?fields=PlainName=Page
|q?where=Faction="{{{1|Barathrumites}}}" AND CreatureFactions._pageNamespace ='0' AND _isRedirect = '0'
|q?orderBy=CreatureFactions._pageName
|template=single query result
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>
| list2=<span style="display:inline-block">{{#invoke:CargoQuery| main
|q?tables=CreatureFactions,GeneralData,_pageData
|q?join=CreatureFactions._pageName=GeneralData._pageName, CreatureFactions._pageName=_pageData._pageName
|q?fields=GeneralData.PlainName=Page
|q?where=Faction='Barathrumites' AND _pageData._pageNamespace ='0' AND _pageData._categories__full LIKE '%Unique Characters%' AND _isRedirect = '0'
|template=favilink
|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>
}}




Navigation menu