Pasted

          select dv.*
        from dtree d
        join dtreeancestors da on d.dataid = da.dataid and da.ancestorid = 999999
        join dversdata dv on d.dataid = dv.DOCID and d.VERSIONNUM = dv.VERSION
        where lower(dv.FILETYPE) like 'tif%'
        or    lower(dv.MIMETYPE) like '%tif%'
        or    lower(filename) like '%tif%'