שלושערים - היסטוריית גרסאות

Kosh ב־22:24, 1 בינואר 2023

2023-01-01T22:24:15Z

→ הגרסה הקודמת		גרסה מ־01:24, 2 בינואר 2023
שורה 1:		שורה 1:

	{{#cargo_query:		{{#cargo_query:
	tables=Football_Games, Games_Events		tables=Football_Games, Games_Events, Competitions
	\|join on=Football_Games._pageID = Games_Events._PageID		\|join on=Football_Games._pageID = Games_Events._PageID,
			Football_Games.Competition = Competitions.OriginalName
	\|where=1=1		\|where=1=1
	AND Team=1		AND Team=1
	AND EventType=3		AND EventType=3
	AND SubType !=33 <!-- Without own goal -->		AND SubType !=33 <!-- Without own goal -->
	AND ~~Football_Games~~.~~Competition NOT IN (19, 21) <!-- Only official games -->~~		AND Competitions.Official=1

	\|group by=Games_Events.PlayerName, Games_Events._pageName, Games_Events.Date		\|group by=Games_Events.PlayerName, Games_Events._pageName, Games_Events.Date

2022-09-01T20:01:32Z

החלפת טקסט – "Games_Catalog" ב־"Football_Games"

→ הגרסה הקודמת		גרסה מ־23:01, 1 בספטמבר 2022
שורה 1:		שורה 1:

	{{#cargo_query:		{{#cargo_query:
	tables=~~Games_Catalog~~, Games_Events		tables=Football_Games, Games_Events
	\|join on=~~Games_Catalog~~._pageID = Games_Events._PageID		\|join on=Football_Games._pageID = Games_Events._PageID
	\|where=1=1		\|where=1=1
	AND Team=1		AND Team=1
	AND EventType=3		AND EventType=3
	AND SubType !=33 <!-- Without own goal -->		AND SubType !=33 <!-- Without own goal -->
	AND ~~Games_Catalog~~.Competition NOT IN (19, 21) <!-- Only official games -->		AND Football_Games.Competition NOT IN (19, 21) <!-- Only official games -->

	\|group by=Games_Events.PlayerName, Games_Events._pageName, Games_Events.Date		\|group by=Games_Events.PlayerName, Games_Events._pageName, Games_Events.Date

2021-11-22T00:38:46Z

→ הגרסה הקודמת		גרסה מ־03:38, 22 בנובמבר 2021
שורה 9:		שורה 9:
	AND Games_Catalog.Competition NOT IN (19, 21) <!-- Only official games -->		AND Games_Catalog.Competition NOT IN (19, 21) <!-- Only official games -->

	\|group by=Games_Events.PlayerName, Games_Events._pageName, Games_Events.Date ~~<!-- group by date also so we can show and order by it at fields section -->~~		\|group by=Games_Events.PlayerName, Games_Events._pageName, Games_Events.Date
	\|having=COUNT(*)>2		\|having=COUNT(*)>2
	\|fields=Games_Events._pageName=עמוד המשחק,		\|fields=Games_Events._pageName=עמוד המשחק,

2021-11-22T00:31:58Z

→ הגרסה הקודמת		גרסה מ־03:31, 22 בנובמבר 2021
שורה 12:		שורה 12:
	\|having=COUNT(*)>2		\|having=COUNT(*)>2
	\|fields=Games_Events._pageName=עמוד המשחק,		\|fields=Games_Events._pageName=עמוד המשחק,
			Games_Events.Date=תאריך,
	Games_Events.PlayerName=שחקן,		Games_Events.PlayerName=שחקן,
	Count(*)=שערים		Count(*)=שערים

2021-08-17T21:46:17Z

→ הגרסה הקודמת		גרסה מ־00:46, 18 באוגוסט 2021
שורה 4:		שורה 4:
	\|join on=Games_Catalog._pageID = Games_Events._PageID		\|join on=Games_Catalog._pageID = Games_Events._PageID
	\|where=1=1		\|where=1=1
	~~{{#if: {{{תאריך\|}}}\| AND DATE_FORMAT({{{תאריך}}}, {{{פורמט תאריך\|"%d %m %y"}}}) = DATE_FORMAT(Date, {{{פורמט תאריך\|"%d %m %y"}}}) }}~~
	AND Team=1		AND Team=1
	AND EventType=3		AND EventType=3

2021-08-02T19:25:00Z

→ הגרסה הקודמת		גרסה מ־22:25, 2 באוגוסט 2021
שורה 1:		שורה 1:

	{{#cargo_query:		{{#cargo_query:
	tables=Games_Events		tables=Games_Catalog, Games_Events
			\|join on=Games_Catalog._pageID = Games_Events._PageID
	\|where=1=1		\|where=1=1
	{{#if: {{{תאריך\|}}}\| AND DATE_FORMAT({{{תאריך}}}, {{{פורמט תאריך\|"%d %m %y"}}}) = DATE_FORMAT(Date, {{{פורמט תאריך\|"%d %m %y"}}}) }}		{{#if: {{{תאריך\|}}}\| AND DATE_FORMAT({{{תאריך}}}, {{{פורמט תאריך\|"%d %m %y"}}}) = DATE_FORMAT(Date, {{{פורמט תאריך\|"%d %m %y"}}}) }}
שורה 7:		שורה 8:
	AND EventType=3		AND EventType=3
	AND SubType !=33 <!-- Without own goal -->		AND SubType !=33 <!-- Without own goal -->
	\|group by=PlayerName, _pageName, Date <!-- group by date also so we can show and order by it at fields section -->		AND Games_Catalog.Competition NOT IN (19, 21) <!-- Only official games -->

			\|group by=Games_Events.PlayerName, Games_Events._pageName, Games_Events.Date <!-- group by date also so we can show and order by it at fields section -->
	\|having=COUNT(*)>2		\|having=COUNT(*)>2
	\|fields=_pageName=עמוד המשחק,		\|fields=Games_Events._pageName=עמוד המשחק,
	PlayerName=שחקן,		Games_Events.PlayerName=שחקן,
	Count(*)=שערים		Count(*)=שערים
	\|order by=Date DESC		\|order by=Games_Events.Date DESC
	\|format=table		\|format=table
	\|limit=200		\|limit=200
	}}		}}

2021-08-02T19:22:21Z

2019-09-06T23:28:13Z

→ הגרסה הקודמת		גרסה מ־02:28, 7 בספטמבר 2019
שורה 9:		שורה 9:
	\|group by=PlayerName, _pageName, Date <!-- group by date also so we can show and order by it at fields section -->		\|group by=PlayerName, _pageName, Date <!-- group by date also so we can show and order by it at fields section -->
	\|having=COUNT(*)>2		\|having=COUNT(*)>2
	\|fields=_pageName, PlayerName, Count(*)		\|fields=_pageName=עמוד המשחק,
			PlayerName=שחקן,
			Count(*)=שערים
	\|order by=Date DESC		\|order by=Date DESC
	\|format=table		\|format=table
	\|limit=200		\|limit=200
	}}		}}

2019-09-06T23:27:40Z

→ הגרסה הקודמת		גרסה מ־02:27, 7 בספטמבר 2019
שורה 9:		שורה 9:
	\|group by=PlayerName, _pageName, Date <!-- group by date also so we can show and order by it at fields section -->		\|group by=PlayerName, _pageName, Date <!-- group by date also so we can show and order by it at fields section -->
	\|having=COUNT(*)>2		\|having=COUNT(*)>2
	\|fields=~~CONCAT("[[",~~ _pageName~~, "\|"~~, PlayerName, ~~"]]"~~)		\|fields=_pageName, PlayerName, Count(*)
	\|order by=Date DESC		\|order by=Date DESC
	\|format=table		\|format=table
	\|limit=200		\|limit=200
	}}		}}

2019-09-06T23:25:57Z

→ הגרסה הקודמת		גרסה מ־02:25, 7 בספטמבר 2019
שורה 9:		שורה 9:
	\|group by=PlayerName, _pageName, Date <!-- group by date also so we can show and order by it at fields section -->		\|group by=PlayerName, _pageName, Date <!-- group by date also so we can show and order by it at fields section -->
	\|having=COUNT(*)>2		\|having=COUNT(*)>2
	\|fields=CONCAT('[[', _pageName, "\|", PlayerName, "]]")		\|fields=CONCAT("[[", _pageName, "\|", PlayerName, "]]")
	\|order by=Date DESC		\|order by=Date DESC
	\|format=table		\|format=table
	\|limit=200		\|limit=200
	}}		}}