select distinct
sample0_.internal_nr as col_0_0_,
sample0_.state as col_1_0_,
sample0_.department_id as col_2_0_,
sample0_.biomaterial_id as col_3_0_,
sample0_.id as col_4_0_,
sample0_.end_date as col_5_0_,
sample0_.id as col_6_0_,
request9_.internal_nr as col_7_0_,
request9_.state as col_8_0_,
request9_.priority as col_9_0_,
request9_.delivered as col_10_0_,
request9_.sample_delivery_date as col_11_0_,
patient11_.code as col_12_0_,
patient11_.first_name as col_13_0_,
patient11_.middle_name as col_14_0_,
patient11_.last_name as col_15_0_,
patient11_.birthday as col_16_0_,
patient11_.birthdate_flags as col_17_0_,
request9_.sex as col_18_0_,
request9_.sampling_date as col_19_0_,
request9_.pregnancy_duration as col_20_0_,
request9_.cycle_period as col_21_0_,
request9_.hospital_id as col_22_0_,
request9_.custdepartment_id as col_23_0_,
request9_.doctor_id as col_24_0_,
request9_.category_id as col_25_0_,
sample0_.ts as col_26_0_,
sample0_.defect_names as col_27_0_,
sample0_.defect_state as col_28_0_,
sample0_.defect_processed as col_29_0_,
sample0_.department_nr as col_30_0_,
sample0_.activation_date as col_31_0_,
sample0_.department_nr_date as col_32_0_,
sample0_.cito as col_33_0_, request9_.external_nr as col_34_0_,
(select max(works26_.planned_date) from Work works26_ where sample0_.id=works26_.sample_id) as col_35_0_,
coalesce(patientcar12_.card_nr, request9_.patient_card_nr) as col_36_0_,
patient11_.patient_nr as col_37_0_
from Sample sample0_
inner join sample_targets targets1_
on sample0_.id=targets1_.sample_id
inner join Target target2_
on targets1_.target_id=target2_.id
inner join target_observing_departments observingd3_
on target2_.id=observingd3_.target_id
inner join Department department4_
on observingd3_.department_id=department4_.id
left outer join sample_profile_targets profiletar5_
on sample0_.id=profiletar5_.sample_id
left outer join Target target6_
on profiletar5_.target_id=target6_.id
left outer join target_observing_departments observingd7_
on target6_.id=observingd7_.target_id
left outer join Department department8_
on observingd7_.department_id=department8_.id inner join Request request9_
on sample0_.request_id=request9_.id inner join Patient patient11_
on request9_.patient_id=patient11_.id left outer join PatientCard patientcar12_
on request9_.patient_card_id=patientcar12_.id
where sample0_.removed=0
and request9_.sample_delivery_date>='20210122 00:00:00'
and request9_.sample_delivery_date<='20210122 23:59:59'
and (sample0_.department_id in (4250246) or department4_.id in (4250246))