-- écritures locataires
SELECT
                vue_ecrictbloc.*
FROM
                compte
                               JOIN immeuble ON immeuble.codimm = compte.codimm
                               JOIN client_tab ON client_tab.codcli = immeuble.codcli
                               LEFT JOIN vue_ecrictbloc ON compte.codimm = vue_ecrictbloc.codimm AND compte.codindi = vue_ecrictbloc.codindi AND compte.codplanctb = vue_ecrictbloc.codplanctb
                               LEFT JOIN bail ON bail.codimm = compte.codimm AND bail.codcliloc = compte.codindi
WHERE
                vue_ecrictbloc.datctb >= (client_tab.datdebexesoc - '2 mon'::interval * client_tab.perexe::double precision) AND
                compte.codplanctb = 411100 AND
                compte.codimm IN (
                               SELECT immeuble_1.codimm
                               FROM immeuble immeuble_1
                               WHERE
                                               immeuble_1.codcab = ANY (ARRAY[1, 2, 7, 8, 9, 10, 11]) AND
                                               immeuble_1.codetapertimm::text = '0'::text AND
                                               immeuble_1.codserv::text <> 'Z'::text AND 
                                               (immeuble_1.datdempert >= '2017-04-25'::date OR immeuble_1.datdempert IS NULL)
                )

-- écritures coproprietaires
SELECT
    vue_ecrictbcop.*
FROM
                compte
                               JOIN immeuble ON immeuble.codimm = compte.codimm
                               LEFT JOIN vue_ecrictbcop ON compte.codimm = vue_ecrictbcop.codimm AND compte.codindi = vue_ecrictbcop.codindi AND compte.codplanctb = vue_ecrictbcop.codplanctb
                               LEFT JOIN coproprietaire ON coproprietaire.codimm = compte.codimm AND coproprietaire.codcli = compte.codindi
WHERE
                vue_ecrictbcop.datctb >= (immeuble.datdebexesoc - '2 mon'::interval * immeuble.codperexesoc::double precision) AND
                compte.codplanctb = 450000 AND
                compte.codimm IN(
                               SELECT immeuble_1.codimm
                               FROM immeuble immeuble_1
                               WHERE
                                               immeuble_1.codcab = ANY (ARRAY[1, 2, 7, 8, 9, 10, 11]) AND
                                               immeuble_1.codserv::text <> 'Z'::text AND
                                               (immeuble_1.datdempert >= 'now'::text::date OR immeuble_1.datdempert IS NULL)
                )