User:Teamtoto/Sandbox: Difference between revisions

User:Teamtoto/Sandbox (view source)

Revision as of 15:44, 10 September 2019

56 bytes removed , 15:44, 10 September 2019

no edit summary

Teamtoto

Bureaucrats, Interface administrators, Suppressors, Administrators

8,756

edits

@@ Line 10: / Line 10: @@
 | group1style = background:rgba(6,28,23,0.2);
+| group1= Unique Characters
+| list1      =<span style="display:inline-block">{{#invoke:CargoQuery| main
+|q?tables=CreatureFactions=CF,GeneralData=GD,ExtraInfo=EI
+|q?join=CF._pageName=GD._pageName, CF._pageName=EI._pageName
+|q?fields=GD.PlainName=Page
+|q?where=Faction='{{{1|Barathrumites}}}' AND GD._pageNamespace ='0' AND EI.Info LIKE "%Unique,%"
+|template=favilink
+|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>
-| list1      =<span style="display:inline-block">{{#invoke:CargoQuery| main |q?tables=CreatureFactions,GeneralData|q?join=CreatureFactions._pageName=GeneralData._pageName|q?fields=CONCAT(PlainName)=Page|q?where=Faction="{{{1|Barathrumites}}}" 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">}}</span>
+|group2=Common Creatures
 | list2=<span style="display:inline-block">{{#invoke:CargoQuery| main
-|q?tables=CreatureFactions,GeneralData,_pageData
+|q?tables=CreatureFactions=CF,GeneralData=GD,ExtraInfo=EI
-|q?join=CreatureFactions._pageName=GeneralData._pageName, CreatureFactions._pageName=_pageData._pageName
+|q?join=CF._pageName=GD._pageName, CF._pageName=EI._pageName
-|q?fields=GeneralData.PlainName=Page
+|q?fields=GD.PlainName=Page
-|q?where=Faction='Barathrumites' AND _pageData._pageNamespace ='0' AND _pageData._categories__full LIKE '%Unique Characters%'
+|q?where=Faction='Barathrumites' AND GD._pageNamespace ='0' AND (EI.Info NOT LIKE "%Unique,%" OR EI.Info IS NULL)
 |template=favilink
 |delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>