title: jpa query where the entity on a collection is in a list
body: <p>Probably not best described in the title but i have 3 entities</p>
  
  <p>Order -> OneToMany -> OrderProduct</p>
  
  <p>and </p>
  
  <p>OrderProduct &lt;- ManyToOne -> Product </p>
  
  <p>Product &lt;- OneToMany -> OrderProduct , </p>
  
  <p>my native query that works is</p>
  
  <pre><code>SELECT t0.*
  FROM isc_orders t0 
  INNER JOIN isc_customers t1 ON t0.ordcustid = t1.customerid 
  INNER JOIN isc_order_products t2 ON t0.orderid = t2.orderorderid 
  INNER JOIN isc_products t3 ON t2.ordprodid = t3.productid
  where t3.productid in (359, 344, 345, 346, 347, 348)
  </code></pre>
  
  <p>is there any way to do this in a JPA way in a single select as I have my collections and and entities eager loading with join so that the object graph is populated on one pass</p>