more query optimization related to showing submissions from subscribed subverses to logged-in users