SELECT AcademicProgramDetail.kAcadProgDetailID ,
  AcademicProgramDetail.fApplicationID ,
  AcademicProgramDetail.fStudentBusEntID ,
  AcademicProgramDetail.fSiteOrgUnitNumber ,
  AcademicProgramDetail.fStudyCentreBusEntID ,
  AcademicProgramDetail.fEnrolmentCategoryCodeID ,
  AcademicProgramDetail.fModuleAPID ,
  AcademicProgramDetail.fQualLevelAPID ,
  AcademicProgramDetail.fProgramAPID ,
  AcademicProgramDetail.ChoiceNo ,
  AcademicProgramDetail.IsConcurrent ,
  AcademicProgramDetail.ApplStartDate,
  AcademicProgramDetail.AcadProgCount ,
  AcademicProgramDetail.StartDate ,
  AcademicProgramDetail.EndDate ,
  AcademicProgramDetail.fPolicyPassedCodeID ,
  AcademicProgramDetail.PolicyReason ,
  AcademicProgramDetail.PolicyApplyDate ,
  AcademicProgramDetail.fPresentCatcodeID ,
  AcademicProgramDetail.isAcadApprovedByFaculty ,
  AcademicProgramDetail.LockStamp ,
  AcademicProgramDetail.AuditDateTime ,
  AcademicProgramDetail.fAuditSystemFunctionID ,
  AcademicProgramDetail.fAuditUserCode ,
  AcademicProgramDetail.IsAcceptanceTestPassed ,
  AcademicProgramDetail.fEnrolmentPresentationID ,
  AcademicProgramDetail.isSecondSemesterApp
FROM AcademicProgramDetail
WHERE fQualLevelAPID                IS NOT NULL
AND AcademicProgramDetail.StartDate >= '01/Jan/2018'
AND AcademicProgramDetail.EndDate   <= '31/Dec/2018'
AND fApplicationID                  IN
  (SELECT DISTINCT fApplicationID
  FROM StudyApplStatus
  WHERE fApplicationStatusCodeID IN (9671,9672,9698)
  )
AND AcademicProgramDetail.fStudentBusEntID              = 30270219
AND AcademicProgramDetail.fEnrolmentCategoryCodeID NOT IN (1000585)
ORDER BY AcademicProgramDetail.Kacadprogdetailid