select
employees0_.EmployeeGroupSubselect_departmentName as Employee1_3_0_,
employees0_.EmployeeGroupSubselect_groupName as Employee2_3_0_,
employees0_.employees_id as employee3_3_0_,
employee1_.id as id1_1_1_,
employee1_.name as name2_1_1_
from
EmployeeGroupSubselect_Employee employees0_
inner join
Employee employee1_
on employees0_.employees_id=employee1_.id
where
employees0_.EmployeeGroupSubselect_departmentName=?
and employees0_.EmployeeGroupSubselect_groupName=?