שאילתת 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 (9)


AND Games_Catalog.Competition IN (10,  11,  12,  13,  14,  15,  16,  20,  22,  23,  24,  29)
|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=עוד
}}