Does the explicit JOIN perform better than the subquery select?