how would you optimize this query which currently takes 10s? I need to select ids with the all enties that are filtered inside a subquery with specific conditions.how would you optimize this query which current
how would you optimize this query which currently takes 10s? I need to select ids with the all enties that are filtered inside a subquery with specific conditions.how would you optimize this query which current