תבנית:פרופיל/מספרים עונתיים/מאמן/הצגת קטגוריית מפעל - היסטוריית גרסאות

https://www.maccabipedia.co.il/index.php?action=history&feed=atom&title=%D7%AA%D7%91%D7%A0%D7%99%D7%AA%3A%D7%A4%D7%A8%D7%95%D7%A4%D7%99%D7%9C%2F%D7%9E%D7%A1%D7%A4%D7%A8%D7%99%D7%9D_%D7%A2%D7%95%D7%A0%D7%AA%D7%99%D7%99%D7%9D%2F%D7%9E%D7%90%D7%9E%D7%9F%2F%D7%94%D7%A6%D7%92%D7%AA_%D7%A7%D7%98%D7%92%D7%95%D7%A8%D7%99%D7%99%D7%AA_%D7%9E%D7%A4%D7%A2%D7%9C תבנית:פרופיל/מספרים עונתיים/מאמן/הצגת קטגוריית מפעל - היסטוריית גרסאות 2026-04-25T07:31:14Z היסטוריית הגרסאות של הדף הזה בוויקי MediaWiki 1.39.11 https://www.maccabipedia.co.il/index.php?title=%D7%AA%D7%91%D7%A0%D7%99%D7%AA:%D7%A4%D7%A8%D7%95%D7%A4%D7%99%D7%9C/%D7%9E%D7%A1%D7%A4%D7%A8%D7%99%D7%9D_%D7%A2%D7%95%D7%A0%D7%AA%D7%99%D7%99%D7%9D/%D7%9E%D7%90%D7%9E%D7%9F/%D7%94%D7%A6%D7%92%D7%AA_%D7%A7%D7%98%D7%92%D7%95%D7%A8%D7%99%D7%99%D7%AA_%D7%9E%D7%A4%D7%A2%D7%9C&diff=104363&oldid=prev Kosh ב־09:40, 17 בספטמבר 2022 2022-09-17T09:40:13Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="he"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">→ הגרסה הקודמת</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">גרסה מ־12:40, 17 בספטמבר 2022</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l41">שורה 41:</td> <td colspan="2" class="diff-lineno">שורה 41:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|template=פרופיל/מספרים עונתיים/מאמן/הצגת קטגוריית מפעל/שורה אחת</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|template=פרופיל/מספרים עונתיים/מאמן/הצגת קטגוריית מפעל/שורה אחת</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|named args=yes</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|named args=yes</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|default=אין הופעות</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>}} </table>

Kosh https://www.maccabipedia.co.il/index.php?title=%D7%AA%D7%91%D7%A0%D7%99%D7%AA:%D7%A4%D7%A8%D7%95%D7%A4%D7%99%D7%9C/%D7%9E%D7%A1%D7%A4%D7%A8%D7%99%D7%9D_%D7%A2%D7%95%D7%A0%D7%AA%D7%99%D7%99%D7%9D/%D7%9E%D7%90%D7%9E%D7%9F/%D7%94%D7%A6%D7%92%D7%AA_%D7%A7%D7%98%D7%92%D7%95%D7%A8%D7%99%D7%99%D7%AA_%D7%9E%D7%A4%D7%A2%D7%9C&diff=104349&oldid=prev Kosh ב־08:18, 17 בספטמבר 2022 2022-09-17T08:18:05Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="he"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">→ הגרסה הקודמת</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">גרסה מ־11:18, 17 בספטמבר 2022</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l46">שורה 46:</td> <td colspan="2" class="diff-lineno">שורה 46:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Summary bolded line</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Summary bolded line</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-->{{#cargo_query:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-->{{#cargo_query:</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>tables=Football_Games<del style="font-weight: bold; text-decoration: none;">, Games_Events</del>, Games_Referees, Competitions</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>tables=Football_Games, Games_Referees, Competitions</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>|join on=<del style="font-weight: bold; text-decoration: none;">Football_Games._pageID=Games_Events._pageID,</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>|join on=Football_Games._pageID=Games_Referees._pageID,</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Football_Games._pageID=Games_Referees._pageID,</div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Football_Games.Competition=Competitions.OriginalName</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Football_Games.Competition=Competitions.OriginalName</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|where=1=1</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|where=1=1</div></td></tr>  </table>

Kosh https://www.maccabipedia.co.il/index.php?title=%D7%AA%D7%91%D7%A0%D7%99%D7%AA:%D7%A4%D7%A8%D7%95%D7%A4%D7%99%D7%9C/%D7%9E%D7%A1%D7%A4%D7%A8%D7%99%D7%9D_%D7%A2%D7%95%D7%A0%D7%AA%D7%99%D7%99%D7%9D/%D7%9E%D7%90%D7%9E%D7%9F/%D7%94%D7%A6%D7%92%D7%AA_%D7%A7%D7%98%D7%92%D7%95%D7%A8%D7%99%D7%99%D7%AA_%D7%9E%D7%A4%D7%A2%D7%9C&diff=104334&oldid=prev Kosh ב־15:35, 16 בספטמבר 2022 2022-09-16T15:35:19Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="he"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">→ הגרסה הקודמת</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">גרסה מ־18:35, 16 בספטמבר 2022</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l30">שורה 30:</td> <td colspan="2" class="diff-lineno">שורה 30:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> COUNT(*)=TotalGames,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> COUNT(*)=TotalGames,</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when Football_Games.ResultOpt=1 then 1 else 0 end)=Wins,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when Football_Games.ResultOpt=1 then 1 else 0 end)=Wins,</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when <del style="font-weight: bold; text-decoration: none;">AND </del>Football_Games.ResultOpt=2 then 1 else 0 end)=Ties,</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when Football_Games.ResultOpt=2 then 1 else 0 end)=Ties,</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when <del style="font-weight: bold; text-decoration: none;">AND </del>Football_Games.ResultOpt=3 then 1 else 0 end)=Losses,</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when Football_Games.ResultOpt=3 then 1 else 0 end)=Losses,</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(Football_Games.ResultMaccabi)=TotalGoalsForMaccabi,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(Football_Games.ResultMaccabi)=TotalGoalsForMaccabi,</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(Football_Games.ResultOpponent)=TotalGoalsAgainstMaccabi,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(Football_Games.ResultOpponent)=TotalGoalsAgainstMaccabi,</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l62">שורה 62:</td> <td colspan="2" class="diff-lineno">שורה 62:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> COUNT(*)=TotalGames,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> COUNT(*)=TotalGames,</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when Football_Games.ResultOpt=1 then 1 else 0 end)=Wins,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when Football_Games.ResultOpt=1 then 1 else 0 end)=Wins,</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when <del style="font-weight: bold; text-decoration: none;">AND </del>Football_Games.ResultOpt=2 then 1 else 0 end)=Ties,</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when Football_Games.ResultOpt=2 then 1 else 0 end)=Ties,</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when <del style="font-weight: bold; text-decoration: none;">AND </del>Football_Games.ResultOpt=3 then 1 else 0 end)=Losses,</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> SUM(CASE when Football_Games.ResultOpt=3 then 1 else 0 end)=Losses,</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(Football_Games.ResultMaccabi)=TotalGoalsForMaccabi,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(Football_Games.ResultMaccabi)=TotalGoalsForMaccabi,</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(Football_Games.ResultOpponent)=TotalGoalsAgainstMaccabi,</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> SUM(Football_Games.ResultOpponent)=TotalGoalsAgainstMaccabi,</div></td></tr> </table>

Kosh https://www.maccabipedia.co.il/index.php?title=%D7%AA%D7%91%D7%A0%D7%99%D7%AA:%D7%A4%D7%A8%D7%95%D7%A4%D7%99%D7%9C/%D7%9E%D7%A1%D7%A4%D7%A8%D7%99%D7%9D_%D7%A2%D7%95%D7%A0%D7%AA%D7%99%D7%99%D7%9D/%D7%9E%D7%90%D7%9E%D7%9F/%D7%94%D7%A6%D7%92%D7%AA_%D7%A7%D7%98%D7%92%D7%95%D7%A8%D7%99%D7%99%D7%AA_%D7%9E%D7%A4%D7%A2%D7%9C&diff=104331&oldid=prev Kosh: יצירת דף עם התוכן "<includeonly><div class="ProfilesST-Table">{{{שוער|}}} <div class="ProfilesST-IR"> <div style="display: table-cell;">עונה</div> <div style="dis..." 2022-09-16T15:28:48Z

<p>יצירת דף עם התוכן "<includeonly><div class="ProfilesST-Table">{{{שוער|}}} <div class="ProfilesST-IR"> <div style="display: table-cell;">עונה</div> <div style="dis..."</p> <p><b>דף חדש</b></p><div><includeonly><div class="ProfilesST-Table">{{{שוער|}}}<br /> <br /> <div class="ProfilesST-IR"><br /> <div style="display: table-cell;">עונה</div><br /> <div style="display: table-cell;">'''מש''''</div><br /> <div style="display: table-cell;">'''נצ''''</div><br /> <div style="display: table-cell;">'''ת''''</div><br /> <div style="display: table-cell;">'''הפ''''</div><br /> <div style="display: table-cell;">{{קטלוג משחקים/הצגת משחקים/טבלת אירועים/הצגת אייקונים |אייקון=גול}} ('''פ'''')</div><br /> <div style="display: table-cell;">'''ספיגות'''</div><br /> <div style="display: table-cell;">'''שער נקי'''</div><br /> </div><br /> <br /> {{#cargo_query:<br /> tables=Football_Games, Games_Referees, Competitions<br /> |join on=Football_Games._pageID=Games_Referees._pageID,<br /> Football_Games.Competition=Competitions.OriginalName<br /> |where=1=1<br /> AND Football_Games.CoachMaccabi="{{{מאמן}}}"<br /> <br /> {{#ifeq: {{{קטגוריית מפעל|}}}| ליגה| AND Competitions.League = 1 }}<br /> {{#ifeq: {{{קטגוריית מפעל|}}}| גביע| AND Competitions.Trophy = 1 }}<br /> {{#ifeq: {{{קטגוריית מפעל|}}}| בינלאומי| AND Competitions.International = 1 }}<br /> {{#ifeq: {{{קטגוריית מפעל|}}}| רשמי| AND Competitions.Official = 1 }}<br /> <br /> |fields=<br /> Football_Games.Season=Season,<br /> COUNT(*)=TotalGames,<br /> SUM(CASE when Football_Games.ResultOpt=1 then 1 else 0 end)=Wins,<br /> SUM(CASE when AND Football_Games.ResultOpt=2 then 1 else 0 end)=Ties,<br /> SUM(CASE when AND Football_Games.ResultOpt=3 then 1 else 0 end)=Losses,<br /> SUM(Football_Games.ResultMaccabi)=TotalGoalsForMaccabi,<br /> SUM(Football_Games.ResultOpponent)=TotalGoalsAgainstMaccabi,<br /> SUM(CASE when Football_Games.ResultOpponent=0 then 1 else 0 end)=CleanSheet,<br /> <br /> |group by=Football_Games.Season<br /> |order by=Football_Games.Season ASC<br /> |format=template<br /> |template=פרופיל/מספרים עונתיים/מאמן/הצגת קטגוריית מפעל/שורה אחת<br /> |named args=yes<br /> }}{{#cargo_query:<br /> tables=Football_Games, Games_Events, Games_Referees, Competitions<br /> |join on=Football_Games._pageID=Games_Events._pageID,<br /> Football_Games._pageID=Games_Referees._pageID,<br /> Football_Games.Competition=Competitions.OriginalName<br /> |where=1=1<br /> AND Football_Games.CoachMaccabi="{{{מאמן}}}"<br /> <br /> {{#ifeq: {{{קטגוריית מפעל|}}}| ליגה| AND Competitions.League = 1 }}<br /> {{#ifeq: {{{קטגוריית מפעל|}}}| גביע| AND Competitions.Trophy = 1 }}<br /> {{#ifeq: {{{קטגוריית מפעל|}}}| בינלאומי| AND Competitions.International = 1 }}<br /> {{#ifeq: {{{קטגוריית מפעל|}}}| רשמי| AND Competitions.Official = 1 }}<br /> <br /> |fields=<br /> Football_Games.Season=Season,<br /> COUNT(*)=TotalGames,<br /> SUM(CASE when Football_Games.ResultOpt=1 then 1 else 0 end)=Wins,<br /> SUM(CASE when AND Football_Games.ResultOpt=2 then 1 else 0 end)=Ties,<br /> SUM(CASE when AND Football_Games.ResultOpt=3 then 1 else 0 end)=Losses,<br /> SUM(Football_Games.ResultMaccabi)=TotalGoalsForMaccabi,<br /> SUM(Football_Games.ResultOpponent)=TotalGoalsAgainstMaccabi,<br /> SUM(CASE when Football_Games.ResultOpponent=0 then 1 else 0 end)=CleanSheet,<br /> <br /> |format=template<br /> |template=פרופיל/מספרים עונתיים/מאמן/הצגת קטגוריית מפעל/שורת סיכום<br /> |named args=yes<br /> }}<br /> <br /> </div></includeonly></div>

Kosh