שאילתת Cargo

שינוי שאילתא
  
  
  
  
  
  
    
  
  

הצגת תחביר הוויקי
{{#cargo_query:
tables=Football_Games, Games_Referees, Games_Results, Opponents, Competitions
|fields=CONCAT('[[', Football_Games._pageName, '|',  Football_Games.Date,  ': ', Games_Results.ResultString, ' (', Football_Games.ResultMaccabi, ':', Football_Games.ResultOpponent, ')',  ' נגד ', Opponents.OriginalName,  ']]' )
|where=1=1




AND Competitions.League = 1





AND Football_Games.Opponent IN ("הפועל עירוני ראשון לציון","הפועל ראשון לציון")





AND Football_Games.ResultMaccabi-Football_Games.ResultOpponent > 0
|join on=Football_Games._pageID = Games_Referees._pageID,
Football_Games.Opponent = Opponents.CanonicalName,
Football_Games.ResultOpt = Games_Results.ResultType,
Football_Games.Competition = Competitions.OriginalName
|order by=(`MPMW_cargo__Football_Games`.`ResultMaccabi`-`MPMW_cargo__Football_Games`.`ResultOpponent`) Desc 
|format=ol
|offset=15
|limit=100
}}