Optimized query for watched_by scope