-- ## 12: mymy ## --

-- お試しか！

SELECT p.value AS __color__,
(CASE owner WHEN $USER THEN 'Owned' ELSE 'CC' END) AS __group__,
id AS ticket, summary, component, version, milestone,
t.type AS type, priority, time AS created,
changetime AS _changetime, description AS _description,
reporter AS _reporter
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE owner = $USER OR cc = $USER
-- # AND t.status <> 'closed' -- # 全チケットを対象にする場合はここを削除
ORDER BY (owner = $USER) DESC, p.value DESC, (status = 'assigned') DESC,time DESC