SELECT sp.date_heure_match AS `date`, sp.cle1 AS cle1, sp.cle2 AS cle2,sp.cle3 AS cle3,sp.cle4 AS cle4,sp.cle5 AS cle5, sp.intro AS intro, sp.texte AS texte, sp.conclusion AS conclusion, spt.tablecotes AS tablecotes, sp.id_match AS idmatch, sp.id_equipe1 AS id1, sp.id_equipe2 AS id2, sp.autre_equipe1 AS eq1, sp.autre_equipe2 AS eq2,spt.idGroup AS type, sbo.nom AS book, sp.id_Bookmaker,cet1.nom AS eq1_trad, cet2.nom AS eq2_trad,ce1.nom AS nom1, ce2.nom AS nom2, sp.meta_url AS meta, sp.id_Prono AS prono
FROM sportytrader.prono2 sp
INNER JOIN sportytrader.prono_types spt ON sp.type_prono =spt.id
INNER JOIN cotes.bookmakers cb ON sp.id_Bookmaker = cb.idbookmaker
INNER JOIN sportytrader.bookmakers_options sbo ON cb.id_sporty = sbo.id_book AND sbo.LCID= 1040
INNER JOIN cotes.equipes ce1 ON sp.id_equipe1 = ce1.id
LEFT OUTER JOIN cotes.equipes_traductions cet1 ON ce1.id = cet1.id_equipes AND cet1.LCID =1040
INNER JOIN cotes.equipes ce2 ON sp.id_equipe2 = ce2.id 
LEFT OUTER JOIN cotes.equipes_traductions cet2 ON ce2.id = cet2.id_equipes AND cet2.LCID =1040
WHERE sp.LCID =1040 AND sp.site_cible = 4 AND sp.id_match = 411640<br>The server requested authentication method unknown to the client