Difference between revisions of "CargoTest"
| Line 7: | Line 7: | ||
|where=_pageName = '2018 4chan Spring Babby Cup Group D' | |where=_pageName = '2018 4chan Spring Babby Cup Group D' | ||
|order by=_PAGEID ASC | |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=table | |||
}} | }} | ||
Revision as of 02:04, 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=table }}