ERREUR : SELECT m.idMusician, CONCAT_WS(' ',m.FirstName,m.Name) AS Name, NickName FROM musician m, artist a, performer p, concert c, hall h WHERE m.idMusician = p.idMusician AND a.idArtist = a.idArtist AND c.idArtist = a.idArtist AND c.idArtist = p.idArtist AND c.idhall = h.idHall AND DATE_FORMAT(c.Schedule,'%Y') = 2015 AND DATE_FORMAT(c.Schedule,'%c') = 7 AND DATE_FORMAT(c.Schedule,'%Y-%m-%d') >= CURDATE() AND m.Focus = '1' AND m.Status = '2' AND a.Status='2' AND c.Status='2' AND h.Status='2' GROUP BY m.idMusician;