Limit queries and reorder to use index on metadata.red