Php – Syntax Error line 0, col 245: Error: Unexpected ')'
This SQL request works perfectly: SELECT f.idFile, f.FileName, f.date_file, COUNT(DISTINCT (ligne.numLigne)) AS nbCmde, COUNT(DISTINCT CASE WHEN bl.date_production != "0000-00-00 00:00:00" THEN ligne.numLigne END) AS cmdProd, COUNT(DISTINCT CASE WHEN bl.date_production = "0000-00-00 00:00:00" THEN ligne.numLigne END) AS cmdNonProd, COUNT(DISTINCT CASE WHEN…