אין תקציר עריכה |
(Search by canonical opponent (so every related opponent will appear in same search)) |
||
| (19 גרסאות ביניים של אותו משתמש אינן מוצגות) | |||
| שורה 8: | שורה 8: | ||
-->{{#vardefine: SetsForOpponentOperator| {{#בחר:{{{OpponentSetsAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!-- | -->{{#vardefine: SetsForOpponentOperator| {{#בחר:{{{OpponentSetsAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!-- | ||
-->{{#vardefine: SetsDiffForMaccabiOperator| {{#בחר:{{{MaccabiSetsDifferentAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!-- | -->{{#vardefine: SetsDiffForMaccabiOperator| {{#בחר:{{{MaccabiSetsDifferentAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!-- | ||
-->{{#vardefine: PointsDiffForMaccabiOperator| {{#בחר:{{{MaccabiPointsDifferentAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!-- | |||
-->{{#vardefine: SameOpponents|{{כדורעף/המרות/המרות יריבה/יריבה לרשימת יריבות מקושרות| יריבה={{{Opponent|}}} }} }}<!-- | |||
-->{{#cargo_query: | -->{{#cargo_query: | ||
tables=Volleyball_Games, Games_Results, Days_In_Week, Volleyball_Competitions | tables=Volleyball_Games, Games_Results, Days_In_Week, Volleyball_Competitions | ||
| שורה 26: | שורה 29: | ||
{{#if: {{{Stadium|}}} | AND Volleyball_Games.Stadium = "{{{Stadium|}}}" }} | {{#if: {{{Stadium|}}} | AND Volleyball_Games.Stadium = "{{{Stadium|}}}" }} | ||
{{#if: {{{Opponent|}}} | AND Volleyball_Games.Opponent | {{#if: {{{Opponent|}}} | AND Volleyball_Games.Opponent IN ({{#var: SameOpponents}}) }}<!-- the "()" around the SameOpponents required for "IN" operator --> | ||
{{#if: {{{Coach|}}} | AND Volleyball_Games.CoachMaccabi="{{{Coach}}}" }} | {{#if: {{{Coach|}}} | AND Volleyball_Games.CoachMaccabi="{{{Coach}}}" }} | ||
{{#if: {{{CoachOpponent|}}} | AND Volleyball_Games.CoachOpponent="{{{CoachOpponent}}}" }} | {{#if: {{{CoachOpponent|}}} | AND Volleyball_Games.CoachOpponent="{{{CoachOpponent}}}" }} | ||
| שורה 35: | שורה 38: | ||
{{#if: {{{MaccabiSets|}}} | AND Volleyball_Games.TotalSetsMaccabi{{#var: SetsForMaccabiOperator}} {{{MaccabiSets}}} }} | {{#if: {{{MaccabiSets|}}} | AND Volleyball_Games.TotalSetsMaccabi{{#var: SetsForMaccabiOperator}} {{{MaccabiSets}}} }} | ||
{{#if: {{{MaccabiSetsDifferent|}}} | AND Volleyball_Games.TotalSetsMaccabi- Volleyball_Games.TotalSetsOpponent {{#var: SetsDiffForMaccabiOperator}} {{{MaccabiSetsDifferent}}} }} | {{#if: {{{MaccabiSetsDifferent|}}} | AND Volleyball_Games.TotalSetsMaccabi- Volleyball_Games.TotalSetsOpponent {{#var: SetsDiffForMaccabiOperator}} {{{MaccabiSetsDifferent}}} }} | ||
{{#if: {{{MaccabiPointsDifferent|}}} | AND Volleyball_Games.TotalPointsMaccabi- Volleyball_Games.TotalPointsOpponent {{#var: PointsDiffForMaccabiOperator}} {{{MaccabiPointsDifferent}}} }} | |||
{{#if: {{{OpponentSets|}}} | AND Volleyball_Games.TotalSetsOpponent {{#var: SetsForOpponentOperator}} {{{OpponentSets}}} }} | {{#if: {{{OpponentSets|}}} | AND Volleyball_Games.TotalSetsOpponent {{#var: SetsForOpponentOperator}} {{{OpponentSets}}} }} | ||
{{#if: {{{GameResult|}}} | AND Games_Results.ResultString = "{{{GameResult}}}" }} | {{#if: {{{GameResult|}}} | AND Games_Results.ResultString = "{{{GameResult}}}" }} | ||
| שורה 56: | שורה 60: | ||
-->|fields=CONCAT('[[', Volleyball_Games._pageName, '|המשחק]]')=המשחק | -->|fields=CONCAT('[[', Volleyball_Games._pageName, '|המשחק]]')=המשחק | ||
,Volleyball_Games.Date=תאריך | ,Volleyball_Games.Date=תאריך | ||
,CONCAT('[[עונת ', Volleyball_Games.Season, ']]')=עונה | ,CONCAT('[[כדורעף:עונת ', Volleyball_Games.Season, '|עונת ', Volleyball_Games.Season, ']]')=עונה | ||
,Volleyball_Games.Competition=מפעל | ,Volleyball_Games.Competition=מפעל | ||
,Volleyball_Games.Leg=שלב במפעל | ,Volleyball_Games.Leg=שלב במפעל | ||
| שורה 65: | שורה 69: | ||
,Volleyball_Games.TotalSetsOpponent=מערכות ליריבה | ,Volleyball_Games.TotalSetsOpponent=מערכות ליריבה | ||
,Games_Results.ResultString=תוצאת משחק <!-- Cast number to string from games results table --> | ,Games_Results.ResultString=תוצאת משחק <!-- Cast number to string from games results table --> | ||
,CONCAT('[[', Volleyball_Games.CoachMaccabi, ']]')=מאמן מכבי | ,CONCAT('[[כדורעף:', Volleyball_Games.CoachMaccabi, ']]')=מאמן מכבי | ||
,Volleyball_Games.CoachOpponent=מאמן יריבה | ,Volleyball_Games.CoachOpponent=מאמן יריבה | ||
,Volleyball_Games.TotalPointsMaccabi=נק למכבי | ,Volleyball_Games.TotalPointsMaccabi=נק למכבי | ||
,IF(Volleyball_Games.TotalPointsMaccabi>Volleyball_Games.TotalPointsOpponent, Volleyball_Games.TotalPointsMaccabi-Volleyball_Games.TotalPointsOpponent, Volleyball_Games.TotalPointsMaccabi-Volleyball_Games.TotalPointsOpponent)=הפרש נק למכבי | |||
,Volleyball_Games.TotalPointsOpponent=נק ליריבה | ,Volleyball_Games.TotalPointsOpponent=נק ליריבה | ||
,Volleyball_Games.Refs=שופט | ,Volleyball_Games.Refs=שופט | ||
| שורה 81: | שורה 86: | ||
|order by=Volleyball_Games.Date DESC | |order by=Volleyball_Games.Date DESC | ||
}}<!-- | }}<!-- | ||
Show distribution of the game result | Show distribution of the game result | ||
-->{{#cargo_query: | --> | ||
== התפלגות תוצאות משחקים == | |||
{{#cargo_query: | |||
tables=Volleyball_Games, Games_Results, Days_In_Week, Volleyball_Competitions | tables=Volleyball_Games, Games_Results, Days_In_Week, Volleyball_Competitions | ||
|join on=Volleyball_Games.ResultOpt = Games_Results.ResultType | |join on=Volleyball_Games.ResultOpt = Games_Results.ResultType | ||
| שורה 101: | שורה 111: | ||
{{#if: {{{Stadium|}}} | AND Volleyball_Games.Stadium = "{{{Stadium|}}}" }} | {{#if: {{{Stadium|}}} | AND Volleyball_Games.Stadium = "{{{Stadium|}}}" }} | ||
{{#if: {{{Opponent|}}} | AND Volleyball_Games.Opponent | {{#if: {{{Opponent|}}} | AND Volleyball_Games.Opponent IN ({{#var: SameOpponents}}) }}<!-- the "()" around the SameOpponents required for "IN" operator --> | ||
{{#if: {{{Coach|}}} | AND Volleyball_Games.CoachMaccabi="{{{Coach}}}" }} | {{#if: {{{Coach|}}} | AND Volleyball_Games.CoachMaccabi="{{{Coach}}}" }} | ||
{{#if: {{{CoachOpponent|}}} | AND Volleyball_Games.CoachOpponent="{{{CoachOpponent}}}" }} | {{#if: {{{CoachOpponent|}}} | AND Volleyball_Games.CoachOpponent="{{{CoachOpponent}}}" }} | ||
| שורה 132: | שורה 142: | ||
COUNT(*)=כמות משחקים | COUNT(*)=כמות משחקים | ||
|format=ol | |||
|format= | |||
|group by=Games_Results.ResultString | |group by=Games_Results.ResultString | ||
|order by=COUNT(*) DESC | |||
}}<!-- | }}<!-- | ||
גרסה אחרונה מ־02:23, 1 בדצמבר 2025
ערכו את הדף כדי לצפות בטקסט התבנית.