תבנית:SearchVolleyballGames: הבדלים בין גרסאות בדף
מתוך מכביפדיה
(Support search with fans video)
אין תקציר עריכה
שורה 80: שורה 80:
|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 = "{{{Opponent|}}}" }}
{{#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=Volleyball_Games.ResultOpt=תוצאה,
COUNT(*)
|limit=5000
|format=dynamic table
|rows per page=100
|group by=Volleyball_Games.ResultOpt
}}<!--
}}<!--


גרסה מ־00:08, 18 בפברואר 2024

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

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