CargoTest

From Rigged Wiki
Revision as of 02:04, 23 May 2018 by North (talk | contribs)
Jump to navigation Jump to search

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 }}