תבנית:יום/מאזן: הבדלים בין גרסאות בדף

(גרסת ביניים אחת של אותו משתמש אינה מוצגת)

שורה 6:

הגדרת מאזנים לתצוגה

-->{{#vardefine:מספר משחקים|{{#cargo_query:

table=~~Games_Catalog~~

table=Football_Games, Competitions

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m") AND ~~Competition NOT IN (19, 21)~~

|join on=Football_Games.Competition = Competitions.OriginalName

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m")

AND Competitions.Official=1

|fields=COUNT(*)

|no html

שורה 13:

שורה 15:

}}<!--

-->{{#vardefine:מספר נצחונות|{{#cargo_query:

table=~~Games_Catalog~~

table=Football_Games, Competitions

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m") AND ~~Competition NOT IN (19, 21)~~ AND ResultOpt="1"

|join on=Football_Games.Competition = Competitions.OriginalName

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m")

AND Competitions.Official=1

AND ResultOpt="1"

|fields=COUNT(*)

|no html

שורה 20:

שורה 25:

}}<!--

-->{{#vardefine:מספר תיקו|{{#cargo_query:

table=~~Games_Catalog~~

table=Football_Games, Competitions

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m") AND ~~Competition NOT IN (19, 21)~~ AND ResultOpt="2"

|join on=Football_Games.Competition = Competitions.OriginalName

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m")

AND Competitions.Official=1

AND ResultOpt="2"

|fields=COUNT(*)

|no html

שורה 27:

שורה 35:

}}<!--

-->{{#vardefine:מספר הפסדים|{{#cargo_query:

table=~~Games_Catalog~~

table=Football_Games, Competitions

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m") AND ~~Competition NOT IN (19, 21)~~ AND ResultOpt="3"

|join on=Football_Games.Competition = Competitions.OriginalName

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m")

AND Competitions.Official=1

AND ResultOpt="3"

|fields=COUNT(*)

|no html

שורה 36:

שורה 47:

הגדרת סטטיסטיקה

-->{{#vardefine:מספר כיבושים|{{#number_format:{{#cargo_query:

table=~~Games_Catalog~~

table=Football_Games, Competitions

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m") AND ~~Competition NOT IN (19, 21)~~

|join on=Football_Games.Competition = Competitions.OriginalName

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m")

AND Competitions.Official=1

|fields=SUM(ResultMaccabi)

|no html

שורה 43:

שורה 56:

}}<!--

-->{{#vardefine:מספר ספיגות|{{#number_format:{{#cargo_query:

table=~~Games_Catalog~~

table=Football_Games, Competitions

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m") AND ~~Competition NOT IN (19, 21)~~

|join on=Football_Games.Competition = Competitions.OriginalName

|where=DATE_FORMAT( {{#var:תאריך}} , "%d %m") = DATE_FORMAT(Date, "%d %m")

AND Competitions.Official=1

|fields=SUM(ResultOpponent)

|no html

גרסה אחרונה מ־01:27, 2 בינואר 2023