SELECT * FROM DIARIES
WHERE

  RECORD_DELETED = 0

  AND WEB_ENABLED = 1 AND

 PRACTICE_ID = 1 AND
(
(
   ((INACTIVE = :INACTIVE OR INACTIVE is null) AND ACTIVE_TO is null))
OR
(( INACTIVE = :INACTIVE OR INACTIVE is null)
AND
  ACTIVE_FROM <= :ACTIVE_FROM AND
  ACTIVE_TO >= :ACTIVE_TO))
ORDER BY DIARY_NAME ASC