Invalid Case

9118

Array
(
    [id] => 9118
    [user_id] => 3754
    [region_id] => EMEA
    [country_id] => 69
    [patient_type] => 2
    [patient_id_number] => 12004255
    [patient_gender] => F
    [patient_birthdate] => 
    [patient_initials] => 
    [patient_informed_consent_release_file] => 71189
    [doctor_records_use_authorization_file] => 71188
    [profile_img] => 
    [create_user] => 
    [create_ts] => 2023-10-09 18:04:00
    [delete_user] => 
    [delete_ts] => 2024-08-08 17:12:30
)

SELECT  * FROM case_treatments WHERE  case_id = '9118'  AND delete_ts is null AND status IN ( 'PUBLISHED', 'NOTPUBLISHED', 'APPROVE' )  ORDER BY start_date ASC, end_date ASC, create_ts ASC 

Array
(
)