hi @geraldss
here is my query
INDEX is on groupid,user,entity
select meta(a).id from test a join test b on keys (a.entity) where a.groupid=1 and a.type=‘FIRST_FILTER’ and b.type=‘SECOND_TYPE’ and ARRAY_CONTAINS(b.users,a.user) order by a.totturnover
i have 60 attributes on alias a test which are sortable (tot records left side matching groupid=1 70K)