תבנית:SearchVolleyballGames: הבדלים בין גרסאות בדף
אין תקציר עריכה
(Search by canonical opponent (so every related opponent will appear in same search))
 
(33 גרסאות ביניים של אותו משתמש אינן מוצגות)
שורה 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
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
         ,Volleyball_Games.MatchDay = Days_In_Week.DayNumber
         ,Volleyball_Games.MatchDay = Days_In_Week.DayNumber
        ,Volleyball_Games.Competition = Volleyball_Competitions.OriginalName




שורה 18: שורה 22:


{{#if: {{{SpecificCompetition|}}} |  AND Volleyball_Games.Competition= "{{{SpecificCompetition|}}}" }}
{{#if: {{{SpecificCompetition|}}} |  AND Volleyball_Games.Competition= "{{{SpecificCompetition|}}}" }}
{{#ifeq: {{{CompetitionCategory|}}} | ליגה| AND Volleyball_Competitions.League=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | גביע| AND Volleyball_Competitions.Trophy=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | בינלאומי| AND Volleyball_Competitions.International=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | רשמי| AND Volleyball_Competitions.Official=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | לא רשמי| AND Volleyball_Competitions.Official=0 }}
{{#if: {{{Stadium|}}} |  AND Volleyball_Games.Stadium = "{{{Stadium|}}}" }}
{{#if: {{{Stadium|}}} |  AND Volleyball_Games.Stadium = "{{{Stadium|}}}" }}
{{#if: {{{Opponent|}}} |  AND Volleyball_Games.Opponent = "{{{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}}}" }}
שורה 28: שורה 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}}}" }}
שורה 36: שורה 47:




{{#ifeq: {{{FullGame|}}}| רק משחקים עם משחק מלא| AND Volleyball_Games.FullGameVideo IS NOT NULL}}
{{#ifeq: {{{OnlyGamesWithGoldenSet|}}}| כן| AND Volleyball_Games.GoldenSetPointsMaccabi != ""}}
{{#ifeq: {{{Highlights|}}}| רק משחקים עם תקציר| AND Volleyball_Games.HighlightsVideo IS NOT NULL}}
 
{{#ifeq: {{{Article|}}}| רק משחקים עם כתבה| AND Volleyball_Games.HasArticle = "1"}}
{{#ifeq: {{{OnlyGamesWithHighlight|}}}| כן| AND Volleyball_Games.HighlightsVideo IS NOT NULL}}
{{#ifeq: {{{OnlyGamesWithFullgame|}}}| כן| AND Volleyball_Games.FullGameVideo IS NOT NULL}}
{{#ifeq: {{{OnlyGamesWithFansVideo|}}}| כן| AND Volleyball_Games.FansVideo IS NOT NULL}}
{{#ifeq: {{{OnlyGamesWithArticle|}}}| כן| AND Volleyball_Games.HasArticle = "1"}}
 


<!--
<!--
שורה 45: שורה 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=שלב במפעל
שורה 54: שורה 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=נק למכבי
          ,IF(Volleyball_Games.TotalPointsMaccabi>Volleyball_Games.TotalPointsOpponent, Volleyball_Games.TotalPointsMaccabi-Volleyball_Games.TotalPointsOpponent, Volleyball_Games.TotalPointsMaccabi-Volleyball_Games.TotalPointsOpponent)=הפרש נק למכבי
          ,Volleyball_Games.TotalPointsOpponent=נק ליריבה
           ,Volleyball_Games.Refs=שופט
           ,Volleyball_Games.Refs=שופט
           ,Crowd=קהל
           ,Crowd=קהל
שורה 67: שורה 85:
|group by=Volleyball_Games._pageName, Volleyball_Games.Date <!-- all fields from "fields=" should be here -->
|group by=Volleyball_Games._pageName, Volleyball_Games.Date <!-- all fields from "fields=" should be here -->
|order by=Volleyball_Games.Date DESC
|order by=Volleyball_Games.Date DESC
}}<!--
Show distribution of the game result
-->
== התפלגות תוצאות משחקים ==
{{#cargo_query:
tables=Volleyball_Games, Games_Results, Days_In_Week, Volleyball_Competitions
|join on=Volleyball_Games.ResultOpt = Games_Results.ResultType
        ,Volleyball_Games.MatchDay = Days_In_Week.DayNumber
        ,Volleyball_Games.Competition = Volleyball_Competitions.OriginalName
|where=1=1
{{#if: {{{SpecificCompetition|}}} |  AND Volleyball_Games.Competition= "{{{SpecificCompetition|}}}" }}
{{#ifeq: {{{CompetitionCategory|}}} | ליגה| AND Volleyball_Competitions.League=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | גביע| AND Volleyball_Competitions.Trophy=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | בינלאומי| AND Volleyball_Competitions.International=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | רשמי| AND Volleyball_Competitions.Official=1 }}
{{#ifeq: {{{CompetitionCategory|}}} | לא רשמי| AND Volleyball_Competitions.Official=0 }}
{{#if: {{{Stadium|}}} |  AND Volleyball_Games.Stadium = "{{{Stadium|}}}" }}
{{#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: {{{CoachOpponent|}}} |  AND Volleyball_Games.CoachOpponent="{{{CoachOpponent}}}" }}
{{#if: {{{Season|}}} |  AND Volleyball_Games.Season = "{{{Season}}}" }}
{{#if: {{{HomeAway|}}} |  AND Volleyball_Games.HomeAway = "{{{HomeAway}}}" }}
{{#if: {{{Leg|}}} | {{#ifeq: {{{SimilarLegs|}}}| כן| AND Volleyball_Games.Leg LIKE "%{{{Leg}}}%" | AND Volleyball_Games.Leg = "{{{Leg}}}" }} }}
{{#if: {{{Referee|}}} |  AND Volleyball_Games.Refs = "{{{Referee}}}" }}
{{#if: {{{MaccabiSets|}}} |  AND Volleyball_Games.TotalSetsMaccabi{{#var: SetsForMaccabiOperator}} {{{MaccabiSets}}} }}
{{#if: {{{MaccabiSetsDifferent|}}} |  AND Volleyball_Games.TotalSetsMaccabi- Volleyball_Games.TotalSetsOpponent {{#var: SetsDiffForMaccabiOperator}} {{{MaccabiSetsDifferent}}} }}
{{#if: {{{OpponentSets|}}} |  AND Volleyball_Games.TotalSetsOpponent {{#var: SetsForOpponentOperator}} {{{OpponentSets}}} }}
{{#if: {{{GameResult|}}} |  AND Games_Results.ResultString = "{{{GameResult}}}" }}
{{#if: {{{GameDayInWeek|}}} | AND DATE_FORMAT(Volleyball_Games.Date, '%w') + 1 = {{{GameDayInWeek}}} }}
{{#if: {{{StartDate|}}} | AND Volleyball_Games.Date >= "{{{StartDate}}}" }}
{{#if: {{{EndDate|}}} | AND  Volleyball_Games.Date <= "{{{EndDate}}}" }}
{{#ifeq: {{{OnlyGamesWithGoldenSet|}}}| כן| AND Volleyball_Games.GoldenSetPointsMaccabi != ""}}
{{#ifeq: {{{OnlyGamesWithHighlight|}}}| כן| AND Volleyball_Games.HighlightsVideo IS NOT NULL}}
{{#ifeq: {{{OnlyGamesWithFullgame|}}}| כן| AND Volleyball_Games.FullGameVideo IS NOT NULL}}
{{#ifeq: {{{OnlyGamesWithFansVideo|}}}| כן| AND Volleyball_Games.FansVideo IS NOT NULL}}
{{#ifeq: {{{OnlyGamesWithArticle|}}}| כן| AND Volleyball_Games.HasArticle = "1"}}
<!--
Fields to display:
-->|fields=Games_Results.ResultString=תוצאה,
COUNT(*)=כמות משחקים
|format=ol
|group by=Games_Results.ResultString
|order by=COUNT(*) DESC
}}<!--
}}<!--


גרסה אחרונה מ־02:23, 1 בדצמבר 2025

לינק לעמוד לחיפוש משחקים

ערכו את הדף כדי לצפות בטקסט התבנית.

אוחזר מתוך "http://www.maccabipedia.co.il/index.php?title=תבנית:SearchVolleyballGames&oldid=179438"