sqlds

SELECT CASE WHEN `done` THEN 'done'
                            WHEN `done` = 0 AND `time` IS NOT NULL THEN 'timed'
                            ELSE 'other'
                            END AS 'task_type'
                        , ds_tasks.id
                        , ds_tasks.task
                        , ds_tasks.note
                        , ds_priorities.priority
                        , ds_priorities.css_class
                        , ds_tasks.DATE
                        , ds_tasks.TIME
                        , ds_tasks.done
                        FROM ds_tasks LEFT JOIN ds_priorities
                        ON ds_tasks.priority_id = ds_priorities.id
                        WHERE user_id = 1 AND `date` >= '2015-05-21' AND `date` <= '2015-05-29'
                        ORDER BY 'ds_tasks.time'