תבנית:SearchVolleyballGames: הבדלים בין גרסאות בדף
מתוך מכביפדיה
אין תקציר עריכה
(Search by canonical opponent (so every related opponent will appear in same search))
 
(38 גרסאות ביניים של אותו משתמש אינן מוצגות)
שורה 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




שורה 17: שורה 21:
|where=1=1
|where=1=1


{{#if: {{{SpecificCompetition|}}} |  AND Volleyball_Games.Stadium = "{{{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}}}" }}
שורה 26: שורה 36:
{{#if: {{{Leg|}}} | {{#ifeq: {{{SimilarLegs|}}}| כן| AND Volleyball_Games.Leg LIKE "%{{{Leg}}}%" | AND Volleyball_Games.Leg = "{{{Leg}}}" }} }}
{{#if: {{{Leg|}}} | {{#ifeq: {{{SimilarLegs|}}}| כן| AND Volleyball_Games.Leg LIKE "%{{{Leg}}}%" | AND Volleyball_Games.Leg = "{{{Leg}}}" }} }}
{{#if: {{{Referee|}}} |  AND Volleyball_Games.Refs = "{{{Referee}}}" }}
{{#if: {{{Referee|}}} |  AND Volleyball_Games.Refs = "{{{Referee}}}" }}
{{#if: {{{MaccabiSets|}}} |  AND Volleyball_Games.ResultMaccabi {{#var: SetsForMaccabiOperator}} {{{MaccabiSets}}} }}
{{#if: {{{MaccabiSets|}}} |  AND Volleyball_Games.TotalSetsMaccabi{{#var: SetsForMaccabiOperator}} {{{MaccabiSets}}} }}
{{#if: {{{MaccabiSetsDifferent|}}} |  AND Volleyball_Games.ResultMaccabi - Volleyball_Games.ResultOpponent {{#var: SetsDiffForMaccabiOperator}} {{{MaccabiSetsDifferent}}} }}
{{#if: {{{MaccabiSetsDifferent|}}} |  AND Volleyball_Games.TotalSetsMaccabi- Volleyball_Games.TotalSetsOpponent {{#var: SetsDiffForMaccabiOperator}} {{{MaccabiSetsDifferent}}} }}
{{#if: {{{OpponentSets|}}} |  AND Volleyball_Games.ResultOpponent {{#var: SetsForOpponentOperator}} {{{OpponentSets}}} }}
{{#if: {{{MaccabiPointsDifferent|}}} |  AND Volleyball_Games.TotalPointsMaccabi- Volleyball_Games.TotalPointsOpponent {{#var: PointsDiffForMaccabiOperator}} {{{MaccabiPointsDifferent}}} }}
{{#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: {{{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"}}
 


<!--
<!--
שורה 44: שורה 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=שלב במפעל
שורה 53: שורה 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=קהל
שורה 66: שורה 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

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

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