Even Easiest Join Gets Complicated In Nhibernate

Ok, So I have the following database schema And the relation is a one-to-many relation (one Album can have many Images) The mapping looks something like this: Copy

The biggest advantage is, that the Album result (SELECT) is flat(not joined with multi Images) - so we can easily use paging:

...
.Take(50)
.Skip(50)
.List<Album>();

Check some other subquery QueryOver: select columns from subquery