You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and CLI_ETAT='1'     
group by CLI_ID' at line 17<br />
select distinct CLI_ID,SEC_LIBELLE,SEC_ID,CLI_PSEUDO,CLI_MONTANT_FOND,CLI_DESCRIPTION,CLI_PROJET_VILLE,PAY_LIBELLE,CCL_LIBELLE,CLI_PROJET_PAY_ID,CLI_FACT_VILLE,CLI_FCT_ID <br />
from <br />
		nf_gen_client<br />
		LEFT JOIN nf_gen_type_client on (TCL_ID = CLI_TCL_ID)<br />
		LEFT JOIN nf_gen_cat_client on (CCL_ID = TCL_CCL_ID)<br />
		LEFT JOIN nf_gen_pays on (PAY_ID=CLI_NATIONALITE_PAY_ID)<br />
		LEFT JOIN nf_com_sous_secteur on (SSE_ID = CLI_SSE_ID)<br />
		LEFT JOIN nf_com_secteur on (SEC_ID = SSE_SEC_ID)<br />
		/*<br />
		LEFT JOIN nf_com_ville on (VIL_ID = CLI_RESIDENCE_VIL_ID)<br />
		*/<br />
		LEFT JOIN nf_com_marche on ( MAR_ID = CLI_MAR_ID)<br />
		LEFT JOIN nf_com_commande ON COM_CLI_ID=CLI_ID AND CAST(NOW() AS DATE) BETWEEN COM_DATE_DEBUT_ABONNEMENT AND COM_DATE_FIN_ABONNEMENT<br />
		LEFT JOIN nf_com_offre ON COM_OFF_ID = OFF_ID<br />
		LEFT JOIN nf_com_type_offre ON TOF_ID=OFF_TOF_ID<br />
	 <br />
where CCL_ID IN () and CLI_ETAT='1'     <br />
group by CLI_ID