Error line 384
Query : [
SELECT nb FROM ( SELECT count(b.id_bien) AS nb FROM bien b, agent a WHERE b.id_agent = a.id_agent AND b.canal='Vente' AND b.etat = 'OK' AND b.surface >= '0' AND b.prix >= '0' AND (b.ville = 'TRICASE') AND (b.nb_piece IN ()) UNION SELECT count(b.id_bien) AS nb FROM bien b, agent a WHERE b.id_agent = a.id_agent AND b.canal='Vente' AND b.etat = 'OK' AND (b.dept = 'LE') AND NOT (b.ville = 'TRICASE') ) AS total] : Erreur count: 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 ')) UNION SELECT count(b.id_bien) AS nb FROM bien b, agent a WHERE b.id_age' at line 3