QueryOver<IsfContentItemBase, RenditionJob> subQuery = QueryOver.Of<IsfContentItemBase>()
                    .JoinQueryOver<RenditionJob>(c => c.RenditionJob)
                    .Where(j => j.Id == renderJobId)
                    .Select(c => c.Id);

                IsfSitePackageRequest package = Session.QueryOver<IsfSitePackageRequest>()
                    .JoinAlias(r => r.Items, () => contentAlias)
                    .WithSubquery.WhereExists(subQuery)
                    .List<IsfSitePackageRequest>()
                    .FirstOrDefault();