מ (החלפת טקסט – "Games_Catalog" ב־"Football_Games") |
אין תקציר עריכה |
||
| שורה 37: | שורה 37: | ||
|תוכן= | |תוכן= | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Football_Games_Uniforms, Football_Games, | tables=Football_Games_Uniforms, Football_Games, Competition, Football_Uniforms | ||
|join on= Football_Games_Uniforms._pageID = Football_Games._pageID, | |join on= Football_Games_Uniforms._pageID = Football_Games._pageID, | ||
Football_Games.Competition = | Football_Games.Competition = Competitions.OriginalName, | ||
Football_Uniforms.KitName = Football_Games_Uniforms.KitName, | Football_Uniforms.KitName = Football_Games_Uniforms.KitName, | ||
Football_Uniforms.Season = Football_Games_Uniforms.Season | Football_Uniforms.Season = Football_Games_Uniforms.Season | ||
|where=1=1 | |where=1=1 | ||
AND | AND Competition.Official=1 | ||
AND Football_Uniforms.MainKitItem = 1 | AND Football_Uniforms.MainKitItem = 1 | ||
|fields=Football_Games.Date=תאריך, Football_Uniforms.KitType=סוג סט, Football_Games_Uniforms.KitName=שם סט, Football_Games_Uniforms.Season=עונת מדים, | |fields=Football_Games.Date=תאריך, Football_Uniforms.KitType=סוג סט, Football_Games_Uniforms.KitName=שם סט, Football_Games_Uniforms.Season=עונת מדים, Competitions.OriginalName=מפעל, Football_Games.Leg=שלב במפעל, CONCAT('[[', Football_Games_Uniforms._pageName, '| עמוד משחק', ']]')=עמוד משחק | ||
|format=dynamic table | |format=dynamic table | ||
|rows per page=50 | |rows per page=50 | ||
גרסה מ־23:54, 1 בספטמבר 2022
כמה משחקים תוייגו עם מדים במכביפדיה?
תוייגו
1,768 משחקים עם מדים במכביפדיה
עם אילו מדים מכבי שיחקו הכי הרבה?
Error 1054: Unknown column 'MPMW_cargo__Football_Uniforms.MainKitItem' in 'where clause'
Function: CargoSQLQuery::run Query: SELECT CONCAT('100px') AS `מדים`,CONCAT('', `MPMW_cargo__Football_Games_Uniforms`.`KitName`, '' ) AS `שם סט`,`MPMW_cargo__Football_Games_Uniforms`.`Season` AS `עונה`,Count(*) AS `כמות משחקים`,`MPMW_cargo__Football_Games_Uniforms`.`_pageName` AS `משחק לדוגמא` FROM `MPMW_cargo__Football_Games_Uniforms` LEFT OUTER JOIN `MPMW_cargo__Football_Uniforms` ON ((`MPMW_cargo__Football_Games_Uniforms`.`KitName`=`MPMW_cargo__Football_Uniforms`.`KitName`) AND (`MPMW_cargo__Football_Games_Uniforms`.`Season`=`MPMW_cargo__Football_Uniforms`.`Season`)) WHERE 1=1 AND `MPMW_cargo__Football_Games_Uniforms`.`KitName` != "" AND `MPMW_cargo__Football_Uniforms`.`MainKitItem` = 1 GROUP BY `MPMW_cargo__Football_Games_Uniforms`.`KitName`, `MPMW_cargo__Football_Games_Uniforms`.`Season` ORDER BY Count(*) DESC LIMIT 150
עם אילו מדים מכבי שיחקו בכל משחק
Error: table "Competitions" is not in list of table names or aliases.
מדים שניצחנו איתם הכי הרבה