select SQL_CALC_FOUND_ROWS distinct i.*,i.foto_destaque Imagem_Destaque,Area_Terreno,Status_Imovel,Isento_Aluguel_Aniversario, DATEDIFF(now(),Evento_Inicio) Dias_Inicio,DATEDIFF(Evento_Fim,now()) Dias_Fim,Selo_Qualidade,TIME_TO_SEC(TIMEDIFF(now(),'2018-11-19 03:45:05')) Tempo_Pesquisa, EXTRACT(YEAR FROM Evento_Fim) Ano_Fim_Evento,EXTRACT(MONTH FROM Evento_Fim) Mes_Fim_Evento,EXTRACT(DAY FROM Evento_Fim) Dia_Fim_Evento, Status_Imovel, isAgendamento, /*CASE WHEN realB.ID IS NULL THEN 1 WHEN realB.ID IS NOT NULL AND realB.post_status = 'publish' THEN 1 WHEN realB.ID IS NOT NULL AND realB.post_status <> 'publish' THEN 0 ELSE THEN 0 END AS to_show*/ IF ( realB.ID IS NOT NULL && realB.post_status = 'publish', 1, 0 ) AS real_show from vw_imoveis_disponiveis_novo i inner join wp_imoveis_enderecos_bairros b on b.Post_ID = i.id inner join wp_imoveis_enderecos_cidades c on c.Post_ID = i.id inner join wp_terms t on t.term_id = i.Tipo_ID and t.term_id = (select term_id from wp_term_relationships r inner join wp_term_taxonomy tt on tt.term_taxonomy_id = r.term_taxonomy_id and taxonomy = 'tipo_imovel' where r.object_id = i.id limit 1) left join apo_fotosimoveis f on f.referencia = i.referencia and f.transacao = i.transacao and isPrincipal = '1' LEFT JOIN realestate.real_imoveis_detalhes realA ON (realA.Referencia = i.referencia) LEFT JOIN realestate.real_posts realB ON (realA.Post_ID = realB.ID) where transacao_id <> 51 and i.transacao = 'locacao' and c.Cidade = 'curitiba' and Estado = 'PR' and (Tipo like '%casa%' or Tipo in ('casa')) order by Valor_Tratado desc limit 0,10