title: Doing a WHERE .. IN subquery in Doctrine 2
body: <p>I'd like to select order items from all orders with a specific item. In SQL I'd do it like this:</p>
  
  <pre><code>SELECT DISTINCT i.id, i.name, order.name 
  FROM items i 
  JOIN orders o ON i.order_id=o.id 
  WHERE o.id IN (
     SELECT o2.id FROM orders o2
     JOIN items i2 ON i2.order_id=o2.id AND i2.id=5
  )
  AND i.id != 5
  ORDER BY o.orderdate DESC
  LIMIT 10
  </code></pre>
  
  <p>How would I do this query with the query builder?</p>