Filtros

string(415) "SELECT SQL_CALC_FOUND_ROWS * FROM websites.tb_imovel_consolidado WHERE 1 AND universo IN ('we') AND tipo_oferta IN ('alugar', 'alugar_vender') AND cidade IN ('São Paulo') AND uf IN ('sp')AND ( ( busca_regiao LIKE ('Paulista%') OR busca_bairro LIKE ('Paulista%')) OR (regiao LIKE ('%Paulista%') OR bairro LIKE ('%Paulista%') ) ) ORDER BY destaque DESC, ranking DESC, CHAR_LENGTH(URL) DESC "