Avis des clients ayant laissé des commentaires.

Erreur SQL !
SELECT FORMAT((SELECT AVG(t4.enq_rep) FROM t_enquete_info t4 WHERE t4.enq_qsm IN('B0','B1','B2','B3','D2')),1) AS cli_note_01, FORMAT((SELECT AVG(t4.enq_rep) FROM t_enquete_info t4 WHERE t4.enq_qsm IN('C0','D1')),1) AS cli_note_02, FORMAT((SELECT AVG(t4.enq_rep) FROM t_enquete_info t4 WHERE t4.enq_qsm IN('C1','C2','C3')),1) AS cli_note_03, FORMAT((SELECT AVG(t4.enq_rep) FROM t_enquete_info t4 WHERE t4.enq_qsm IN('A0','E0','E1','E2')),1) AS cli_note_04, FORMAT((SELECT AVG(t4.enq_rep) FROM t_enquete_info t4 WHERE t4.enq_qsm IN('D0')),1) AS cli_note_05, FORMAT(( FORMAT((SELECT AVG(t4.enq_rep) FROM t_enquete_info t4 WHERE t4.enq_qsm IN('B0','B1','B2','B3','D2')),1) + FORMAT((SELECT AVG(t4.enq_rep) FROM t_enquete_info t4 WHERE t4.enq_qsm IN('C0','D1')),1) + FORMAT((SELECT AVG(t4.enq_rep) FROM t_enquete_info t4 WHERE t4.enq_qsm IN('C1','C2','C3')),1) + FORMAT((SELECT AVG(t4.enq_rep) FROM t_enquete_info t4 WHERE t4.enq_qsm IN('A0','E0','E1','E2')),1) + FORMAT((SELECT AVG(t4.enq_rep) FROM t_enquete_info t4 WHERE t4.enq_qsm IN('D0')),1) )/5,1) AS cli_note_generale, (SELECT count(*) FROM t_enquete t2 WHERE enq_visible <> 0 AND enq_recommander <> 0 ) as enq_total_recommander, (SELECT count(*) FROM t_enquete t2 WHERE enq_visible <> 0 ) as enq_total_avis FROM t_enquete t2 JOIN t_client t1 on t1.id=t2.cli_id
Unknown column 'enq_visible' in 'where clause'