select
    distinct ...
from
    mbi_festa mbifesta0_
inner join
    mbi_feber mbifeber1_
        on mbifesta0_.bereich_nr=mbifeber1_.bereich_nr
inner join
    mbi_fekvw mbifekvw2_
        on mbifesta0_.festa_serial=mbifekvw2_.festa_serial
where
    (
        mbifeber1_.bereich_nr in (
            801 , 912
        )
    )
    and (
        mbifesta0_.status between 1 and 8
    )
    and mbifekvw2_.verw_tabelle=1
    and mbifekvw2_.aufloes_knz='1'
    and (
        exists (
            select
                (mbiaflap3_.lade_nr,
                mbiaflap3_.ladepos_nr)
            from
                mbi_aflap mbiaflap3_
            where
                mbiaflap3_.afsta_serial=mbifekvw2_.stamm_serial
                and mbiaflap3_.pos_nr=mbifekvw2_.af_pos_nr
                and mbiaflap3_.lade_nr>=19260
                and mbiaflap3_.lade_nr<=19260
        )
    )