Invalid query: 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 C.preciolimite >= I.precioreal and I.dormitorios >= C.dormitorios AND  ( C.t' at line 1
Whole query: SELECT COUNT(DISTINCT C.codcliente) as 'clientes'  FROM inmuebles I, clientes C,zonasinteresadas Z,tiposinmueblesinteresados T  WHERE I.codinmueble =  AND C.preciolimite >= I.precioreal and I.dormitorios >= C.dormitorios AND  ( C.tipocontrato = 0 OR ( C.tipocontrato = I.tipocontrato) OR I.tipocontrato = 0) AND Z.codcliente = C.codcliente AND Z.codzona = I.codzona  AND T.codcliente = C.codcliente AND T.codtipoinmueble = I.codtipo