@nj2 You can do something like this : SELECT page.* FROM [cq:Page] AS pageINNER JOIN [cq:PageContent] AS jcrContentNode ON ISCHILDNODE(jcrContentNode, page)WHERE ISDESCENDANTNODE(page, "/content/abc")AND jcrContentNode.[cq:lastModified] <= CAST("2023-01-01T00:00:00.000+00:00" AS DATE) The value th...