(Support search with fans video) |
(Search by canonical opponent (so every related opponent will appear in same search)) |
||
| (22 גרסאות ביניים של אותו משתמש אינן מוצגות) | |||
| שורה 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=שופט | ||
| שורה 80: | שורה 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
ערכו את הדף כדי לצפות בטקסט התבנית.