Report from ACS Common is not returning correct result.

[sangram2019]

Required Information

• AEM Version, including Service Packs, Cumulative Fix Packs, etc: AEM 6.5, Service Pack 19
• ACS AEM Commons Version: 5.1.2
• Reproducible on Latest? yes

Expected Behavior

When report with SQL-2 query " SELECT * FROM [cq:PageContent] AS form WHERE ISDESCENDANTNODE([{{path}}])
AND [cq:lastReplicated] IS NOT NULL" is executed then it should return all child pages satisfying given condition. But it is not returning all results.
But when the same query is executed through Query Debugger in CRX/DE, it returns all pages.

Actual Behavior

Please describe briefly the actual behavior, i.e. when I do X, Z happens.

Steps to Reproduce

Starting from a vanilla instance of AEM at the above version, describe in explicit steps how to reproduce. Link to
any supporting assets, e.g. content packages, below

Links

Links to related assets, e.g. content packages containing test components