Difference between revisions of "CargoTest"
Jump to navigation
Jump to search
Line 4: | Line 4: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=CupMatches | tables=CupMatches | ||
|fields=_pageName,Team1,Goals1,Score,Goals2,Team2 | |fields=_pageName=Tournament,Team1=Home,Goals1=Home Goals,Score,Goals2=Away Goals,Team2=Away | ||
|format=table | |format=table | ||
|merge similar cells = yes | |||
|where=(Team1 LIKE '%mu%' OR Team2 LIKE '%mu%') AND _pageName LIKE '201% 4Chan%Cup' | |where=(Team1 LIKE '%mu%' OR Team2 LIKE '%mu%') AND _pageName LIKE '201% 4Chan%Cup' | ||
|order by=_PAGEID ASC | |order by=_PAGEID ASC |
Revision as of 04:28, 4 May 2018
This is to figure out how the cargo extension works
Official Matches
{{#cargo_query: tables=CupMatches |fields=_pageName=Tournament,Team1=Home,Goals1=Home Goals,Score,Goals2=Away Goals,Team2=Away |format=table |merge similar cells = yes |where=(Team1 LIKE '%mu%' OR Team2 LIKE '%mu%') AND _pageName LIKE '201% 4Chan%Cup' |order by=_PAGEID ASC }}
Unofficial Matches
{{#cargo_query: tables=CupMatches |fields=_pageName,Team1,Goals1,Score,Goals2,Team2 |format=table |where=(Team1 LIKE '%mu%' OR Team2 LIKE '%mu%') AND _pageName NOT LIKE '201% 4Chan%Cup' AND _pageName NOT LIKE 'User%' AND _pageName NOT LIKE '%History%' |order by=_PAGEID ASC }}