/* named HQL query SopDao.sopByInstanceUidAndBox */ select serviceobj0_.sak_service_object_pair as sak_service_object1_152_0_, series1_.sak_series as sak_series1_151_1_, study2_.sak_study as sak_study1_161_2_, exam4_.sak_exam as sak_exam1_48_3_, serviceobj0_.acquisition_date as acquisition_date2_152_0_, serviceobj0_.acquisition_time as acquisition_time3_152_0_, serviceobj0_.anatomical_orientation_type as anatomical_orienta4_152_0_, serviceobj0_.ind_available as ind_available5_152_0_, serviceobj0_.image_columns as image_columns6_152_0_, serviceobj0_.content_date as content_date7_152_0_, serviceobj0_.content_time as content_time8_152_0_, serviceobj0_.dt_created as dt_created9_152_0_, serviceobj0_.uid_created_tenant as uid_created_tenan10_152_0_, serviceobj0_.ind_deidentified as ind_deidentified11_152_0_, serviceobj0_.deidentified_header_guid as deidentified_head12_152_0_, serviceobj0_.echo_number as echo_number13_152_0_, serviceobj0_.frame_of_reference_uid as frame_of_referenc14_152_0_, serviceobj0_.image_laterality as image_laterality15_152_0_, serviceobj0_.image_orientation as image_orientation16_152_0_, serviceobj0_.image_position as image_position17_152_0_, serviceobj0_.image_type as image_type18_152_0_, serviceobj0_.instance_number as instance_number19_152_0_, serviceobj0_.instance_uid as instance_uid20_152_0_, serviceobj0_.manufacturer as manufacturer21_152_0_, serviceobj0_.md5 as md22_152_0_, serviceobj0_.dt_lastUpdated as dt_lastUpdated23_152_0_, serviceobj0_.number_of_frames as number_of_frames24_152_0_, serviceobj0_.object_version as object_version25_152_0_, serviceobj0_.original_unmodified as original_unmodifi26_152_0_, serviceobj0_.ind_pixel_data as ind_pixel_data27_152_0_, serviceobj0_.pixel_data_cache_key as pixel_data_cache_28_152_0_, serviceobj0_.pixel_spacing as pixel_spacing29_152_0_, serviceobj0_.reference_file as reference_file30_152_0_, serviceobj0_.guid as guid31_152_0_, serviceobj0_.resource_uri as resource_uri32_152_0_, serviceobj0_.image_rows as image_rows33_152_0_, serviceobj0_.series_id as series_id43_152_0_, serviceobj0_.sop_size as sop_size34_152_0_, serviceobj0_.sop_class as sop_class35_152_0_, serviceobj0_.sop_class_uid as sop_class_uid36_152_0_, serviceobj0_.transfer_syntax as transfer_syntax37_152_0_, serviceobj0_.transfer_syntax_uid as transfer_syntax_u38_152_0_, serviceobj0_.version as version39_152_0_, serviceobj0_.view_position as view_position40_152_0_, serviceobj0_.window_center as window_center41_152_0_, serviceobj0_.window_width as window_width42_152_0_, series1_.body_part_examined as body_part_examined2_151_1_, series1_.cached_series_xml as cached_series_xml3_151_1_, series1_.dt_created as dt_created4_151_1_, series1_.instance_uid as instance_uid5_151_1_, series1_.modality as modality6_151_1_, series1_.dt_lastUpdated as dt_lastUpdated7_151_1_, series1_.series_number as series_number8_151_1_, series1_.object_version as object_version9_151_1_, series1_.series_description as series_descriptio10_151_1_, series1_.cde_series_status as cde_series_status11_151_1_, series1_.sak_study as sak_study14_151_1_, series1_.version as version12_151_1_, series1_.viewable as viewable13_151_1_, study2_.accession_number as accession_number2_161_2_, study2_.additional_patient_history as additional_patient3_161_2_, study2_.body_part_examined as body_part_examined4_161_2_, study2_.dt_created as dt_created5_161_2_, study2_.uid_created_tenant as uid_created_tenant6_161_2_, study2_.dicom_study_id as dicom_study_id7_161_2_, study2_.dte_exam as dte_exam8_161_2_, study2_.exam_time as exam_time9_161_2_, study2_.ext_session_id as ext_session_id10_161_2_, study2_.guid as guid11_161_2_, study2_.sak_transfer_manifest as sak_transfer_mani44_161_2_, study2_.instance_uid as instance_uid12_161_2_, study2_.institution_name as institution_name13_161_2_, study2_.key_image_count as key_image_count14_161_2_, study2_.ind_master_delete as ind_master_delete15_161_2_, study2_.media_order as media_order16_161_2_, study2_.message as message17_161_2_, study2_.modality as modality18_161_2_, study2_.dt_lastUpdated as dt_lastUpdated19_161_2_, study2_.mrn_issuer as mrn_issuer20_161_2_, study2_.num_frames as num_frames21_161_2_, study2_.num_series as num_series22_161_2_, study2_.num_sops as num_sops23_161_2_, study2_.object_version as object_version24_161_2_, study2_.pacs_study_description as pacs_study_descri25_161_2_, study2_.dte_patient_dob as dte_patient_dob26_161_2_, study2_.patient_gender as patient_gender27_161_2_, study2_.patient_medical_record_number as patient_medical_r28_161_2_, study2_.patient_name as patient_name29_161_2_, study2_.pulled as pulled30_161_2_, study2_.purge_date as purge_date31_161_2_, study2_.ind_pushed_to_pacs as ind_pushed_to_pac32_161_2_, study2_.reason_for_visit as reason_for_visit33_161_2_, study2_.referring_physician as referring_physici34_161_2_, study2_.report as report35_161_2_, study2_.size_in_bytes as size_in_bytes36_161_2_, study2_.study_description as study_description37_161_2_, study2_.study_status as study_status38_161_2_, study2_.dt_upload as dt_upload39_161_2_, study2_.url as url40_161_2_, study2_.ind_user_auto_nominate as ind_user_auto_nom41_161_2_, study2_.user_id as user_id42_161_2_, study2_.version as version43_161_2_, exam4_.ind_archive as ind_archive2_48_3_, exam4_.dt_archived as dt_archived3_48_3_, exam4_.dt_created as dt_created4_48_3_, exam4_.uid_created_tenant as uid_created_tenant5_48_3_, exam4_.ind_deidentified as ind_deidentified6_48_3_, exam4_.sak_principal as sak_principal18_48_3_, exam4_.ind_expired as ind_expired7_48_3_, exam4_.dt_expired as dt_expired8_48_3_, exam4_.external_id as external_id9_48_3_, exam4_.guid as guid10_48_3_, exam4_.sak_import_manifest as sak_import_manife11_48_3_, exam4_.ind_master_delete as ind_master_delete12_48_3_, exam4_.dt_lastUpdated as dt_lastUpdated13_48_3_, exam4_.name as name14_48_3_, exam4_.sak_parent_exam as sak_parent_exam19_48_3_, exam4_.sak_patient as sak_patient20_48_3_, exam4_.cde_purge_status as cde_purge_status15_48_3_, exam4_.dt_purged as dt_purged16_48_3_, exam4_.version as version17_48_3_, exams3_.sak_study as sak_study1_161_0__, exams3_.sak_exam as sak_exam2_56_0__ from t_service_object_pair serviceobj0_ inner join t_series series1_ on serviceobj0_.series_id=series1_.sak_series inner join t_study study2_ on series1_.sak_study=study2_.sak_study inner join t_exam_study exams3_ on study2_.sak_study=exams3_.sak_study inner join t_exam exam4_ on exams3_.sak_exam=exam4_.sak_exam inner join t_box_folder boxfolders5_ on exam4_.sak_exam=boxfolders5_.sak_exam inner join t_box box6_ on boxfolders5_.sak_box=box6_.sak_box inner join t_transfer transferma7_ on exam4_.sak_import_manifest=transferma7_.sak_transfer where serviceobj0_.instance_uid=? and box6_.sak_box=? and boxfolders5_.ind_deleted=0 and (boxfolders5_.sak_folder is null) and (exam4_.cde_purge_status in ('LIVE' , 'DO_NOT_PURGE' , 'EXPIRED')) and exam4_.ind_master_delete=0 and (transferma7_.status is null or transferma7_.status<>'CANCELLED') order by study2_.dt_lastUpdated DESC