Error en ejecución de la consulta:
SELECT DateMatch,Mes,Rival,Lugar,Resultado,Puntos,If(KeyDuplex='Local',match1.Local,match1.Visitante) AS IdStatTeam,DateMatch,Jugado FROM (SELECT 1 AS JoinDuplex, DateMatch, DATE_FORMAT(DateMatch,'%m/%y') AS Mes,if(Local=@locator_idstatteam,team2.TeamName,team1.TeamName) as Rival,if(Local=@locator_idstatteam,'L','V') as Lugar,if(GolesL is Null,0,if(GolesL>GolesV,if(Local=@locator_idstatteam,'3','0'),if(GolesL=GolesV,1,if(Local=@locator_idstatteam,'0','3')))) as Puntos,if(GolesL is Null,0,1) AS Jugado,if(GolesL is null,concat('[',DATE_FORMAT(DateMatch,'%d/%m/%Y'),'] ',team1.TeamName,' - ',team2.TeamName),concat(if(GolesL>GolesV,if(Local=@locator_idstatteam,'3','0'),if(GolesL=GolesV,1,if(Local=@locator_idstatteam,'0','3'))),' punto(s) [',DATE_FORMAT(DateMatch,'%d/%m/%Y'),'] ',team1.TeamName,' ',GolesL,'-',team2.TeamName,' ',GolesV)) as Resultado,soccerstats_matches.* FROM soccerstats_matches INNER JOIN soccerstats_teams AS team1 ON soccerstats_matches.Local=team1.IdStatTeam INNER JOIN soccerstats_teams AS team2 ON soccerstats_matches.Visitante=team2.IdStatTeam WHERE soccerstats_matches.IdStat=@locator_idstat AND (Local=@locator_idstatteam || Visitante=@locator_idstatteam) ORDER BY DateMatch)AS match1 INNER JOIN (SELECT 1 AS JoinDuplex, soccerstats_duplex.* FROM soccerstats_duplex) AS duplex ON match1.JoinDuplex = duplex.JoinDuplex WHERE If(KeyDuplex='Local',match1.Local,match1.Visitante)=@locator_idstatteam ORDER BY DateMatch
1060: Nombre de columna duplicado 'DateMatch'
statdata