To find content under a specific node that were replicated between a time period
SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/path]) AND s.[cq:lastReplicated]>=CAST('2016-03-16T18:30:00.000+08:00' AS DATE)
AND s.[cq:lastReplicated]<=CAST('2016-03-17T12:30:00.000+08:00' AS DATE)
To find nodes that ends with ']', e.g. /path/to/node[2]
(Useful if your nodes are hit with the error "Repository error during node import: Cannot create a new node using a name including an index" during replication)
SELECT [jcr:path] FROM [nt:base] WHERE ISDESCENDANTNODE('/etc/designs/') AND [jcr:path] like '%\]'