SELECT case when status_type = 'c' then 'f' else 't' end FROM pm_task_status WHERE status_id = :task_status_id SELECT description, status_id FROM pm_project_status ORDER BY status_type desc, description