Erro: XXSELECT i.id AS id, i.id_tipo, i.foto1 AS foto1, i.foto2 AS foto2, i.foto3 AS foto3, i.foto4 AS foto4, i.foto5 AS foto5, i.foto6 AS foto6, i.area_util AS area_util, i.area_total AS area_total, i.valor_aluguel, i.valor_venda, i.empreendimento AS empreendimento, i.dormitorios AS dormitorios, i.vagas AS vagas, i.suites AS suites, i.banheiros AS banheiros, i.descricao AS descricao, ic.nome AS classe, ic.slug AS classe_slug, it.nome AS tipo, it.slug AS tipo_slug, b.nome AS bairro, b.slug AS bairro_slug, c.nome AS cidade, c.amigavel AS cidade_slug, c.uf AS uf, u.nome_fantasia AS usuario, u.id AS user_id, u.logotipo AS user_logotipo, u.slug as user_slug FROM imoveis i INNER JOIN (usuarios u) ON u.id = i.id_usuario LEFT JOIN (planos p) ON p.id = u.id_plano LEFT JOIN (imoveis_classes ic) ON ic.id = i.id_classe LEFT JOIN (imoveis_tipos it) ON it.id = i.id_tipo LEFT JOIN (cidades c) ON c.id = i.id_cidade LEFT JOIN (bairros b) ON b.id = i.id_bairro LEFT JOIN (regiao_cidades rc) ON rc.id_cidade = c.id WHERE i.ativo = '1' AND u.autorizado = '1' AND FIND_IN_SET('1', i.exibicao) AND FIND_IN_SET('1', u.exibicao) AND IF (FIND_IN_SET('1', u.exibicao_foto), i.possui_foto = '1', 1 = 1) AND (rc.id_regiao = '1310568540' OR i.id_cidade IS NULL) GROUP BY i.id ORDER BY i.ativo , i.possui_preco DESC, jitter ASC LIMIT 0,30The table '/tmp/#sql_53c5_0' is full