| 1 |
2.98 ms |
SELECT t0.id AS id_1, t0.mrd_id AS mrd_id_2, t0.patient_category AS patient_category_3, t0.family_history AS family_history_4, t0.medical_history AS medical_history_5, t0.medicine_history AS medicine_history_6, t0.abha_number AS abha_number_7, t0.current_disease_history AS current_disease_history_8, t0.is_lab AS is_lab_9, t0.confirmed_diagnosis AS confirmed_diagnosis_10, t0.temparature AS temparature_11, t0.cns AS cns_12, t0.endrocine AS endrocine_13, t0.excretory AS excretory_14, t0.pulse AS pulse_15, t0.bp_upper AS bp_upper_16, t0.bp_lower AS bp_lower_17, t0.respiration AS respiration_18, t0.auscultation AS auscultation_19, t0.local_examination AS local_examination_20, t0.is_medicine AS is_medicine_21, t0.is_ward AS is_ward_22, t0.follow_up_date AS follow_up_date_23, t0.is_pm_done AS is_pm_done_24, t0.is_death_cert_gen AS is_death_cert_gen_25, t0.is_birth_cert_gen AS is_birth_cert_gen_26, t0.is_closed AS is_closed_27, t0.is_reopened AS is_reopened_28, t0.is_opinion AS is_opinion_29, t0.is_referral AS is_referral_30, t0.emergency_staff_notes AS emergency_staff_notes_31, t0.pharmacy_staff_notes AS pharmacy_staff_notes_32, t0.ward_staff_notes AS ward_staff_notes_33, t0.pharmacy_patient_notes AS pharmacy_patient_notes_34, t0.closure_reason AS closure_reason_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.lab_test_status AS lab_test_status_38, t0.case_medicine_status AS case_medicine_status_39, t0.ward_medicine_status AS ward_medicine_status_40, t0.hospital_id AS hospital_id_41, t0.patient_id AS patient_id_42, t0.doctor_id AS doctor_id_43, t0.prev_case_id AS prev_case_id_44, t0.disease_category_id AS disease_category_id_45, t0.icd10_cause_group_id AS icd10_cause_group_id_46, t0.icd10_cause_sub_group_id AS icd10_cause_sub_group_id_47, t0.icd10_disease_id AS icd10_disease_id_48, t49.id AS id_50, t49.is_surgery_advised AS is_surgery_advised_51, t49.is_complications AS is_complications_52, t49.status AS status_53, t49.discharge_reason AS discharge_reason_54, t49.is_for_pm AS is_for_pm_55, t49.discharge_note AS discharge_note_56, t49.created_at AS created_at_57, t49.updated_at AS updated_at_58, t49.case_id AS case_id_59, t49.ward_id AS ward_id_60, t0.created_by AS created_by_61, t0.updated_by AS updated_by_62, t63.id AS id_64, t63.baby_gender AS baby_gender_65, t63.is_abortion AS is_abortion_66, t63.bp_systolic AS bp_systolic_67, t63.bp_diastolic AS bp_diastolic_68, t63.baby_temp AS baby_temp_69, t63.uterus_pos AS uterus_pos_70, t63.nipple_pos AS nipple_pos_71, t63.delivery_type AS delivery_type_72, t63.baby_status AS baby_status_73, t63.baby_weight AS baby_weight_74, t63.is_cried_after_birth AS is_cried_after_birth_75, t63.is_passed_stool AS is_passed_stool_76, t63.is_diarrhea AS is_diarrhea_77, t63.is_pnemonia AS is_pnemonia_78, t63.is_preterm AS is_preterm_79, t63.is_asphaxia AS is_asphaxia_80, t63.is_malaria AS is_malaria_81, t63.is_congenital_detected AS is_congenital_detected_82, t63.is_injury AS is_injury_83, t63.is_mr AS is_mr_84, t63.is_ncd AS is_ncd_85, t63.is_vomitting AS is_vomitting_86, t63.is_activeness AS is_activeness_87, t63.respiration AS respiration_88, t63.is_diptheria AS is_diptheria_89, t63.is_tetanus AS is_tetanus_90, t63.is_pertusis AS is_pertusis_91, t63.is_meningitis AS is_meningitis_92, t63.is_aids AS is_aids_93, t63.is_convulsions AS is_convulsions_94, t63.is_breast_suckling AS is_breast_suckling_95, t63.is_chest_in_side AS is_chest_in_side_96, t63.is_jaundice AS is_jaundice_97, t63.umbilical_cord AS umbilical_cord_98, t63.is_sepsis AS is_sepsis_99, t63.other_complications AS other_complications_100, t63.is_bath_after_birth AS is_bath_after_birth_101, t63.remarks AS remarks_102, t63.created_at AS created_at_103, t63.case_id AS case_id_104, t63.ward_bed_id AS ward_bed_id_105, t63.danger_sign_id AS danger_sign_id_106, t63.child_id AS child_id_107, t63.child_case_id AS child_case_id_108, t109.id AS id_110, t109.brought_by AS brought_by_111, t109.office_letter_ref AS office_letter_ref_112, t109.date_brought AS date_brought_113, t109.examined_at AS examined_at_114, t109.id_mark1 AS id_mark1_115, t109.id_mark2 AS id_mark2_116, t109.created_at AS created_at_117, t109.case_id AS case_id_118, t119.id AS id_120, t119.corpse_sender AS corpse_sender_121, t119.place_corpse_sent AS place_corpse_sent_122, t119.place_corpse_sent_distance AS place_corpse_sent_distance_123, t119.corpse_bringer AS corpse_bringer_124, t119.corpse_identifier AS corpse_identifier_125, t119.exam_begun_at AS exam_begun_at_126, t119.exam_ended_at AS exam_ended_at_127, t119.accompany_report_substance AS accompany_report_substance_128, t119.place_examined AS place_examined_129, t119.distance_from_place AS distance_from_place_130, t119.why_not_sent_to_hospital AS why_not_sent_to_hospital_131, t119.sex_apparent_age_race_caste AS sex_apparent_age_race_caste_132, t119.desc_cloth_ornam AS desc_cloth_ornam_133, t119.cond_cloth AS cond_cloth_134, t119.special_marks_on_skin AS special_marks_on_skin_135, t119.newly_born_infant_details AS newly_born_infant_details_136, t119.body_condition AS body_condition_137, t119.regar_mortis AS regar_mortis_138, t119.decomp_signs_extents AS decomp_signs_extents_139, t119.features AS features_140, t119.skin_cond AS skin_cond_141, t119.external_genitals_injuries AS external_genitals_injuries_142, t119.limb_position AS limb_position_143, t119.surface_wounds_injuries AS surface_wounds_injuries_144, t119.cond_subcutaneous_tissues AS cond_subcutaneous_tissues_145, t119.other_injuries AS other_injuries_146, t119.sure_ante_mortem AS sure_ante_mortem_147, t119.head_injuries_under_scalp AS head_injuries_under_scalp_148, t119.skull_vault_base AS skull_vault_base_149, t119.brain_details AS brain_details_150, t119.thorax_walls_ribs_cartilages AS thorax_walls_ribs_cartilages_151, t119.pleura AS pleura_152, t119.larynx_trachea_bronchi AS larynx_trachea_bronchi_153, t119.right_lung AS right_lung_154, t119.left_lung AS left_lung_155, t119.pericardium AS pericardium_156, t119.heart AS heart_157, t119.large_vessels AS large_vessels_158, t119.heart_additional_remarks AS heart_additional_remarks_159, t119.abdomen_walls AS abdomen_walls_160, t119.peritoneum AS peritoneum_161, t119.cavity AS cavity_162, t119.bucal_cavity_teeth_tongue_pharynx AS bucal_cavity_teeth_tongue_pharynx_163, t119.desophagus AS desophagus_164, t119.stomach AS stomach_165, t119.small_intestine AS small_intestine_166, t119.large_intestine AS large_intestine_167, t119.liver_gall_bladder AS liver_gall_bladder_168, t119.pancreas_suprarenals AS pancreas_suprarenals_169, t119.spleen AS spleen_170, t119.kidneys AS kidneys_171, t119.bladder AS bladder_172, t119.generations_organs AS generations_organs_173, t119.stomach_additional_remarks AS stomach_additional_remarks_174, t119.retained_viscera_details AS retained_viscera_details_175, t119.spine_spinal_cord AS spine_spinal_cord_176, t119.death_cause_opinion AS death_cause_opinion_177, t119.created_at AS created_at_178, t119.updated_at AS updated_at_179, t119.case_id AS case_id_180, t119.created_by_id AS created_by_id_181, t119.updated_by_id AS updated_by_id_182, t183.id AS id_184, t183.immediate_cause AS immediate_cause_185, t183.antecedent_cause_b AS antecedent_cause_b_186, t183.antecedent_cause_c AS antecedent_cause_c_187, t183.other_significant_conditions AS other_significant_conditions_188, t183.on_set_interval AS on_set_interval_189, t183.how_injury_occurred AS how_injury_occurred_190, t183.manner_of_death AS manner_of_death_191, t183.is_pregnancy_death AS is_pregnancy_death_192, t183.is_delivery AS is_delivery_193, t183.died_at AS died_at_194, t183.created_at AS created_at_195, t183.updated_at AS updated_at_196, t183.case_id AS case_id_197, t183.created_by_id AS created_by_id_198, t183.updated_by_id AS updated_by_id_199, t200.id AS id_201, t200.reg_num AS reg_num_202, t200.created_at AS created_at_203, t200.updated_at AS updated_at_204, t200.case_id AS case_id_205, t200.created_by_id AS created_by_id_206, t200.updated_by_id AS updated_by_id_207 FROM cases t0 LEFT JOIN ward_beds t49 ON t49.case_id = t0.id LEFT JOIN delivery_details t63 ON t63.case_id = t0.id LEFT JOIN injured_info t109 ON t109.case_id = t0.id LEFT JOIN post_mortem_reports t119 ON t119.case_id = t0.id LEFT JOIN death_certificates t183 ON t183.case_id = t0.id LEFT JOIN birth_certificates t200 ON t200.case_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.mrd_id AS mrd_id_2,
t0.patient_category AS patient_category_3,
t0.family_history AS family_history_4,
t0.medical_history AS medical_history_5,
t0.medicine_history AS medicine_history_6,
t0.abha_number AS abha_number_7,
t0.current_disease_history AS current_disease_history_8,
t0.is_lab AS is_lab_9,
t0.confirmed_diagnosis AS confirmed_diagnosis_10,
t0.temparature AS temparature_11,
t0.cns AS cns_12,
t0.endrocine AS endrocine_13,
t0.excretory AS excretory_14,
t0.pulse AS pulse_15,
t0.bp_upper AS bp_upper_16,
t0.bp_lower AS bp_lower_17,
t0.respiration AS respiration_18,
t0.auscultation AS auscultation_19,
t0.local_examination AS local_examination_20,
t0.is_medicine AS is_medicine_21,
t0.is_ward AS is_ward_22,
t0.follow_up_date AS follow_up_date_23,
t0.is_pm_done AS is_pm_done_24,
t0.is_death_cert_gen AS is_death_cert_gen_25,
t0.is_birth_cert_gen AS is_birth_cert_gen_26,
t0.is_closed AS is_closed_27,
t0.is_reopened AS is_reopened_28,
t0.is_opinion AS is_opinion_29,
t0.is_referral AS is_referral_30,
t0.emergency_staff_notes AS emergency_staff_notes_31,
t0.pharmacy_staff_notes AS pharmacy_staff_notes_32,
t0.ward_staff_notes AS ward_staff_notes_33,
t0.pharmacy_patient_notes AS pharmacy_patient_notes_34,
t0.closure_reason AS closure_reason_35,
t0.created_at AS created_at_36,
t0.updated_at AS updated_at_37,
t0.lab_test_status AS lab_test_status_38,
t0.case_medicine_status AS case_medicine_status_39,
t0.ward_medicine_status AS ward_medicine_status_40,
t0.hospital_id AS hospital_id_41,
t0.patient_id AS patient_id_42,
t0.doctor_id AS doctor_id_43,
t0.prev_case_id AS prev_case_id_44,
t0.disease_category_id AS disease_category_id_45,
t0.icd10_cause_group_id AS icd10_cause_group_id_46,
t0.icd10_cause_sub_group_id AS icd10_cause_sub_group_id_47,
t0.icd10_disease_id AS icd10_disease_id_48,
t49.id AS id_50,
t49.is_surgery_advised AS is_surgery_advised_51,
t49.is_complications AS is_complications_52,
t49.status AS status_53,
t49.discharge_reason AS discharge_reason_54,
t49.is_for_pm AS is_for_pm_55,
t49.discharge_note AS discharge_note_56,
t49.created_at AS created_at_57,
t49.updated_at AS updated_at_58,
t49.case_id AS case_id_59,
t49.ward_id AS ward_id_60,
t0.created_by AS created_by_61,
t0.updated_by AS updated_by_62,
t63.id AS id_64,
t63.baby_gender AS baby_gender_65,
t63.is_abortion AS is_abortion_66,
t63.bp_systolic AS bp_systolic_67,
t63.bp_diastolic AS bp_diastolic_68,
t63.baby_temp AS baby_temp_69,
t63.uterus_pos AS uterus_pos_70,
t63.nipple_pos AS nipple_pos_71,
t63.delivery_type AS delivery_type_72,
t63.baby_status AS baby_status_73,
t63.baby_weight AS baby_weight_74,
t63.is_cried_after_birth AS is_cried_after_birth_75,
t63.is_passed_stool AS is_passed_stool_76,
t63.is_diarrhea AS is_diarrhea_77,
t63.is_pnemonia AS is_pnemonia_78,
t63.is_preterm AS is_preterm_79,
t63.is_asphaxia AS is_asphaxia_80,
t63.is_malaria AS is_malaria_81,
t63.is_congenital_detected AS is_congenital_detected_82,
t63.is_injury AS is_injury_83,
t63.is_mr AS is_mr_84,
t63.is_ncd AS is_ncd_85,
t63.is_vomitting AS is_vomitting_86,
t63.is_activeness AS is_activeness_87,
t63.respiration AS respiration_88,
t63.is_diptheria AS is_diptheria_89,
t63.is_tetanus AS is_tetanus_90,
t63.is_pertusis AS is_pertusis_91,
t63.is_meningitis AS is_meningitis_92,
t63.is_aids AS is_aids_93,
t63.is_convulsions AS is_convulsions_94,
t63.is_breast_suckling AS is_breast_suckling_95,
t63.is_chest_in_side AS is_chest_in_side_96,
t63.is_jaundice AS is_jaundice_97,
t63.umbilical_cord AS umbilical_cord_98,
t63.is_sepsis AS is_sepsis_99,
t63.other_complications AS other_complications_100,
t63.is_bath_after_birth AS is_bath_after_birth_101,
t63.remarks AS remarks_102,
t63.created_at AS created_at_103,
t63.case_id AS case_id_104,
t63.ward_bed_id AS ward_bed_id_105,
t63.danger_sign_id AS danger_sign_id_106,
t63.child_id AS child_id_107,
t63.child_case_id AS child_case_id_108,
t109.id AS id_110,
t109.brought_by AS brought_by_111,
t109.office_letter_ref AS office_letter_ref_112,
t109.date_brought AS date_brought_113,
t109.examined_at AS examined_at_114,
t109.id_mark1 AS id_mark1_115,
t109.id_mark2 AS id_mark2_116,
t109.created_at AS created_at_117,
t109.case_id AS case_id_118,
t119.id AS id_120,
t119.corpse_sender AS corpse_sender_121,
t119.place_corpse_sent AS place_corpse_sent_122,
t119.place_corpse_sent_distance AS place_corpse_sent_distance_123,
t119.corpse_bringer AS corpse_bringer_124,
t119.corpse_identifier AS corpse_identifier_125,
t119.exam_begun_at AS exam_begun_at_126,
t119.exam_ended_at AS exam_ended_at_127,
t119.accompany_report_substance AS accompany_report_substance_128,
t119.place_examined AS place_examined_129,
t119.distance_from_place AS distance_from_place_130,
t119.why_not_sent_to_hospital AS why_not_sent_to_hospital_131,
t119.sex_apparent_age_race_caste AS sex_apparent_age_race_caste_132,
t119.desc_cloth_ornam AS desc_cloth_ornam_133,
t119.cond_cloth AS cond_cloth_134,
t119.special_marks_on_skin AS special_marks_on_skin_135,
t119.newly_born_infant_details AS newly_born_infant_details_136,
t119.body_condition AS body_condition_137,
t119.regar_mortis AS regar_mortis_138,
t119.decomp_signs_extents AS decomp_signs_extents_139,
t119.features AS features_140,
t119.skin_cond AS skin_cond_141,
t119.external_genitals_injuries AS external_genitals_injuries_142,
t119.limb_position AS limb_position_143,
t119.surface_wounds_injuries AS surface_wounds_injuries_144,
t119.cond_subcutaneous_tissues AS cond_subcutaneous_tissues_145,
t119.other_injuries AS other_injuries_146,
t119.sure_ante_mortem AS sure_ante_mortem_147,
t119.head_injuries_under_scalp AS head_injuries_under_scalp_148,
t119.skull_vault_base AS skull_vault_base_149,
t119.brain_details AS brain_details_150,
t119.thorax_walls_ribs_cartilages AS thorax_walls_ribs_cartilages_151,
t119.pleura AS pleura_152,
t119.larynx_trachea_bronchi AS larynx_trachea_bronchi_153,
t119.right_lung AS right_lung_154,
t119.left_lung AS left_lung_155,
t119.pericardium AS pericardium_156,
t119.heart AS heart_157,
t119.large_vessels AS large_vessels_158,
t119.heart_additional_remarks AS heart_additional_remarks_159,
t119.abdomen_walls AS abdomen_walls_160,
t119.peritoneum AS peritoneum_161,
t119.cavity AS cavity_162,
t119.bucal_cavity_teeth_tongue_pharynx AS bucal_cavity_teeth_tongue_pharynx_163,
t119.desophagus AS desophagus_164,
t119.stomach AS stomach_165,
t119.small_intestine AS small_intestine_166,
t119.large_intestine AS large_intestine_167,
t119.liver_gall_bladder AS liver_gall_bladder_168,
t119.pancreas_suprarenals AS pancreas_suprarenals_169,
t119.spleen AS spleen_170,
t119.kidneys AS kidneys_171,
t119.bladder AS bladder_172,
t119.generations_organs AS generations_organs_173,
t119.stomach_additional_remarks AS stomach_additional_remarks_174,
t119.retained_viscera_details AS retained_viscera_details_175,
t119.spine_spinal_cord AS spine_spinal_cord_176,
t119.death_cause_opinion AS death_cause_opinion_177,
t119.created_at AS created_at_178,
t119.updated_at AS updated_at_179,
t119.case_id AS case_id_180,
t119.created_by_id AS created_by_id_181,
t119.updated_by_id AS updated_by_id_182,
t183.id AS id_184,
t183.immediate_cause AS immediate_cause_185,
t183.antecedent_cause_b AS antecedent_cause_b_186,
t183.antecedent_cause_c AS antecedent_cause_c_187,
t183.other_significant_conditions AS other_significant_conditions_188,
t183.on_set_interval AS on_set_interval_189,
t183.how_injury_occurred AS how_injury_occurred_190,
t183.manner_of_death AS manner_of_death_191,
t183.is_pregnancy_death AS is_pregnancy_death_192,
t183.is_delivery AS is_delivery_193,
t183.died_at AS died_at_194,
t183.created_at AS created_at_195,
t183.updated_at AS updated_at_196,
t183.case_id AS case_id_197,
t183.created_by_id AS created_by_id_198,
t183.updated_by_id AS updated_by_id_199,
t200.id AS id_201,
t200.reg_num AS reg_num_202,
t200.created_at AS created_at_203,
t200.updated_at AS updated_at_204,
t200.case_id AS case_id_205,
t200.created_by_id AS created_by_id_206,
t200.updated_by_id AS updated_by_id_207
FROM
cases t0
LEFT JOIN ward_beds t49 ON t49.case_id = t0.id
LEFT JOIN delivery_details t63 ON t63.case_id = t0.id
LEFT JOIN injured_info t109 ON t109.case_id = t0.id
LEFT JOIN post_mortem_reports t119 ON t119.case_id = t0.id
LEFT JOIN death_certificates t183 ON t183.case_id = t0.id
LEFT JOIN birth_certificates t200 ON t200.case_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.mrd_id AS mrd_id_2, t0.patient_category AS patient_category_3, t0.family_history AS family_history_4, t0.medical_history AS medical_history_5, t0.medicine_history AS medicine_history_6, t0.abha_number AS abha_number_7, t0.current_disease_history AS current_disease_history_8, t0.is_lab AS is_lab_9, t0.confirmed_diagnosis AS confirmed_diagnosis_10, t0.temparature AS temparature_11, t0.cns AS cns_12, t0.endrocine AS endrocine_13, t0.excretory AS excretory_14, t0.pulse AS pulse_15, t0.bp_upper AS bp_upper_16, t0.bp_lower AS bp_lower_17, t0.respiration AS respiration_18, t0.auscultation AS auscultation_19, t0.local_examination AS local_examination_20, t0.is_medicine AS is_medicine_21, t0.is_ward AS is_ward_22, t0.follow_up_date AS follow_up_date_23, t0.is_pm_done AS is_pm_done_24, t0.is_death_cert_gen AS is_death_cert_gen_25, t0.is_birth_cert_gen AS is_birth_cert_gen_26, t0.is_closed AS is_closed_27, t0.is_reopened AS is_reopened_28, t0.is_opinion AS is_opinion_29, t0.is_referral AS is_referral_30, t0.emergency_staff_notes AS emergency_staff_notes_31, t0.pharmacy_staff_notes AS pharmacy_staff_notes_32, t0.ward_staff_notes AS ward_staff_notes_33, t0.pharmacy_patient_notes AS pharmacy_patient_notes_34, t0.closure_reason AS closure_reason_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.lab_test_status AS lab_test_status_38, t0.case_medicine_status AS case_medicine_status_39, t0.ward_medicine_status AS ward_medicine_status_40, t0.hospital_id AS hospital_id_41, t0.patient_id AS patient_id_42, t0.doctor_id AS doctor_id_43, t0.prev_case_id AS prev_case_id_44, t0.disease_category_id AS disease_category_id_45, t0.icd10_cause_group_id AS icd10_cause_group_id_46, t0.icd10_cause_sub_group_id AS icd10_cause_sub_group_id_47, t0.icd10_disease_id AS icd10_disease_id_48, t49.id AS id_50, t49.is_surgery_advised AS is_surgery_advised_51, t49.is_complications AS is_complications_52, t49.status AS status_53, t49.discharge_reason AS discharge_reason_54, t49.is_for_pm AS is_for_pm_55, t49.discharge_note AS discharge_note_56, t49.created_at AS created_at_57, t49.updated_at AS updated_at_58, t49.case_id AS case_id_59, t49.ward_id AS ward_id_60, t0.created_by AS created_by_61, t0.updated_by AS updated_by_62, t63.id AS id_64, t63.baby_gender AS baby_gender_65, t63.is_abortion AS is_abortion_66, t63.bp_systolic AS bp_systolic_67, t63.bp_diastolic AS bp_diastolic_68, t63.baby_temp AS baby_temp_69, t63.uterus_pos AS uterus_pos_70, t63.nipple_pos AS nipple_pos_71, t63.delivery_type AS delivery_type_72, t63.baby_status AS baby_status_73, t63.baby_weight AS baby_weight_74, t63.is_cried_after_birth AS is_cried_after_birth_75, t63.is_passed_stool AS is_passed_stool_76, t63.is_diarrhea AS is_diarrhea_77, t63.is_pnemonia AS is_pnemonia_78, t63.is_preterm AS is_preterm_79, t63.is_asphaxia AS is_asphaxia_80, t63.is_malaria AS is_malaria_81, t63.is_congenital_detected AS is_congenital_detected_82, t63.is_injury AS is_injury_83, t63.is_mr AS is_mr_84, t63.is_ncd AS is_ncd_85, t63.is_vomitting AS is_vomitting_86, t63.is_activeness AS is_activeness_87, t63.respiration AS respiration_88, t63.is_diptheria AS is_diptheria_89, t63.is_tetanus AS is_tetanus_90, t63.is_pertusis AS is_pertusis_91, t63.is_meningitis AS is_meningitis_92, t63.is_aids AS is_aids_93, t63.is_convulsions AS is_convulsions_94, t63.is_breast_suckling AS is_breast_suckling_95, t63.is_chest_in_side AS is_chest_in_side_96, t63.is_jaundice AS is_jaundice_97, t63.umbilical_cord AS umbilical_cord_98, t63.is_sepsis AS is_sepsis_99, t63.other_complications AS other_complications_100, t63.is_bath_after_birth AS is_bath_after_birth_101, t63.remarks AS remarks_102, t63.created_at AS created_at_103, t63.case_id AS case_id_104, t63.ward_bed_id AS ward_bed_id_105, t63.danger_sign_id AS danger_sign_id_106, t63.child_id AS child_id_107, t63.child_case_id AS child_case_id_108, t109.id AS id_110, t109.brought_by AS brought_by_111, t109.office_letter_ref AS office_letter_ref_112, t109.date_brought AS date_brought_113, t109.examined_at AS examined_at_114, t109.id_mark1 AS id_mark1_115, t109.id_mark2 AS id_mark2_116, t109.created_at AS created_at_117, t109.case_id AS case_id_118, t119.id AS id_120, t119.corpse_sender AS corpse_sender_121, t119.place_corpse_sent AS place_corpse_sent_122, t119.place_corpse_sent_distance AS place_corpse_sent_distance_123, t119.corpse_bringer AS corpse_bringer_124, t119.corpse_identifier AS corpse_identifier_125, t119.exam_begun_at AS exam_begun_at_126, t119.exam_ended_at AS exam_ended_at_127, t119.accompany_report_substance AS accompany_report_substance_128, t119.place_examined AS place_examined_129, t119.distance_from_place AS distance_from_place_130, t119.why_not_sent_to_hospital AS why_not_sent_to_hospital_131, t119.sex_apparent_age_race_caste AS sex_apparent_age_race_caste_132, t119.desc_cloth_ornam AS desc_cloth_ornam_133, t119.cond_cloth AS cond_cloth_134, t119.special_marks_on_skin AS special_marks_on_skin_135, t119.newly_born_infant_details AS newly_born_infant_details_136, t119.body_condition AS body_condition_137, t119.regar_mortis AS regar_mortis_138, t119.decomp_signs_extents AS decomp_signs_extents_139, t119.features AS features_140, t119.skin_cond AS skin_cond_141, t119.external_genitals_injuries AS external_genitals_injuries_142, t119.limb_position AS limb_position_143, t119.surface_wounds_injuries AS surface_wounds_injuries_144, t119.cond_subcutaneous_tissues AS cond_subcutaneous_tissues_145, t119.other_injuries AS other_injuries_146, t119.sure_ante_mortem AS sure_ante_mortem_147, t119.head_injuries_under_scalp AS head_injuries_under_scalp_148, t119.skull_vault_base AS skull_vault_base_149, t119.brain_details AS brain_details_150, t119.thorax_walls_ribs_cartilages AS thorax_walls_ribs_cartilages_151, t119.pleura AS pleura_152, t119.larynx_trachea_bronchi AS larynx_trachea_bronchi_153, t119.right_lung AS right_lung_154, t119.left_lung AS left_lung_155, t119.pericardium AS pericardium_156, t119.heart AS heart_157, t119.large_vessels AS large_vessels_158, t119.heart_additional_remarks AS heart_additional_remarks_159, t119.abdomen_walls AS abdomen_walls_160, t119.peritoneum AS peritoneum_161, t119.cavity AS cavity_162, t119.bucal_cavity_teeth_tongue_pharynx AS bucal_cavity_teeth_tongue_pharynx_163, t119.desophagus AS desophagus_164, t119.stomach AS stomach_165, t119.small_intestine AS small_intestine_166, t119.large_intestine AS large_intestine_167, t119.liver_gall_bladder AS liver_gall_bladder_168, t119.pancreas_suprarenals AS pancreas_suprarenals_169, t119.spleen AS spleen_170, t119.kidneys AS kidneys_171, t119.bladder AS bladder_172, t119.generations_organs AS generations_organs_173, t119.stomach_additional_remarks AS stomach_additional_remarks_174, t119.retained_viscera_details AS retained_viscera_details_175, t119.spine_spinal_cord AS spine_spinal_cord_176, t119.death_cause_opinion AS death_cause_opinion_177, t119.created_at AS created_at_178, t119.updated_at AS updated_at_179, t119.case_id AS case_id_180, t119.created_by_id AS created_by_id_181, t119.updated_by_id AS updated_by_id_182, t183.id AS id_184, t183.immediate_cause AS immediate_cause_185, t183.antecedent_cause_b AS antecedent_cause_b_186, t183.antecedent_cause_c AS antecedent_cause_c_187, t183.other_significant_conditions AS other_significant_conditions_188, t183.on_set_interval AS on_set_interval_189, t183.how_injury_occurred AS how_injury_occurred_190, t183.manner_of_death AS manner_of_death_191, t183.is_pregnancy_death AS is_pregnancy_death_192, t183.is_delivery AS is_delivery_193, t183.died_at AS died_at_194, t183.created_at AS created_at_195, t183.updated_at AS updated_at_196, t183.case_id AS case_id_197, t183.created_by_id AS created_by_id_198, t183.updated_by_id AS updated_by_id_199, t200.id AS id_201, t200.reg_num AS reg_num_202, t200.created_at AS created_at_203, t200.updated_at AS updated_at_204, t200.case_id AS case_id_205, t200.created_by_id AS created_by_id_206, t200.updated_by_id AS updated_by_id_207 FROM cases t0 LEFT JOIN ward_beds t49 ON t49.case_id = t0.id LEFT JOIN delivery_details t63 ON t63.case_id = t0.id LEFT JOIN injured_info t109 ON t109.case_id = t0.id LEFT JOIN post_mortem_reports t119 ON t119.case_id = t0.id LEFT JOIN death_certificates t183 ON t183.case_id = t0.id LEFT JOIN birth_certificates t200 ON t200.case_id = t0.id WHERE t0.id = '2118';
|