There is an error on the SQL command.
SQL:
select sql_cache COUNT(CODIGO) as n FROM fbz_imoveis imo WHERE VER_WEB='Sim' AND (STATUS = 'VENDA' OR STATUS = 'ALUGUEL' OR STATUS = 'VENDA E ALUGUEL') AND INSTR(STATUS,'ALUGUEL')>0 AND ( ( VLR_ALUGUEL >= 0 AND VLR_ALUGUEL <= 1000 ) ) AND ( DORMITORIO=1%2C2 ) AND ( SUITE=2 ) AND ( VAGAS=1 ) AND AREA_PRIVATIVA>0 AND ( ( AREA_PRIVATIVA>=300 and AREA_PRIVATIVA<=500 ) )
Error:
Unknown column '2C2' in 'where clause'