JCR-SQL2 query

[danisevsky]

Hi,

could someone please help me with JCR-SQL2 query? I would like to do
find out count of all files (photos) which are in some folder
hierarchy. This query is almost what I need

Select * from [nt:file] as file WHERE ISDESCENDANTNODE(file,
[/brix:root/Data/Users/2/35935/racesPhotos/79])

But I need to exclude all files which are on path "*/imported/small/*".

Thanks in advance.