WITH p AS ( SELECT '' id ), rg AS ( SELECT id, bdate, edate FROM sr_res_group WHERE is_system = FALSE AND current_date >= COALESCE ( bdate, '' ) AND current_date <= COALESCE ( edate, '' ) ) SELECT rg.id FROM p JOIN pim_employee_position_resource epr ON epr.employee_position_id = p.id JOIN sr_res_group_relationship rgr ON epr.id = rgr.resource_id AND current_date >= COALESCE ( rgr.bdatetime, '' ) AND current_date <= COALESCE ( rgr.edatetime, '' ) JOIN rg ON rgr.group_id = rg.id;