trac 1週間以内に変更された or 未解決

SELECT
(CASE status
WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'
ELSE
(CASE owner WHEN '$USER' THEN 'font-weight: bold' END)
END) AS __style__,
id AS ticket, summary, status,
resolution, changetime AS modified,
time AS _time,
component AS __group__
FROM ticket
WHERE strftime ("%%s", current_date) - 60*60*24*7 < changetime OR status IN ('new', 'assigned', 'reopened') ORDER BY component, -changetime