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}