-- ## 26: Review ## --

SELECT DISTINCT t.id as Ticket, t.summary as Summary, t.milestone as Milestone, t.owner as Owner, t.status as Status, t.changetime as Modified
   FROM ticket t, ticket_custom p
WHERE 
p.ticket = t.id and 
t.status LIKE '%finished' and p.name='ticket_group' and p.value = ''
ORDER BY t.changetime