select employees0_.EmployeeGroup_departmentName as Employee1_1_1_,
employees0_.EmployeeGroup_groupName as Employee2_1_1_,
employees0_.employees_id as employee3_2_1_,
employee1_.id as id1_0_0_, employee1_.name as name2_0_0_
from EmployeeGroup_Employee employees0_
inner join Employee employee1_
on employees0_.employees_id=employee1_.id
where (employees0_.EmployeeGroup_departmentName, employees0_.EmployeeGroup_groupName) in (select employeegr0_.departmentName, employeegr0_.groupName from EmployeeGroup employeegr0_ where employeegr0_.departmentName=? and employeegr0_.groupName=? or employeegr0_.departmentName=? and employeegr0_.groupName=? or employeegr0_.departmentName=? and employeegr0_.groupName=?)