select id from CRM_MA where
(
                (
                    (
                        Endedatum_DT>=20170817220000000
                    )
                    OR
                    (
                        (
                            (
                                Endedatum_DT>=20170816220000000 AND Endedatum_DT<20170817220000000
                            )
                        )
                        AND
                        (
                            (
                                MOD(Endedatum_DT,1000000000)>100000000 AND MOD(Endedatum_DT,1000000000)<=215900000
                            )
                        )
                    )
                )
                AND
                (
                    (
                        Datum_DT<20170817220000000
                    )
                    OR
                    (
                        (
                            (
                                Datum_DT>=20170817220000000 AND Datum_DT<20170818220000000
                            )
                        )
                        AND
                        (
                            (
                                MOD(Datum_DT,1000000000)>=220000000 OR MOD(Datum_DT,1000000000)<220000000
                            )
                        )
                    )
                )
            )
            OR
            (
                (
                    (
                        Datum_DT>=20170817220000000
                    )
                    OR
                    (
                        (
                            (
                                Datum_DT>=20170816220000000 AND Datum_DT<20170817220000000
                            )
                        )
                        AND
                        (
                            (
                                MOD(Datum_DT,1000000000)>100000000 AND MOD(Datum_DT,1000000000)<=215900000
                            )
                        )
                    )
                )
                AND
                (
                    (
                        Datum_DT<20170817220000000
                    )
                    OR
                    (
                        (
                            (
                                Datum_DT>=20170817220000000 AND Datum_DT<20170818220000000
                            )
                        )
                        AND
                        (
                            (
                                MOD(Datum_DT,1000000000)>=220000000 OR MOD(Datum_DT,1000000000)<220000000
                            )
                        )
                    )
                )
                AND
                (
                    Endedatum_DT<1000000000
                )
            )