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
| SELECT imm.NUMERO_DOSSIER
, imm.LETTRE_DOSSIER
, log.NUMERO_ENTREE
, log.ETAGE
, log.NOMBRE_PIECE
, log.NUMERO_GERANCE
, log.NUMERO_FEDERAL
, occup.DATE_EFFET
, occup.DATE_FIN_BAIL
, occup.STATUT_OCCUPATION_ID_FK
, loc.NOM
, loc.PRENOM
, clog.MONTANT_LOYER_ABAISSE + alog.MONTANT_MENSUEL_COMMUNE + alog.MONTANT_MENSUEL_CANTON + alog.MONTANT_MENSUEL_TIERS AS LOYER_BRUT
, alog.MONTANT_MENSUEL_CANTON
, alog.MONTANT_MENSUEL_COMMUNE
, alog.MONTANT_MENSUEL_TIERS
, clog.MONTANT_LOYER_ABAISSE
, alog.ASI
, alog.ASII
, ALOG.ASIII
, ALOG.ASIV
FROM IMMEUBLE AS imm
JOIN COMMUNE AS comm
ON comm.ID = imm.COMMUNE_ID_FK
INNER JOIN LOGEMENT AS log
ON log.IMMEUBLE_ID_FK = imm.ID
LEFT JOIN OCCUPATION AS occup
ON occup.LOGEMENT_ID_FK = log.ID
INNER JOIN OCCUPANT as loc
ON occup.ID = loc.OCCUPATION_ID_FK
INNER JOIN COUT_LOGEMENT AS clog
ON clog.LOGEMENT_ID_FK = log.ID
INNER JOIN AIDE_LOGEMENT AS alog
ON alog.LOGEMENT_ID_FK = log.ID
WHERE imm.DELEGATION_COMPETENTE = 1
AND comm.NOM_COMMUNE = 'xxxxxxxx'
AND occup.STATUT_OCCUPATION_ID_FK = 5
AND occup.DATE_EFFET <= '2015-01-01'
AND (occup.DATE_FIN_BAIL > '2015-01-01' OR occup.DATE_FIN_BAIL IS NULL)
AND loc.PRENEUR_BAIL = TRUE
AND clog.DEBUT_PERIODE = '2015-01-01'
AND alog.DEBUT_PERIODE = '2015-01-01'
ORDER BY imm.NUMERO_DOSSIER
, imm.LETTRE_DOSSIER
, log.NUMERO_ENTREE
, log.ETAGE
, log.NUMERO_GERANCE; |
Partager