הצגת המקור של הדף "סטטיסטיקות מדי כדורגל"

{{תיבת טקסט
|כותרת=כמה משחקים תוייגו עם מדים במכביפדיה?
|תוכן=תוייגו 
{{#cargo_query:
table=Football_Games_Uniforms
|where=1=1
AND KitName != ""
|fields=Count(*)
}} משחקים עם מדים במכביפדיה
}}<!--


-->{{תיבת טקסט
|כותרת=עם אילו מדים מכבי שיחקו הכי הרבה?
|תוכן=<!--  We will join only on the MainKitItem, because each kit may contains several items, and we want to count each game as one row -->
{{#cargo_query:
tables=Football_Games_Uniforms, Football_Uniforms
|join on=Football_Games_Uniforms.KitName=Football_Uniforms.KitName,
Football_Games_Uniforms.Season=Football_Uniforms.Season
|where=1=1
AND Football_Games_Uniforms.KitName != ""
AND Football_Uniforms.MainKitItem = 1
|group by=Football_Games_Uniforms.KitName, Football_Games_Uniforms.Season
|order by=Count(*) DESC
|fields=CONCAT('[[', Football_Uniforms._pageName, '|100px]]')=מדים,
CONCAT('[[', 'מדי עונת ', Football_Games_Uniforms.Season, '|', Football_Games_Uniforms.KitName, ']]' )=שם סט,
Football_Games_Uniforms.Season=עונה,
Count(*)=כמות משחקים,
Football_Games_Uniforms._pageName=משחק לדוגמא
|limit=150
}}
}}<!--


-->{{תיבת טקסט
|כותרת=עם אילו מדים מכבי שיחקו בכל משחק
|תוכן=
{{#cargo_query:
tables=Football_Games_Uniforms, Football_Games, Competitions, Football_Uniforms
|join on= Football_Games_Uniforms._pageID = Football_Games._pageID, 
Football_Games.Competition = Competitions.OriginalName,
Football_Uniforms.KitName = Football_Games_Uniforms.KitName,
Football_Uniforms.Season = Football_Games_Uniforms.Season
|where=1=1
AND Competition.Official=1
AND Football_Uniforms.MainKitItem = 1
|fields=Football_Games.Date=תאריך, Football_Uniforms.KitType=סוג סט, Football_Games_Uniforms.KitName=שם סט, Football_Games_Uniforms.Season=עונת מדים, Competitions.OriginalName=מפעל, Football_Games.Leg=שלב במפעל, CONCAT('[[', Football_Games_Uniforms._pageName, '| עמוד משחק', ']]')=עמוד משחק
|format=dynamic table
|rows per page=50
|order by=Football_Games.Date ASC
|limit=5000
}}
}}

{{תיבת טקסט
|כותרת=מדים שניצחנו איתם הכי הרבה
|תוכן=
{{#cargo_query:
tables=Football_Games, Football_Games_Uniforms
|join on=Football_Games._pageID = Football_Games_Uniforms._pageID
|where=1=1
AND Football_Games_Uniforms.KitName IS NOT NULL
AND Football_Games.ResultOpt = 1
|fields=Football_Games_Uniforms.Season, Football_Games_Uniforms.KitName, Football_Games._pageName=משחק לדוגמא, COUNT(*)=מספר נצחונות
|group by=Football_Games_Uniforms.Season, Football_Games_Uniforms.KitName
|order by=COUNT(*) DESC
|format=dynamic table
|rows per page=25
}}

}}

{{תיבת טקסט
|כותרת=מדים שהפסדנו איתם הכי הרבה
|תוכן=
{{#cargo_query:
tables=Football_Games, Football_Games_Uniforms
|join on=Football_Games._pageID = Football_Games_Uniforms._pageID
|where=1=1
AND Football_Games_Uniforms.KitName IS NOT NULL
AND Football_Games.ResultOpt = 3
|fields=Football_Games_Uniforms.Season, Football_Games_Uniforms.KitName, Football_Games._pageName=משחק לדוגמא, COUNT(*)=מספר הפסדים
|group by=Football_Games_Uniforms.Season, Football_Games_Uniforms.KitName
|order by=COUNT(*) DESC
|format=dynamic table
|rows per page=25
}}

}}


[[קטגוריה:תבניות קטלוג מדי כדורגל]]
[[קטגוריה:תיוג מדים במשחקים]]