אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 9: | שורה 9: | ||
|join on=Profiles._pageName=Games_Events.PlayerName, | |join on=Profiles._pageName=Games_Events.PlayerName, | ||
Games_Events._pageID=Football_Games._pageID, | Games_Events._pageID=Football_Games._pageID, | ||
Football_Games.Competition = Competitions.OriginalName | Football_Games.Competition = Competitions.OriginalName | ||
גרסה מ־14:26, 24 באוקטובר 2025
Error 1054: Unknown column 'DaysDiff' in 'order clause'
Function: CargoSQLQuery::run Query: SELECT Min(`MPMW_cargo__Games_Events`.`Date`) AS `FirstGame`,`MPMW_cargo__Profiles`.`_pageName` AS `PlayerName`,`MPMW_cargo__Profiles`.`DoB` AS `DoB`,`MPMW_cargo__Profiles`.`DoB__precision` AS `DoB__precision` FROM `MPMW_cargo__Profiles` LEFT OUTER JOIN `MPMW_cargo__Games_Events` ON ((`MPMW_cargo__Profiles`.`_pageName`=`MPMW_cargo__Games_Events`.`PlayerName`)) LEFT OUTER JOIN `MPMW_cargo__Football_Games` ON ((`MPMW_cargo__Games_Events`.`_pageID`=`MPMW_cargo__Football_Games`.`_pageID`)) LEFT OUTER JOIN `MPMW_cargo__Competitions` ON ((`MPMW_cargo__Football_Games`.`Competition`=`MPMW_cargo__Competitions`.`OriginalName`)) WHERE 1=1 AND `MPMW_cargo__Profiles`.`DoB` IS NOT NULL AND `MPMW_cargo__Games_Events`.`Team`=1 GROUP BY `MPMW_cargo__Profiles`.`_pageName`, `MPMW_cargo__Profiles`.`DoB` ORDER BY `DaysDiff` LIMIT 100