从大多数内部查询开始，创建相对的DetachedCriteria并使用Subqueries.in()附加到外部查询.
对于count(distinct)，请使用Projections.countDistinct(propertyName). 享受.

Begin from most inner query create relative DetachedCriteria and attach to outer query using Subqueries.in().
For count(distinct) use Projections.countDistinct(propertyName). Enjoy.