Transaxia – Biens immobiliers à vendre et à louer en France

SELECT * FROM `bien` JOIN `agence` ON `agence`.`id_agence` = `bien`.`id_agence` WHERE id_bien!='' AND (bien.`id_agence` = '108' or (bien.id_agence='36' and id_bien not in (select id_origine_duplicate from bien where id_agence='108' and id_origine_duplicate is not null) and id_bien in (select id_bien from bien where ROUND(6371 * acos(cos(radians('46.1179944')) * cos(radians(latitude)) * cos(radians(longitude) - radians('1.6287569')) + sin(radians('46.1179944')) * sin(radians(latitude)))) <=20))) and `agence`.`etat` = 1 AND `bien`.`etat` = 1 and (type_offre=1 or type_offre='' or type_offre is null) and statut!=3 and statut!=5 and statut!=4 Transaxia – Biens immobiliers à vendre et à louer en France