if ((keysIn == null) || (keysIn.size() == 0))
return Collections.emptyList();
DynamicQuery dynamicQry = new DynamicQuery(selectSQL);
appendSortTables(dynamicQry);
dynamicQry.appendInListWithAnd(ENTITY_ALIAS + "." + KEY_NAME, keysIn);
if (restrictions != null && restrictions.length > 0)
dynamicQry.AND().pad().appendGroupedAnd(restrictions);
appendSortCriteria(dynamicQry, fq);