Difference between revisions of "User:Mornsta/Sandbox2"
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.