You could improve such a query by including the join (in which case you get more reliable results), but you might not think of it and I guess my main point is that you would expect outdated relationships to be removed - what are the reasons for not doing so?