Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') T left join (select idclient,date,valeur as poid from performances where id...' at line 1 Whole query: select date_format(T3.date,'%Y-%m-%d') as date,if(isnull(T3.poid),'NaN',poid) as poid,if(isnull(taille),'NaN',taille) as taille,if(isnull(nage100),'NaN',nage100) as nage100 from (select T.date,poid from (select distinct(date) from performances where idclient=) T left join (select idclient,date,valeur as poid from performances where idclient= and indic=2) T1 on T.date=t1.date) T3 left join (select idclient,date,valeur as taille from performances where idclient= and indic=3) T4 on T3.date=T4.date left join (select idclient,date,valeur as nage100 from performances where idclient= and indic=6) T6 on T3.date=T6.date order by date