List Active Patients and Web Flag

SELECT
  CASE Px.Approval_Status
    WHEN 1 THEN 'Web Pending'    -- Waiting Approval
    WHEN 2 THEN 'Web Approved'   -- Approved
    WHEN 3 THEN 'Web Merged'     -- Web Record deprecated
    WHEN 4 THEN 'Web Removed'
    WHEN 5 THEN 'Web Merged To'  -- Approved
  ELSE
    'Web Missing'
  END Status,
  PX.WEBSITE_PID,
  Px.Created_Date,
  Px.*
FROM
  Patients PX
--  left join Patients PX2 on PX2.WEBSITE_PID = PX.WEBSITE_PID
WHERE
  PX.RECORD_DELETED = 0

  AND (PX.CREATED_DATE > TO_DATE('31/12/2012', 'DD/MM/YYYY') AND
       PX.CREATED_DATE < TO_DATE('31/12/2015', 'DD/MM/YYYY'))

  AND PX.DECEASED = 0
--  AND (PX.Approval_Status is NULL or PX.Approval_Status in (2,5))
--  AND (PX.Approval_Status is NULL or PX.Approval_Status in (2,5))


  -- Filter by Patient type
--  AND Px.WEBSITE_PID IS NOT NULL
--  AND Px.WEBSITE_PID IS NULL


  -- Filter by Practice
  AND PX.PRACTICE_ID = 1

ORDER BY
--  Px.Created_Date, Px.surname
PX.WEBSITE_PID