SELECT UNIQUE INCIDENT.*, APPARENT_OUTCOME.APPARENT_OUTCOME_E_DESC, APPARENT_OUTCOME.APPARENT_OUTCOME_F_DESC, CAUSE_ANALYSIS_STATUS.CAUSE_ANALYSIS_STATUS_E_DESC, CAUSE_ANALYSIS_STATUS.CAUSE_ANALYSIS_STATUS_F_DESC, SUB_HSO.HSO_NAME AS SUB_HSO_NAME, SOURCE_HSO.HSO_NAME AS SOURCE_HSO_NAME, INCIDENT_STATUS.INCIDENT_STATUS_E_DESC, INCIDENT_STATUS.INCIDENT_STATUS_F_DESC, GRP_INCIDENT.NO_YES_IND_E_DESC AS GRP_INCIDENT_NO_YES_IND_E_DESC, GRP_INCIDENT.NO_YES_IND_F_DESC AS GRP_INCIDENT_NO_YES_IND_F_DESC, UNPLANNED_ADMISSION.NO_YES_IND_E_DESC AS UA_NO_YES_IND_E_DESC, UNPLANNED_ADMISSION.NO_YES_IND_F_DESC AS UA_NO_YES_IND_F_DESC, POTENTIAL_SEVERITY.NO_YES_IND_F_DESC AS PS_NO_YES_IND_E_DESC, POTENTIAL_SEVERITY.NO_YES_IND_F_DESC AS PS_NO_YES_IND_F_DESC, PATIENT_INFORMED.PATIENT_INFORMED_E_DESC, RECURRENCE_LIKELIHOOD.RECURRENCE_LIKELIHOOD_E_DESC, SPECIFIC_LOCATION.SPECIFIC_LOCATION_DESC, ICD_TP.TIME_PERIOD_E_DESC AS ICD_TIME_PERIOD_E_DESC, ICD_TP.TIME_PERIOD_F_DESC AS ICD_TIME_PERIOD_F_DESC, DETECTED_TP.TIME_PERIOD_E_DESC AS DETECTED_TIME_PERIOD_E_DESC, DETECTED_TP.TIME_PERIOD_F_DESC AS DETECTED_TIME_PERIOD_F_DESC, DWD.WEEK_DAY_E_DESC AS DWD_WEEK_DAY_E_DESC, DWD.WEEK_DAY_F_DESC AS DWD_WEEK_DAY_F_DESC, IWD.WEEK_DAY_E_DESC AS IWD_WEEK_DAY_E_DESC, IWD.WEEK_DAY_F_DESC AS IWD_WEEK_DAY_F_DESCFROM INCIDENT LEFT OUTER JOIN APPARENT_OUTCOME ON INCIDENT.APPARENT_OUTCOME_ID = APPARENT_OUTCOME.APPARENT_OUTCOME_ID LEFT OUTER JOIN CAUSE_ANALYSIS_STATUS ON INCIDENT.CAUSE_ANALYSIS_STATUS_ID = CAUSE_ANALYSIS_STATUS.CAUSE_ANALYSIS_STATUS_ID LEFT OUTER JOIN HSO SUB_HSO ON INCIDENT.SUBMITTING_HSO_ID = SUB_HSO.HSO_ID LEFT OUTER JOIN HSO SOURCE_HSO ON INCIDENT.SOURCE_HSO_ID = SOURCE_HSO.HSO_ID LEFT OUTER JOIN INCIDENT_STATUS ON INCIDENT.INCIDENT_STATUS_ID = INCIDENT_STATUS.INCIDENT_STATUS_ID LEFT OUTER JOIN NO_YES_IND GRP_INCIDENT ON INCIDENT.GROUP_INCIDENT_IND_ID = GRP_INCIDENT.NO_YES_IND_ID LEFT OUTER JOIN NO_YES_IND UNPLANNED_ADMISSION ON INCIDENT.UNPLANNED_ADMISSION_IND_ID = UNPLANNED_ADMISSION.NO_YES_IND_ID LEFT OUTER JOIN NO_YES_IND POTENTIAL_SEVERITY ON INCIDENT.POTENTIAL_SEVERITY_IND_ID = POTENTIAL_SEVERITY.NO_YES_IND_ID LEFT OUTER JOIN PATIENT_INFORMED ON INCIDENT.PATIENT_INFORMED_ID = PATIENT_INFORMED.PATIENT_INFORMED_ID LEFT OUTER JOIN RECURRENCE_LIKELIHOOD ON INCIDENT.RECURRENCE_LIKELIHOOD_ID = RECURRENCE_LIKELIHOOD.RECURRENCE_LIKELIHOOD_ID LEFT OUTER JOIN SPECIFIC_LOCATION ON INCIDENT.SPECIFIC_LOCATION_ID = SPECIFIC_LOCATION.SPECIFIC_LOCATION_ID LEFT OUTER JOIN TIME_PERIOD ICD_TP ON INCIDENT.INCIDENT_TIME_PERIOD_ID = ICD_TP.TIME_PERIOD_ID LEFT OUTER JOIN TIME_PERIOD DETECTED_TP ON INCIDENT.DETECTED_TIME_PERIOD_ID = DETECTED_TP.TIME_PERIOD_ID LEFT OUTER JOIN WEEK_DAY DWD ON INCIDENT.DETECTED_WEEK_DAY_ID = DWD.WEEK_DAY_ID LEFT OUTER JOIN WEEK_DAY IWD ON INCIDENT.INCIDENT_WEEK_DAY_ID = IWD.WEEK_DAY_ID INNER JOIN INCIDENT_FUNCTIONAL_AREA IFA ON INCIDENT.INCIDENT_ID = IFA.INCIDENT_IDWHERE INCIDENT.INCIDENT_ID IN (SELECT INCIDENT_FUNCTIONAL_AREA.INCIDENT_IDFROM FUNCTIONAL_AREAINNER JOIN INCIDENT_FUNCTIONAL_AREA ON FUNCTIONAL_AREA.FUNCTIONAL_AREA_ID = INCIDENT_FUNCTIONAL_AREA.FUNCTIONAL_AREA_IDWHERE INCIDENT_FUNCTIONAL_AREA.INCIDENT_ID IN (SELECT INCIDENT_FUNCTIONAL_AREA.INCIDENT_ID FROM INCIDENT_FUNCTIONAL_AREA INNER JOIN INCIDENT ON INCIDENT_FUNCTIONAL_AREA.INCIDENT_ID = INCIDENT.INCIDENT_ID)AND FUNCTIONAL_AREA.FUNCTIONAL_AREA_ID=1)