שאילתת Cargo

שינוי שאילתא
  
  
  
  
  
  
    
  
  

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

AND Games_Catalog.Competition IN (1,  2,  3,  4)
AND Games_Catalog.Stadium IN ("אצטדיון טדי")






AND Games_Catalog.ResultMaccabi-Games_Catalog.ResultOpponent > 0
|join on=Games_Catalog._pageID = Games_Referees._pageID,
Games_Catalog.Opponent = Opponents.CanonicalName,
Games_Catalog.ResultOpt = Games_Results.ResultType
|order by=(`MPMW_cargo__Games_Catalog`.`ResultMaccabi`-`MPMW_cargo__Games_Catalog`.`ResultOpponent`) Desc 
|format=ol
|offset=10
|limit=100
}}