SELECT d.dataid
FROM dtree d
JOIN dversdata dv ON d.dataid = dv.docid AND d.VERSIONNUM = dv.VERSION AND LOWER(dv.FILETYPE) = 'pdf'
JOIN dtreeancestors da ON da.dataid = d.dataid AND da.ancestorid IN (%2)
WHERE dv.VERCDATE > %1