I want to search for image nodes which don't have particular image rendition.
Suppose I have a path as '/content/dam/mycompany/catalog/part'.
I want to find the images which don't have product-details.png rendition under rendition folder.
Can anyone please help me to get the SQL2 query or query using AEM query debugger?
I tried with the below query
select par.[jcr:path] from [nt:folder] As par WHERE ISDESCENDANTNODE(par, "/content/dam/mycompany/catalog/part/120/051/591") AND par.[jcr:path] not in
(select parent.[jcr:path] from [nt:folder] As parent Inner Join [nt:file] AS child ON ISCHILDNODE(child, parent)
WHERE ISDESCENDANTNODE(parent, "/content/dam/mycompany/catalog/part/120/051/591")
AND parent.[jcr:path] like "%jcr:content/renditions" AND child.[jcr:path] like "%product-details.png")
and got the error as