title: Nhibernate Linq - fetchmany where many count == 0
body: <p>I have this query:</p>
  
  <pre><code> var query = session.Query&lt;Album&gt;()
                      .FetchMany(x =&gt; x.Tracks)
                      .ThenFetchMany(x =&gt; x.Indices)
                      .Where(t =&gt; t.Tracks.Any(v =&gt; v.Indices.Count == 0))
                      .Take(20)
                      .ToList();
  </code></pre>
  
  <p><code>Album</code> has <code>List</code> <code>Track</code> (hasmany).
  <code>Track</code> has <code>List</code> <code>Indices</code> (hasmany).</p>
  
  <p>instead of getting 20 rows, I get 2 rows.<br>
  when I saw the result in the profiler, it looks like the <code>Take</code> is referring to the <code>Track</code> and not the <code>Album</code>.<br>
  Any Idea?
  Thanks</p>