Adjust data populated by query function in google sheet

https://docs.google.com/spreadsheets/d/1H6VCXzfcXKfsAEI7ZjU66NUWtE2TdPQUKTUKYS2gN3I/edit#gid=1414263054

I’m using query function in sheet(consultations) to bring all rows from sheet(cases list) that have either of these criteria

1- If column Q (disposition) is “consultation”

2- If Column Q (disposition) is “admission” AND column S is not empty.

But I want the column S from the master sheet (cases list) to be copied to column R in consultation sheet if criteria 2 is matched.

I used this formula but I couldn’t modify

=query(CASES,"select C,E,F,G,H,I,J,K,L,P,R,S where Q = 'Consultation' OR Q='Admission' AND S<>'' order by R ASC",0)

Note: I renamed data range of cases list sheet as “CASES”.