REQUEST:SELECT clb_rencontrext.Nom AS Journee,
clb_rencontrext.ID,
clb_rencontrext.Adversaire,
clb_rencontrext.Score,
clb_rencontrext.DateMatch,
clb_rencontrext.Resultat,
clb_rencontrext.Domicile,
clb_rencontrext.Commentaire,
clb_engagementxt.Poule,
'' AS EqDom,
'' AS EqExt,
0 AS MClub,
CONCAT(clb_competition.Nom) as Compet,clb_equipext.Nom,clb_equipext.ID AS IDEquipe, clb_equipext.CatAges, clb_equipext.Genres, '' AS Categorie
FROM clb_rencontrext
LEFT JOIN clb_engagementxt ON clb_engagementxt.ID=clb_rencontrext.Engagement
LEFT JOIN clb_competition ON clb_competition.ID=clb_engagementxt.Competition
LEFT JOIN clb_equipext
ON clb_equipext.ID=CASE
WHEN clb_rencontrext.Engagement IS NULL THEN clb_rencontrext.Equipe
ELSE clb_engagementxt.Equipe
END
WHERE (DateMatch<='2018-02-22' AND DateMatch>='2018-01-22') AND (clb_rencontrext.Score!='' AND clb_rencontrext.Score IS NOT NULL)
ORDER BY clb_equipext.CatAges DESC, clb_equipext.Nom ASC,Compet ASC, clb_rencontrext.DateMatch DESC Table 'msc_asfontainehandball.clb_rencontrext' doesn't exist