@STJ_1234
I would suggest formulating the query as you expect the results to be:
path=/content/my-site/us/en
type=cq:Page
group.1_group.p.not=true
group.1_group.path=/content/my-site/us/en/services
group.1_group.path.self=true
group.2_group.p.not=true
group.2_group.path=/content/my-site/us/en/products
group.2_group.path.self=true
Src: https://sourcedcode.com/blog/aem/query-builder-api-exclude-pages-or-paths#google_vignette
Benefits:
- When someone looks at the query, they know what to expect.
- This way the exclude paths in index are in sync with query, so changes of unexpected results reduce.
Also, please verify that when you do not use excludes in query, is it the custom index thats picked or any other.
Aanchal Sikka