SELECT * FROM
  messages
WHERE status =
  'unread'
ORDER BY date;