-- ## 46: Bugs with %USER in owners (not from M12) ## --

SELECT DISTINCT 'background: #99FF66;' as __style__, 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.type='bug' and (t.milestone NOT LIKE '%12%') and p.name LIKE '%owners' and p.value LIKE '%$USER%'