(Add the total point diff for maccabi) |
(Search by canonical opponent (so every related opponent will appear in same search)) |
||
| (4 גרסאות ביניים של אותו משתמש אינן מוצגות) | |||
| שורה 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}}}" }} | ||
| שורה 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=נק למכבי | ||
,(Volleyball_Games.TotalPointsMaccabi-Volleyball_Games.TotalPointsOpponent) | ,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=שופט | ||
| שורה 107: | שורה 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}}}" }} | ||
גרסה אחרונה מ־02:23, 1 בדצמבר 2025
ערכו את הדף כדי לצפות בטקסט התבנית.