-- ## 18: Current Buglist (OPEN only) - SQL Version ## --

SELECT
		p.value AS __color__,
		t.component AS __group__,
		t.id AS ticket, 
		CASE WHEN u.last_read_on > t.changetime/1000000 THEN '' ELSE 'UNREADMARK' END AS unread,
		t.summary AS summary,
		t.status AS status,
		t.type AS type,
		t.priority AS priority,
		t.milestone AS milestone,
		t.component AS component,
		t.severity AS severity,
		t.owner
	FROM ticket AS t
		LEFT OUTER JOIN enum AS p ON (p.type='priority' AND p.name=priority)
		LEFT JOIN trac_unread u ON (u.id=t.id AND u.type='ticket' AND u.username='$USER')
		LEFT JOIN version v ON (v.name=t.version) 

	WHERE t.status <> 'closed' AND t.type='Defect / Bug'
	ORDER BY t.component = '', t.component ASC, CAST(p.value AS integer) ASC, t.id ASC