SELECT task.* FROM task WHERE ((deadlineDate >= '2010-03-09' OR status < 5) OR deadlineDate = '9999-00-00') ORDER BY deadlineDate ASC, deadlineDate ASC, priority ASCSELECT project, count(taskId) as taskCount FROM task WHERE project <> '' GROUP BY project ORDER BY project