שאילתת Cargo

שינוי שאילתא
  
  
  
  
  
  
    
  
  

View wikitext
{{#cargo_query:
tables=Games_Catalog, Games_Events
|fields=Games_Events.PlayerName, COUNT(*)
|where=1=1
AND Team=1
AND Games_Catalog.Competition NOT IN (19, 21)
AND Games_Catalog.Technical=-1
AND Games_Events.EventType IN (3)


AND Games_Catalog.Competition IN (1,  2,  3,  4)
AND Games_Catalog.Opponent IN ("הפועל כפר סבא")

AND Games_Events.SubType != 33
|join on=Games_Catalog._pageID=Games_Events._pageID
|group by=Games_Events.PlayerName
|order by=Count(*) DESC 
|format=template
|offset=15
|limit=100
|template=סטטיסטיקה/טבלת שיאנים
|more results text=עוד
}}