Pasted

select * from dauditnew where auditstr = 'Deleted' and dataid in (
        select ancestorid from dtreeancestors where dataid in (
                select dataid from dtreecore where dataid in (
                1990343,
                1990344,
                1991225,
                1990672,
                1990673,
                1990348,
                1989792,
                1991228,
                1990353,
                1990354,
                1991230,
                1991231,
                1989795,
                1990782,
                1991222,
                1991223,
                1991224,
                1990345,
                1991226,
                1991227,
                1990346,
                1990347,
                1990674,
                1990349,
                1990350,
                1990351,
                1990352,
                1990675,
                1991229,
                1989793,
                1989794,
                1991232,
                1991233)
        )
)