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'