Thank you for your reply!
I have it working perfectly with the 5 maximum limit, which is not the issue. Hibernate queries it very well itself too.
My concern was that I wanted to retrieve the parent Article with recommended, but then the child Set without their recommended.
Or do you mean I can also do this with a UNION ALL query?
I thought selecting only a few fields would change whatever you queried into an Object.
Also how would I write this query then?
Something along:
SELECT author, title, content,date,recommended.title,recommended.date, WHERE …
Would that work with sets?