User:Teamtoto/Sandbox: Difference between revisions

937 bytes removed ,  23:05, 12 April 2021
m
no edit summary
mNo edit summary
mNo edit summary
Line 1: Line 1:
<pre>
{{#invoke:CargoQuery| main
{{#invoke:CargoQuery| main
| tables=ItemsTable=IT,GeneralData=GD
| tables = GeneralData=GD, Characters = C, CreatureFactions = CF
| join on = IT.ObjectID = GD.ObjectID
| join = C.ObjectID = GD.ObjectID, C.ObjectID = CF.ObjectID
| fields={{favilink format args}}
| where = C.Demeanor = "aggressive" AND (C._pageNamespace= '0' OR C._pageNamespace = '10002')
| where= HarvestedInto= "vinewafer"
| fields = {{favilink format args}}
|template=favilink format
| default = {{Template Error|Creature level and faction}}
| delimiter = </br>
| one_to_many=CONCAT('[[', CF.Faction, ']]')=outro
|default=None}}
| one_to_many_group=C.ObjectID
</pre>
| one_to_many_sep=,
{{#invoke:CargoQuery| main
| tables=ItemsTable=IT,GeneralData=GD
| join on = IT.ObjectID = GD.ObjectID
| fields={{favilink format args}}
| where= HarvestedInto= "vinewafer"
|template=favilink format
| delimiter = </br>
|default=None}}
 
<Pre>{{#invoke:CargoQuery| compound
| 1=table=ItemsTable
; fields=ObjectID=Page
; where= HarvestedInto= "vinewafer"
|template=favilink id
| delimiter = </br>
|default=None}}</pre>
{{#invoke:CargoQuery| compound
| 1=table=ItemsTable
; fields=ObjectID=Page
; where= HarvestedInto= "vinewafer"
| 2 = table=Characters
;fields=ObjectID=Page
; where= HarvestedInto= "vinewafer"
|template=favilink id
| delimiter = </br>
|default=None}}
 
this one is broken:
<pre>
{{#invoke:CargoQuery| compound
| 1=tables=ItemsTable=IT, GeneralData=GD
; join on= IT.ObjectID = GD.ObjectID
; fields= {{favilink format args}}
; where= HarvestedInto= "vinewafer"
| template = favilink format
| delimiter = </br>
|default=None}}
</pre>
{{#invoke:CargoQuery| compound
| 1=tables=ItemsTable=IT, GeneralData=GD
; join on= IT.ObjectID = GD.ObjectID
; fields= {{favilink format args}}
; where= HarvestedInto= "vinewafer"
| template = favilink format
| template = favilink format
| delimiter = </br>
| format = ul
|default=None}}
| columns = 2
 
}}
<!--{{#invoke:cargo_query|main
<!--{{#invoke:cargo_query|main
| table=Factions=F
| table=Factions=F