Your query would have worked without selecting s.user_id, status, and tag in the inner select statement, and as a result, maybe it would run faster.