performance: use all_with_access for unlimited queries

In queries with like and limit the join used by with_access is faster.
However when retrieving all records the subselect used by all_with_access is
way faster