SELECT r.* 
                                                FROM realty r 
                                                LEFT JOIN agencias a ON a.id = r.agencia_id
                                                WHERE r.status = 1 AND a.status = 1 AND LENGTH(r.uf) = 2 AND LENGTH(r.image) > 5  AND r.id <> 366936 AND (r.price_sales >= '336000' AND r.price_sales <= '504000') AND r.region = 'Miramar' AND r.city = 'Belo Horizonte' AND r.category = 'Casa'  AND IF(r.agencia_id <> 119, r.updated_at >= DATE_SUB(CURDATE(), INTERVAL 180 DAY) AND r.updated_at IS NOT NULL AND COALESCE(r.updated_at, '0000-00-00 00:00:00') <> '0000-00-00 00:00:00', r.agencia_id = 119) AND ((a.compartilhamento = 1 AND r.agencia_id <> 119) OR r.agencia_id = 119) AND ((a.hubw = 1 AND r.agencia_id <> 119) OR r.agencia_id = 119)  
                                                ORDER BY r.id DESC
 LIMIT 8