-- ## 11: Ticket Change History ## --

SELECT 
milestone AS __group__,
id AS ticket,  
summary,
version,
milestone,
t.time AS created, 
t.changetime AS modified,
t.type AS type,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner, 
tc.newvalue as _comments_,
'id="changelog"' as __style__

FROM ticket t 
LEFT OUTER JOIN ticket_change tc ON
   (t.id=tc.ticket AND field = 'comment')
WHERE t.milestone=$MILESTONE
ORDER BY id