שחקנים שהיו מעורבים בשלושה שערים ומעלה במשחק - היסטוריית גרסאות

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

2023-01-01T22:23:13Z

→ הגרסה הקודמת		גרסה מ־01:23, 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 IN (3, 4)		AND EventType IN (3, 4)
	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

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

2022-09-01T20:02:50Z

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

→ הגרסה הקודמת		גרסה מ־23:02, 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 IN (3, 4)		AND EventType IN (3, 4)
	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
	\|having=COUNT(*)>2		\|having=COUNT(*)>2
	\|fields=~~Games_Catalog~~._pageName=עמוד המשחק,		\|fields=Football_Games._pageName=עמוד המשחק,
	~~Games_Catalog~~.Date=תאריך,		Football_Games.Date=תאריך,
	CONCAT( '[[', Games_Events.PlayerName, ']]' )=שחקן,		CONCAT( '[[', Games_Events.PlayerName, ']]' )=שחקן,
	COUNT(*)=כמות שערים שהיה מעורב		COUNT(*)=כמות שערים שהיה מעורב
	\|order by=~~Games_Catalog~~.Date DESC		\|order by=Football_Games.Date DESC
	\|format=table		\|format=table
	\|limit=200		\|limit=200
	}}		}}

Kosh: יצירת דף עם התוכן "{{#cargo_query: tables=Games_Catalog, Games_Events |join on=Games_Catalog._pageID = Games_Events._PageID |where=1=1 AND Team=1 AND EventType IN (3, 4) AND SubTyp..."

2021-11-22T00:38:57Z

יצירת דף עם התוכן "{{#cargo_query: tables=Games_Catalog, Games_Events |join on=Games_Catalog._pageID = Games_Events._PageID |where=1=1 AND Team=1 AND EventType IN (3, 4) AND SubTyp..."

דף חדש

{{#cargo_query:
tables=Games_Catalog, Games_Events
|join on=Games_Catalog._pageID = Games_Events._PageID
|where=1=1
AND Team=1
AND EventType IN (3, 4)
AND SubType !=33 
AND Games_Catalog.Competition NOT IN (19, 21) 

|group by=Games_Events.PlayerName, Games_Events._pageName, Games_Events.Date
|having=COUNT(*)>2
|fields=Games_Catalog._pageName=עמוד המשחק,
Games_Catalog.Date=תאריך,
CONCAT( '[[', Games_Events.PlayerName, ']]' )=שחקן,
COUNT(*)=כמות שערים שהיה מעורב
|order by=Games_Catalog.Date DESC
|format=table
|limit=200
}}