There is one missing join in the where clause translating "member of" which should tie the main table and the table in subselect. I am committing a test that shows the problem.