public Page<T> findAll(Specification<T> spec, Pageable pageable)

public List<T> findAll(Specification<T> spec)

 select
        receipttem0_.id as id1_5_0_,
        game1_.id as id1_1_1_,
        receipttem0_.created_by as created_2_5_0_,
        receipttem0_.created_date as created_3_5_0_,
        receipttem0_.last_modified_by as last_mod4_5_0_,
        receipttem0_.last_modified_date as last_mod5_5_0_,
        receipttem0_.version as version6_5_0_,
        receipttem0_.commentary as commenta7_5_0_,
        receipttem0_.game_id as game_id12_5_0_,
        receipttem0_.min_date as min_date8_5_0_,
        receipttem0_.min_draw_id as min_draw9_5_0_,
        receipttem0_.state as state10_5_0_,
        receipttem0_.template_text as templat11_5_0_,
        game1_.arm_url as arm_url2_1_1_,
        game1_.product_id as product_3_1_1_,
        game1_.product_name as product_4_1_1_ 
    from
        receipt_template receipttem0_ 
    left outer join
        game game1_ 
            on receipttem0_.game_id=game1_.id 
    where
        receipttem0_.state in (
            'draft' , 'ready'
        )

select count(generatedAlias0) from ru.arm.template.entities.ReceiptTemplate as generatedAlias0 left join fetch generatedAlias0.game as generatedAlias1 where generatedAlias0.state in (:param0, :param1)

    select
      count(receipttem0_.id)
    from
        receipt_template receipttem0_ 
--     left outer join
--         game game1_ 
--             on receipttem0_.game_id=game1_.id 
    where
        receipttem0_.`state` in (
            'draft' , 'ready'
        );

 @Query(countQuery = "")

 @Query(countQuery = "")

 properties.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQL5InnoDBDialect");

org.​springframework.​data.​jpa.​repository.​JpaSpecificationExecutor
public long count(Specification<T> spec)

if (Long.class != query.getResultType()) {
					root.fetch(Person_.addresses);
				}