שאילתת Cargo

{{#cargo_query:
tables=Football_Games, Games_Results, Opponents
|fields=CONCAT('[[', Football_Games._pageName, '|',  Football_Games.Date,  ': ', Games_Results.ResultString, ' (', Football_Games.ResultMaccabi, ':', Football_Games.ResultOpponent, ')',  ' נגד ', Opponents.OriginalName,  ']]' )
|where=1=1







AND Football_Games.Stadium IN ("אצטדיון שכונת התקווה")
|join on=Football_Games.Opponent = Opponents.CanonicalName,
         Football_Games.ResultOpt = Games_Results.ResultType
|order by=`MPMW_cargo__Football_Games`.`Date` DESC 
|format=ol
|offset=15
|limit=100
}}