SELECT
r.number AS number
,TO_CHAR(r.dat,'dd.mm.yyyy') AS dat
,UPPER(p.lastname) AS fam
,UPPER(p.firstname) AS im
,UPPER(p.secondname) AS ot
,TO_CHAR(p.birthdate, 'dd.mm.yyyy') AS bdate
,s.text
FROM
research r
LEFT OUTER JOIN patient p ON p.keyid = r.patient_id
LEFT OUTER JOIN orders o ON o.research_id = r.id
LEFT OUTER JOIN service s ON s.keyid = o.service_id
WHERE
TRUNC(r.dat) BETWEEN to_date('01.01.2020','dd.mm.yyyy') AND to_date('10.01.2020','dd.mm.yyyy')
AND o.service_id IN (
3403,
3404,
3405,
3406,
3409,
2359,
2360,
2361,
2362,
2723
)
ORDER BY s.text

AND o.service_id IN (
3403,
3404,
3405,
3406,
3409,
2359,
2360,
2361,
2362,
2723
)