Marc, If I correctly understand the result you seek, you need to do a three way join across the entities. The JPQL below may be what you need (or close to it). The IN() join syntax may also work, but I haven't tried it.
"SELECT z FROM Magazine x JOIN x.articles y JOIN y.paragraph z where y.authorName = 'John Doe' AND z.number = 2" -Jeremy
