select resourcegr2_.id as col_0_0_ from pim_employee_position_resource employeepo0_ inner join sr_resource employeepo0_1_ on employeepo0_.id=employeepo0_1_.id inner join sr_res_group_relationship grouprelat1_ on employeepo0_.id=grouprelat1_.resource_id inner join sr_res_group resourcegr2_ on grouprelat1_.group_id=resourcegr2_.id where employeepo0_.employee_position_id=$1 and resourcegr2_.is_system=false and (resourcegr2_.bdate is null or resourcegr2_.bdate<=CURRENT_DATE) and (resourcegr2_.edate is null or resourcegr2_.edate>=CURRENT_DATE) and (grouprelat1_.bdatetime is null or grouprelat1_.bdatetime<=CURRENT_DATE) and (grouprelat1_.edatetime is null or grouprelat1_.edatetime>=CURRENT_DATE)



select portalclin0_.id as col_0_0_ from pc_clinic portalclin0_ inner join md_clinic clinic1_ on portalclin0_.id=clinic1_.id where (clinic1_.scope_id not in  (select settingval2_.scope_id from cmn_setting_value settingval2_ inner join cmn_setting setting3_ on settingval2_.setting_id=setting3_.id inner join cmn_setting_to_scope_type scopetypes4_ on setting3_.id=scopetypes4_.setting_id inner join cmn_scope_type scopetype5_ on scopetypes4_.scope_type_id=scopetype5_.id where setting3_.code='cz.atria.md.planning.PlanningSettings.useRegClinicScope' and scopetype5_.code='Clinic' and settingval2_.value='true')) and (exists (select 1 from sr_scgenerated schedulege6_ cross join sr_service service7_ where schedulege6_.service_id=service7_.id and service7_.org_id=portalclin0_.id and schedulege6_.date>=$1 and schedulege6_.date<=$2))