Difference between revisions of "CargoTest"
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
|order by=_PAGEID ASC | |order by=_PAGEID ASC | ||
}} | }} | ||
<table> | |||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=CupMatches;fields=_pageName=Tournament,MatchTime,CONCAT('[[/',Away,'/]]') = Opponent,CONCAT(HomeS,'-', AwayS) = Score, HomeG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND home = 'mu';order by=_pageName;limit=1000 | tables=CupMatches;fields=_pageName=Tournament,MatchTime,CONCAT('[[/',Away,'/]]') = Opponent,CONCAT(HomeS,'-', AwayS) = Score, HomeG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND home = 'mu';order by=_pageName;limit=1000 | ||
|tables=CupMatches;fields=_pageName=Tournament,MatchTime,CONCAT('[[/',Home,'/]]') = Opponent,CONCAT(AwayS,'-', HomeS) = Score, AwayG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND away = 'mu';order by=_pageName;limit=1000 | |tables=CupMatches;fields=_pageName=Tournament,MatchTime,CONCAT('[[/',Home,'/]]') = Opponent,CONCAT(AwayS,'-', HomeS) = Score, AwayG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND away = 'mu';order by=_pageName;limit=1000 | ||
|format= | |format=template|template=MatchHistory | ||
}} | }} | ||
</table> | |||
Revision as of 02:14, 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,CONCAT('/',Away,'/') = Opponent,CONCAT(HomeS,'-', AwayS) = Score, HomeG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND home = 'mu';order by=_pageName;limit=1000 |tables=CupMatches;fields=_pageName=Tournament,MatchTime,CONCAT('/',Home,'/') = Opponent,CONCAT(AwayS,'-', HomeS) = Score, AwayG = Goals;where=_pageName LIKE '201% 4Chan%Cup%' AND away = 'mu';order by=_pageName;limit=1000 |format=template|template=MatchHistory }}