Invalid Case

4996

Array
(
    [id] => 4996
    [user_id] => 1453
    [region_id] => APAC
    [country_id] => 65
    [patient_type] => 2
    [patient_id_number] => 7818121
    [patient_gender] => F
    [patient_birthdate] => 
    [patient_initials] => 
    [patient_informed_consent_release_file] => 34721
    [doctor_records_use_authorization_file] => 34720
    [profile_img] => 
    [create_user] => 
    [create_ts] => 2020-09-14 05:49:51
    [delete_user] => 
    [delete_ts] => 2024-08-08 17:12:30
)

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

Array
(
)