|
|
| שורה 1: |
שורה 1: |
| {{תיבת טקסט
| | <div class="fbshirt-stats-page-container"> |
| |כותרת=כמה משחקים תוייגו עם מדים במכביפדיה?
| | <div class="fbshirt-stats-games-records-section-container"><!-- |
| |תוכן=תוייגו
| | -->{{סטטיסטיקות מדי כדורגל/הכי הרבה משחקים}}<!-- |
| {{#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
| |
| }}
| |
| }}<!-- | |
|
| |
|
| | -->{{סטטיסטיקות מדי כדורגל/הכי הרבה הפסדים}}<!-- |
|
| |
|
| -->{{תיבת טקסט | | --></div> |
| |כותרת=עם אילו מדים מכבי שיחקו בכל משחק
| | </div> |
| |תוכן=
| |
| {{#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 Competitions.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
| |
| }}
| |
| | |
| }}
| |
| | |
| | |
| [[קטגוריה:תבניות קטלוג מדי כדורגל]]
| |
| [[קטגוריה:תיוג מדים במשחקים]]
| |
.png)
.png)
.png)
.png)
.png)
