אין תקציר עריכה |
(Use %Y instead of %y (take 4 digit of the year instead of 2)) |
||
| שורה 8: | שורה 8: | ||
tables=Football_Games, Competitions | tables=Football_Games, Competitions | ||
|join on=Football_Games.Competition = Competitions.OriginalName | |join on=Football_Games.Competition = Competitions.OriginalName | ||
|where=DATE_FORMAT( {{#var:תאריך}} , "% | |where=DATE_FORMAT( {{#var:תאריך}} , "%Y") = DATE_FORMAT(Date, "%Y") | ||
AND Competitions.Official = 1 | AND Competitions.Official = 1 | ||
|fields=COUNT(*) | |fields=COUNT(*) | ||
| שורה 17: | שורה 17: | ||
tables=Football_Games, Competitions | tables=Football_Games, Competitions | ||
|join on=Football_Games.Competition = Competitions.OriginalName | |join on=Football_Games.Competition = Competitions.OriginalName | ||
|where=DATE_FORMAT( {{#var:תאריך}} , "% | |where=DATE_FORMAT( {{#var:תאריך}} , "%Y") = DATE_FORMAT(Date, "%Y") | ||
AND Competitions.Official = 1 | AND Competitions.Official = 1 | ||
AND ResultOpt="1" | AND ResultOpt="1" | ||
| שורה 27: | שורה 27: | ||
tables=Football_Games, Competitions | tables=Football_Games, Competitions | ||
|join on=Football_Games.Competition = Competitions.OriginalName | |join on=Football_Games.Competition = Competitions.OriginalName | ||
|where=DATE_FORMAT( {{#var:תאריך}} , "% | |where=DATE_FORMAT( {{#var:תאריך}} , "%Y") = DATE_FORMAT(Date, "%Y") | ||
AND Competitions.Official = 1 | AND Competitions.Official = 1 | ||
AND ResultOpt="2" | AND ResultOpt="2" | ||
| שורה 37: | שורה 37: | ||
tables=Football_Games, Competitions | tables=Football_Games, Competitions | ||
|join on=Football_Games.Competition = Competitions.OriginalName | |join on=Football_Games.Competition = Competitions.OriginalName | ||
|where=DATE_FORMAT( {{#var:תאריך}} , "% | |where=DATE_FORMAT( {{#var:תאריך}} , "%Y") = DATE_FORMAT(Date, "%Y") | ||
AND Competitions.Official = 1 | AND Competitions.Official = 1 | ||
AND ResultOpt="3" | AND ResultOpt="3" | ||
| שורה 49: | שורה 49: | ||
tables=Football_Games, Competitions | tables=Football_Games, Competitions | ||
|join on=Football_Games.Competition = Competitions.OriginalName | |join on=Football_Games.Competition = Competitions.OriginalName | ||
|where=DATE_FORMAT( {{#var:תאריך}} , "% | |where=DATE_FORMAT( {{#var:תאריך}} , "%Y") = DATE_FORMAT(Date, "%Y") | ||
AND Competitions.Official = 1 | AND Competitions.Official = 1 | ||
|fields=SUM(ResultMaccabi) | |fields=SUM(ResultMaccabi) | ||
| שורה 58: | שורה 58: | ||
tables=Football_Games, Competitions | tables=Football_Games, Competitions | ||
|join on=Football_Games.Competition = Competitions.OriginalName | |join on=Football_Games.Competition = Competitions.OriginalName | ||
|where=DATE_FORMAT( {{#var:תאריך}} , "% | |where=DATE_FORMAT( {{#var:תאריך}} , "%Y") = DATE_FORMAT(Date, "%Y") | ||
AND Competitions.Official = 1 | AND Competitions.Official = 1 | ||
|fields=SUM(ResultOpponent) | |fields=SUM(ResultOpponent) | ||
גרסה אחרונה מ־19:52, 28 בספטמבר 2024
תבנית זו מציגה מאזן לפי שנה קלנדרית עבור תבנית:שנה