List<HistoricTaskInstance> tasks = execution
				.getProcessEngineServices()
				.getHistoryService()
				.createHistoricTaskInstanceQuery()
				.tenantIdIn("Test_Tenant")
				.or()
				.taskHadCandidateGroup("GROUP_TEST")
				.taskHadCandidateUser("USER_TEST")
				.endOr()
				.orderByHistoricTaskInstanceEndTime()
				.desc()
				.list();

SELECT DISTINCT RES.* 
FROM   act_hi_taskinst RES 
WHERE  ( 1 = 1 
         AND RES.tenant_id_ IN ( ? ) ) 
       AND ( 1 = 1 
             AND RES.id_ IN (SELECT task_id_ 
                             FROM   act_hi_identitylink HIL 
                             WHERE  HIL.type_ = 'candidate' 
                                    AND HIL.user_id_ = ? 
                                    AND HIL.type_ = 'candidate' 
                                    AND HIL.group_id_ = ?) ) 
       AND ( RES.tenant_id_ IS NULL ) 
ORDER  BY RES.end_time_ DESC 
LIMIT  ? offset ?