Difference between revisions of "CargoTest"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
<table> | <table> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=CupMatches;fields=_pageName=Tournament,MatchTime | tables=CupMatches;fields=_pageName=Tournament,MatchTime,Away,HomeS, AwayS, HomeG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND home = 'mu';order by=_pageName;limit=1000 | ||
|tables=CupMatches;fields=_pageName=Tournament,MatchTime | |tables=CupMatches;fields=_pageName=Tournament,MatchTime,Home,AwayS,HomeS, AwayG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND away = 'mu';order by=_pageName;limit=1000 | ||
|format=template|template=MatchHistory | |format=template|template=MatchHistory | ||
}} | }} | ||
</table> | </table> | ||
Revision as of 02:59, 23 May 2018
This is to figure out how the cargo extension works
{{#cargo_query: tables=CupMatches |fields=_pageName=Tournament,Home,HomeG=Home Goals,CONCAT(HomeS,'-',AwayS) = Score,AwayG=Away Goals,Away=Away |format=dynamic table |where=_pageName = '2018 4chan Spring Babby Cup Group D' |order by=_PAGEID ASC }}
{{#cargo_compound_query: tables=CupMatches;fields=_pageName=Tournament,MatchTime,Away,HomeS, AwayS, HomeG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND home = 'mu';order by=_pageName;limit=1000 |tables=CupMatches;fields=_pageName=Tournament,MatchTime,Home,AwayS,HomeS, AwayG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND away = 'mu';order by=_pageName;limit=1000 |format=template|template=MatchHistory }}