SELECT
  COUNT(*)
INTO
  :count 
FROM
  CaseRelationship 
WHERE 
  (
    
    (
      caseID = :caseID 
      OR relatedCaseID = :caseID 
    ) 
    AND 
    (
      relatedCaseID = :relatedCaseID 
      OR caseID = :relatedCaseID 
    ) 
  ) 
  AND 
  (
    statusCode = :statusCode 
    OR statusCode IS NULL 
  ) 
  AND 
  (
    
    (
      endDate >= :startDate 
      OR endDate IS NULL 
    ) 
    AND 
    (
      startDate <= :endDate 
      OR :endDate IS NULL 
    ) 
  ) 
  AND 
  (
    caseRelationshipID <> :caseRelationshipID 
    OR :caseRelationshipIDIsNull <> '0' 
  )