Difference between revisions of "User:Mornsta/Sandbox2"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
(Blanked the page)
>Mornsta-gpuser
Line 1: Line 1:
 +
<pre>
 +
{{#cargo_query:
 +
tables=table1=tableAlias1, table2=tablesAlias2, etc.
 +
|join on=table1.fieldA = table2.fieldB,table2.fieldC=table3.fieldD, etc.
 +
|fields=field1=fieldAlias1,field2=Alias2, etc.
 +
|where=table1.fieldE='some value' AND/OR etc.
 +
|group by=table1.fieldG
 +
|having=table1.fieldG='some value', etc.
 +
|order by=table2.fieldF, etc.
 +
|limit=some number
 +
|offset=some number
 +
|intro=some text
 +
|outro=some text
 +
|default=some text
 +
|more results text=some text
 +
|no html
 +
|max display chars=some number
 +
|format=format
 +
...additional format-based parameters
 +
}}
 +
</pre>
  
 +
{{#cargo_query:
 +
tables=Weapons
 +
|fields=WeaponName, Rarity
 +
|group by=_pageName
 +
|where=Abilities11 IS NULL
 +
|limit=999
 +
}}

Revision as of 18:13, 23 February 2019

{{#cargo_query:
tables=table1=tableAlias1, table2=tablesAlias2, etc.
|join on=table1.fieldA = table2.fieldB,table2.fieldC=table3.fieldD, etc.
|fields=field1=fieldAlias1,field2=Alias2, etc.
|where=table1.fieldE='some value' AND/OR etc.
|group by=table1.fieldG
|having=table1.fieldG='some value', etc.
|order by=table2.fieldF, etc.
|limit=some number
|offset=some number
|intro=some text
|outro=some text
|default=some text
|more results text=some text
|no html
|max display chars=some number
|format=format
...additional format-based parameters
}}
Error: Table Weapons not found.