base SELECT id_cours, id_id AS id, `Libelle2_cours` AS cours,`heures_cours` AS heure,`ref_prof` AS prof,CONCAT(ref_prof2, ' ', ref_prof3) AS profs FROM `cours_ipc` WHERE (`groupe_classe`='') AND (`option_classe`='') AND (type_cours = 11) AND (heures_cours>0)