|
|
| (279 גרסאות ביניים של 3 משתמשים אינן מוצגות) |
| שורה 1: |
שורה 1: |
| <!--
| | {{מפעל כדורעף |
| Define local parameters:
| | |שם מפעל=ליגת העל |
| -->{{#vardefine: SameCompetitions|{{המרות/המרות מפעל/מפעל לרשימת מפעלים מקושרים| מפעל={{{Competition|}}} }} }}<!--
| | |שמות נוספים=הליגה הארצית^1956^1959, הליגה הלאומית^1960^1999 |
| -->{{#vardefine: SameStadiums|{{המרות/המרות אצטדיון/אצטדיון לרשימת אצטדיונים מקושרים| אצטדיון={{{Stadium|}}} }} }}<!--
| | |עמוד מפעל מרכז=כדורעף: הליגה הראשונה בכדורעף |
| -->{{#vardefine: SameOpponents|{{המרות/המרות יריבה/יריבה לרשימת יריבות מקושרות| יריבה=אל שורטה }} }}<!--
| | |שם מפעל מרכז=הליגה הראשונה בכדורעף |
| -->{{#vardefine: GoalsForMaccabiOperator| {{#בחר:{{{MaccabiGoalsAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!--
| | |שנת תחילת שם נוכחי=2000 |
| -->{{#vardefine: GoalsForOpponentOperator| {{#בחר:{{{OpponentGoalsAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!--
| | |שנת הקמה=1956 |
| -->{{#vardefine: GoalsDiffForMaccabiOperator| {{#בחר:{{{MaccabiGoalsDifferentAction|}}}|מתחת ל=<|בדיוק==|מעל ל=> }} }}<!--
| | |מספר משתתפות=10 |
| -->{{#vardefine: PlayerEvent|{{המרות/תיאור אירוע לשליפת משחקים למספר אירוע| אירוע={{{PlayerAction|}}} }} }}<!--
| | |ארגון=איגוד הכדורעף בישראל |
| -->{{#vardefine: PlayerSubEvent|{{תבנית: המרות/תיאור תת אירוע למספר תת אירוע| תת אירוע={{{PlayerSubAction|}}} }} }}<!--
| | |פתיח=[[כדורעף: הליגה הראשונה בכדורעף|הליגה הראשונה בכדורעף]] נקראית "ליגת העל" החל משנת [[2000]], וזאת לאחר שנקראה בעבר "הליגה הארצית" ו"[[כדורעף: הליגה הלאומית|הליגה הלאומית]]". הליגה משוחקת לרוב בשני סיבובים (בית-חוץ), ולאחר מכן מתקיים שלב הפלייאוף. |
| -->{{#vardefine: PlayerEvent2|{{המרות/תיאור אירוע לשליפת משחקים למספר אירוע| אירוע={{{PlayerAction2|}}} }} }}<!--
| |
| -->{{#vardefine: PlayerSubEvent2|{{תבנית: המרות/תיאור תת אירוע למספר תת אירוע| תת אירוע={{{PlayerSubAction2|}}} }} }}<!--
| |
| | |
| | |
| We use the hacky way of concating all player related params in order to "turn on" the check for Team=1,
| |
| There are some games without any maccabi players, we dont want to avoid querying them if we can avoid it (means we search for the game data and not players data).
| |
| -->{{#cargo_query:
| |
| tables=Games_Catalog, Competitions_Catalog, Games_Results, Games_Events, Games_Events=Events2, Days_In_Week, Games_Videos, Football_Games_Uniforms, Opponents, Profiles, Players_Positions
| |
| |join on=Games_Catalog.Competition = Competitions_Catalog.CompID | |
| ,Games_Catalog.ResultOpt = Games_Results.ResultType
| |
| ,Games_Catalog._pageID = Games_Events._pageID
| |
| ,Games_Catalog.MatchDay = Days_In_Week.DayNumber
| |
| ,Games_Catalog._pageID = Games_Videos._pageID
| |
| ,Games_Events._pageID = Events2._pageID
| |
| ,Games_Catalog._pageID = Football_Games_Uniforms._pageID
| |
| ,Games_Catalog.Opponent = Opponents.OriginalName
| |
| ,Games_Events.PlayerName = Profiles._pageName
| |
| ,Profiles.Position HOLDS Players_Positions.PositionType
| |
| |where=1=1
| |
| | |
| | |
| {{#if: {{{Competition|}}} | AND Games_Catalog.Competition IN ({{#var: SameCompetitions}}) }}<!-- the "()" around the SameCompetition required for "IN" operator -->
| |
| {{#if: {{{Stadium|}}} | AND Games_Catalog.Stadium IN ({{#var: SameStadiums}}) }}<!-- the "()" around the SameStadiums required for "IN" operator -->
| |
| {{#if: {{{Opponent|}}} | AND Games_Catalog.Opponent IN ({{#var: SameOpponents}}) }}<!-- the "()" around the SameOpponents required for "IN" operator -->
| |
| {{#if: {{{OpponentCountry|}}} | AND Opponents.Country ="{{{OpponentCountry}}}" }}
| |
| {{#if: {{{Coach|}}} | AND Games_Catalog.CoachMaccabi="{{{Coach}}}" }}
| |
| {{#if: {{{CoachOpponent|}}} | AND Games_Catalog.CoachOpponent="{{{CoachOpponent}}}" }}
| |
| {{#if: {{{Season|}}} | AND Games_Catalog.Season = "{{{Season}}}" }}
| |
| {{#if: {{{HomeAway|}}} | AND Games_Catalog.HomeAway = "{{{HomeAway}}}" }}
| |
| {{#if: {{{Leg|}}} | {{#ifeq: {{{SimilarLegs|}}}| כן| AND Games_Catalog.Leg LIKE "{{{Leg}}}%" | AND Games_Catalog.Leg = "{{{Leg}}}" }} }}
| |
| {{#if: {{{Referee|}}} | AND Games_Catalog.Refs = "{{{Referee}}}" }}
| |
| {{#if: {{{MaccabiGoals|}}} | AND Games_Catalog.ResultMaccabi {{#var: GoalsForMaccabiOperator}} {{{MaccabiGoals}}} }}
| |
| {{#if: {{{MaccabiGoalsDifferent|}}} | AND Games_Catalog.ResultMaccabi - Games_Catalog.ResultOpponent {{#var: GoalsDiffForMaccabiOperator}} {{{MaccabiGoalsDifferent}}} }}
| |
| {{#if: {{{OpponentGoals|}}} | AND Games_Catalog.ResultOpponent {{#var: GoalsForOpponentOperator}} {{{OpponentGoals}}} }}
| |
| {{#if: {{{GameResult|}}} | AND Games_Results.ResultString = "{{{GameResult}}}" }}
| |
| {{#if: {{{Uniforms|}}} | AND Football_Games_Uniforms.KitName = "{{{Uniforms}}}" }}
| |
| | |
| {{#if: {{{GameDayInWeek|}}} | AND DATE_FORMAT(Games_Catalog.Date, '%w') + 1 = {{{GameDayInWeek}}} }}
| |
| {{#if: {{{StartDate|}}} | AND Games_Catalog.Date >= "{{{StartDate}}}" }}
| |
| {{#if: {{{EndDate|}}} | AND Games_Catalog.Date <= "{{{EndDate}}}" }}
| |
| | |
| | |
| {{#if: {{{Player|}}}{{{PlayerNumber|}}}{{{PlayerAction|}}}{{{PlayerActionMinute|}}}{{{PlayerSubAction|}}}{{{PlayerSubActionMinute|}}}{{{PlayerPosition|}}}| And Games_Events.Team = 1}}
| |
| {{#if: {{{Player|}}} | AND Games_Events.PlayerName = "{{{Player}}}" }}
| |
| {{#if: {{{PlayerNumber|}}} | AND Games_Events.PlayerNumber = {{{PlayerNumber}}} }}
| |
| {{#if: {{{PlayerAction|}}} | AND Games_Events.EventType IN ({{#var: PlayerEvent}}) }}
| |
| {{#if: {{{PlayerActionMinute|}}} | AND Games_Events.Minute = {{{PlayerActionMinute}}} }}
| |
| {{#if: {{{PlayerSubAction|}}} | AND Games_Events.SubType IN ({{#var: PlayerSubEvent}}) }}
| |
| {{#if: {{{PlayerSubActionMinute|}}} | AND Games_Events.Minute = {{{PlayerSubActionMinute}}} }}
| |
| {{#if: {{{PlayerPosition|}}} | AND Players_Positions.PositionString= "{{{PlayerPosition}}}" }}
| |
| | |
| | |
| {{#if: {{{Player2|}}}{{{PlayerNumber2|}}}{{{PlayerAction2|}}}{{{PlayerActionMinute2|}}}{{{PlayerSubAction2|}}}{{{PlayerSubActionMinute2|}}}{{{PlayerPosition2|}}}| And Events2.Team = 1}}
| |
| {{#if: {{{Player2|}}} | AND Events2.PlayerName = "{{{Player2}}}" }}
| |
| {{#if: {{{PlayerNumber2|}}} | AND Events2.PlayerNumber = {{{PlayerNumber2}}} }}
| |
| {{#if: {{{PlayerAction2|}}} | AND Events2.EventType IN ({{#var: PlayerEvent2}}) }}
| |
| {{#if: {{{PlayerActionMinute2|}}} | AND Events2.Minute = {{{PlayerActionMinute2}}} }}
| |
| {{#if: {{{PlayerSubAction2|}}} | AND Events2.SubType IN ({{#var: PlayerSubEvent2}}) }}
| |
| {{#if: {{{PlayerSubActionMinute2|}}} | AND Events2.Minute = {{{PlayerSubActionMinute2}}} }}
| |
| {{#if: {{{PlayerPosition2|}}} | AND Players_Positions.PositionString = "{{{PlayerPosition2}}}" }}
| |
| | |
| {{#ifeq: {{{PlayersEventsInSameMinute|}}}| כן| AND Events2.Minute = Games_Events.Minute }}
| |
| | |
| | |
| {{#ifeq: {{{FullGame|}}}| רק משחקים עם משחק מלא| AND Games_Videos.FullGame IS NOT NULL}}
| |
| {{#ifeq: {{{Highlights|}}}| רק משחקים עם תקציר| AND Games_Videos.Highlights IS NOT NULL}}
| |
| | |
| {{#ifeq: {{{OfficialGames|}}}| רק משחקים רשמיים| AND Games_Catalog.Competition NOT IN (19, 21)}}
| |
| {{#ifeq: {{{OfficialGames|}}}| רק משחקים לא רשמיים| AND Games_Catalog.Competition IN (19, 21)}}
| |
| | |
| {{#ifeq: {{{UniformsTag|}}}| משחקים עם תיוג מדים| AND Football_Games_Uniforms.KitName IS NOT NULL}}
| |
| {{#ifeq: {{{UniformsTag|}}}| משחקים ללא תיוג מדים| AND Football_Games_Uniforms.KitName IS NULL}}
| |
| <!--
| |
| | |
| Fields to display:
| |
| -->|fields=CONCAT('[[', Games_Catalog._pageName, '|המשחק]]')=המשחק
| |
| ,Games_Catalog.Date=תאריך
| |
| ,CONCAT('[[עונת ', Games_Catalog.Season, ']]')=עונה
| |
| ,CONCAT('[[', Competitions_Catalog.Name, ']]')=מפעל <!-- Cast number to name from Competitions Table -->
| |
| ,Games_Catalog.Leg=שלב במפעל
| |
| ,CONCAT('[[', Games_Catalog.Opponent, ']]')=יריבה
| |
| ,Games_Catalog.HomeAway=בית או חוץ
| |
| ,CONCAT('[[', Games_Catalog.Stadium, ']]')=אצטדיון
| |
| ,Games_Catalog.ResultMaccabi=תוצאה למכבי
| |
| ,Games_Catalog.ResultOpponent=תוצאה ליריבה
| |
| ,Games_Results.ResultString=תוצאת משחק <!-- Cast number to string from games results table -->
| |
| ,CONCAT('[[', Games_Catalog.CoachMaccabi, ']]')=מאמן מכבי
| |
| ,Games_Catalog.CoachOpponent=מאמן יריבה
| |
| ,CONCAT('[[שופט:', Games_Catalog.Refs, '|', Games_Catalog.Refs, ']]')=שופט
| |
| ,Crowd=קהל
| |
| ,Days_In_Week.DayString=יום המשחק בשבוע
| |
| ,CONCAT('[', Games_Videos.FullGame, ' לינק]')=משחק מלא
| |
| ,CONCAT('[', Games_Videos.Highlights, ' לינק]')=תקציר
| |
| ,CONCAT('[[', 'מדי עונת ', Football_Games_Uniforms.Season, '|', Football_Games_Uniforms.KitName, ']]' )=מדים,
| |
| | |
| |limit=5000
| |
| |format=dynamic table
| |
| |rows per page=100
| |
| |group by=Games_Catalog._pageName, Games_Catalog.Date <!-- all fields from "fields=" should be here -->
| |
| |order by=Games_Catalog.Date DESC
| |
| }} | | }} |
.jpg)
זכיה