-- ## 17: Shows user tickets that passed design review ## --

SELECT DISTINCT t.id as Ticket, t.summary as Summary, t.milestone as Milestone, t.owner as Owner, t.status as Status
   FROM ticket t, ticket_custom p
WHERE 
p.ticket = t.id and 
t.status = 's2c_design_ok' and ((p.name = 'design_owners' and p.value LIKE '%$USER%'))