Which Query of JOIN with DISTINCT & JOIN with Subquery has better Performance?
The first one is good, when you select a larger range, the engine should no longer treat the "subqueries" as such, but run them independantly, and join the results.