@Query("select distinct p.insurer from #{#entityName} p")
  Set<String> findInsurers();

  @Query("SELECT NEW com.amfinesoft.common.core.dto.ProductIdDto(p.insurer, p.productId, p.productName, p.profileId, p.profileName)" + //
    "     FROM #{#entityName} p JOIN p.includedUnderlyings iu JOIN iu.underlying u" + //
    "     WHERE p.insurer in :insurers AND u.isin = :isin" + //
    "     ORDER BY p.insurer asc, p.productId asc, p.profileId asc")
  Page<ProductIdDto> findProductsByIsin(@Param("isin") final String isin, @Param("insurers") final Set<String> insurers, Pageable page);
}