join instead of subquery, makes annotation page faster