title: Spring Data 'Left Join Fetch' query returning null
body: <p>My query looks like this:</p>
  
  <pre><code>@Query("SELECT p FROM Pilot p LEFT JOIN FETCH p.playerShips WHERE p.nickname = (:nickname)")
  </code></pre>
  
  <p>So far so good. I'm getting Pilot instance even when playerShips is empty.<br>
  Now, I want to fetch only inactive ships so I modified my query to look like this:</p>
  
  <pre><code>@Query("SELECT p FROM Pilot p LEFT JOIN FETCH p.playerShips s WHERE p.nickname = (:nickname) AND s.active = false")
  </code></pre>
  
  <p>and I'm getting null as a pilot so it clearly doesn't work. <br>I'd be glad if someone could explain me how to create a JOIN FETCH query with WHERE clause that applies to the child elements. Thanks in advance.</p>