1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
| SELECT
Bien.IDBien AS IDBien,
Bien.CodeDispo AS CodeDispo,
Bien.IDSsCatbien AS IDSsCatbien,
Bien.am_SurfaceHabitable AS am_SurfaceHabitable,
Bien.a_SurfaceCarrez AS a_SurfaceCarrez,
Bien.ambf_NbrePiece AS ambf_NbrePiece,
Bien.am_NbreChambre AS am_NbreChambre,
Bien.Adresse AS Adresse,
Bien.CodePostal AS CodePostal,
Bien.Ville AS Ville,
Bien.PrixComCompris AS PrixComCompris,
Bien.abi_NbreParkingCouvert AS abi_NbreParkingCouvert,
Bien.ab_Etage AS ab_Etage,
Bien.abi_NbreEtage AS abi_NbreEtage,
Bien.abi_Ascenceur AS abi_Ascenceur,
Bien.a_Balcon AS a_Balcon,
Bien.am_Terrasse AS am_Terrasse,
Bien.a_Jardin AS a_Jardin,
Bien.IDAgence AS IDAgence,
Bien.date_modification AS date_modification,
Copro.MetroRer AS MetroRer,
Copro.metro2 AS metro2,
Bien.Modifie AS Modifie,
Bien.BienEnAgence AS BienEnAgence,
Bien.IDim AS IDim,
SsCatbien.Description AS Description,
SsCatbien.IDSsCatbien AS IDSsCatbien_Ss,
Bien.adresseCopro AS adresseCopro,
Bien.UnPourCent AS UnPourCent,
Bien.estDoublonDe AS estDoublonDe,
Bien.MiseAjour AS MiseAjour,
Copro.CodePostal AS CodePostal_Co
FROM
SsCatbien RIGHT OUTER JOIN Bien ON SsCatbien.IDSsCatbien = Bien.IDSsCatbien,
Copro RIGHT OUTER JOIN Bien ON Copro.IDCopro = Bien.IDCopro
WHERE
(
Bien.IDBien = {p_IDBien}
OR Bien.IDim = {p_IDBien}
OR
(
(
Bien.PrixComCompris BETWEEN {p_PrixComCompris1} AND {p_PrixComCompris2}
OR Bien.PrixComCompris IS NULL
)
AND Bien.CodePostal IN ({p_listeCodePostal})
AND Bien.adresseCopro LIKE %{p_Adresse}%
AND Bien.MiseAjour BETWEEN {P_dateMin} AND {p_dateMax}
AND Bien.CodeDispo IN ({p_CodeDispo})
AND
(
Bien.am_SurfaceHabitable BETWEEN {p_SurfaceHabitable1} AND {p_SurfaceHabitable2}
OR Bien.am_SurfaceHabitable IS NULL
)
AND Bien.ambf_NbrePiece >= {p_NbrePiece1}
AND Bien.am_NbreChambre >= {p_NbreChambre1}
AND
(
Bien.ab_Etage BETWEEN {p_etageMin} AND {p_etageMax}
OR Bien.ab_Etage IS NULL
)
AND Bien.abi_NbreParkingCouvert >= {P_parking}
AND
(
Bien.abi_Ascenceur = {p_ascenceur}
OR Bien.ab_Etage < {p_etage}
)
AND
(
Copro.MetroRer LIKE %{p_metro}%
OR Copro.metro2 LIKE %{p_metro}%
)
AND
(
Bien.a_Balcon = {p_balcon}
OR Bien.am_Terrasse = {p_terrasse}
OR Bien.a_Jardin = {p_jardin}
)
AND Bien.estDoublonDe = 0
)
) |
Partager