java - Spring Data 'Left Join Fetch' query returning null -

my query looks this:

@query("select p pilot p left join fetch p.playerships p.nickname = (:nickname)") 

so far good. i'm getting pilot instance when playerships empty.
now, want fetch inactive ships modified query this:

@query("select p pilot p left join fetch p.playerships s p.nickname = (:nickname) , s.active = false") 

and i'm getting null pilot doesn't work.
i'd glad if explain me how create join fetch query clause applies child elements. in advance.

just move join condition:

@query("select p pilot p left join fetch p.playerships s on s.active = false p.nickname = (:nickname)") 

the on clause defined in jpa 2.1