Error No: 1064 - MySQL error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-10, 10' at line 31
Query: [SELECT I.cod AS cod, I.codigo AS codigo, I.edificio AS edificio, I.bairro AS bairro, I.cidade AS cidade, I.estado AS estado, I.valor_aluguel AS valorAluguel, I.valor_venda AS valorVenda, I.banheiros, I.m2, D.descricao AS dormitorios, G.descricao AS vagas, M.descricao AS mobilia, -- (select M.nome_arquivo from imagens M where M.cod_imovel = I.cod and M.foto_principal like 'S') AS foto_principal, -- (select M.nome_arquivo from imagens M where M.cod_imovel = I.cod order by M.cod limit 1) AS foto_secundaria, I.regiao AS regiao, E.quartos quartosEdificio, E.suites suitesEdificio, E.banheiros banheirosEdificio, E.vagas vagasEdificio, E.m2 m2Edificio, E.valorCondominio valorCondominioEdificio, E.valorIptu valorIptuEdificio FROM (((imoveis I INNER JOIN edificio E ON E.cod = I.codEdificio LEFT JOIN dormitorios D ON (D.cod_dormitorio = I.cod_dormitorio)) LEFT JOIN garagem G ON(I.vagas = G.cod_garagem)) LEFT JOIN mobilia M ON(M.cod_mobilia = I.cod_mobilia)) WHERE I.excluido = 'N' AND I.fotos = 'S' AND (I.valor_aluguel > 0 OR I.valor_venda > 0 ) AND I.cidade LIKE 'sao paulo' AND I.estado LIKE 'comprar' AND I.bairro LIKE 'parque anhembi' AND E.ativo LIKE 'S' ORDER BY I.valor_aluguel ASC LIMIT -10, 10]
#0 /home/r2flats/public_html/classes/classHome.php(421): Connection->myQuery('SELECT I.cod AS...')
#1 /home/r2flats/public_html/bairro.php(108): ClassHome->exibeImoveisComLimite('SELECT I.cod AS...')
#2 /home/r2flats/public_html/_config.php(218): include('/home/r2flats/p...')
#3 {main}