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


AND Games_Catalog.Competition IN (1,  2,  3,  4,  5,  6,  7,  8,  9,  10,  11,  12,  13,  14,  15,  16,  17,  18,  20,  22,  23,  24,  25,  26,  27,  28,  29)


 

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