User:Teamtoto/Sandbox: Difference between revisions

User:Teamtoto/Sandbox (view source)

Revision as of 02:16, 26 August 2019

481 bytes removed , 02:16, 26 August 2019

m

no edit summary

Teamtoto

Bureaucrats, Interface administrators, Suppressors, Administrators

8,756

edits

@@ Line 1: / Line 1: @@
-{{#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}}
+<pre>{{#cargo_query:tables=GeneralData=GD,CreatureFactions=CF,_pageData=PD,_pageData___categories=PDC|fields=GD._pageName|join on=GD._pageName=CF._pageName,PDC._rowID=PD._ID,PD._pageName=GD._pageName|where=CF.Faction="Barathrumites" AND PDC._value <>"Unique_Characters"}}</pre>
-<pre>
+{{#cargo_query:tables=GeneralData=GD,CreatureFactions=CF,_pageData=PD,_pageData___categories=PDC|fields=GD._pageName|join on=CF._pageName=GD._pageName,PDC._rowID=PD._ID,PD._pageName=GD._pageName|where=CF.Faction="Barathrumites" AND PDC._value <>"Unique_Characters"}}
-{{#cargo_query:table=CreatureFactions,_pageData, GeneralData|join on=CreatureFactions._pageName=_pageData._pageName,CreatureFactions._pageName=GeneralData._pageName|fields=CONCAT('[[File:',GeneralData.Image,'|16px]] [[',CreatureFactions._pageName,']]'),_categories|where=Faction="Barathrumites" AND CreatureFactions._pageNamespace ='0' AND _categories HOLDS NOT "Unique_Characters"|order by=CreatureFactions._pageName}}</pre>
-{{#cargo_query:table=CreatureFactions,_pageData, GeneralData|join on=CreatureFactions._pageName=_pageData._pageName,CreatureFactions._pageName=GeneralData._pageName|fields=CONCAT('[[File:',GeneralData.Image,'|16px]] [[',CreatureFactions._pageName,']]'),_categories|where=Faction="Barathrumites" AND CreatureFactions._pageNamespace ='0' AND _categories HOLDS NOT "Unique_Characters"|order by=CreatureFactions._pageName}}
+{{#cargo_query:tables=GeneralData=GD,CreatureFactions=CF,_pageData=PD,_pageData___categories|fields=GD._pageName,PD._categories__full|join on=GD._pageName=CF._pageName,GD._pageName=PD._pageName, _pageData___categories._rowID=PD._ID|where=CF.Faction="Barathrumites"}}