-- ## 14: Failed reviews ## --

-- Failed tickets with $USER ownership

SELECT DISTINCT t.id as Ticket, t.summary as Summary, t.status as Status, p.name as Owner
   FROM ticket t, ticket_custom p
INNER JOIN ticket_custom p2
ON p.ticket=p2.ticket
INNER JOIN ticket_custom p3
ON p.ticket=p3.ticket
WHERE 
p.ticket = t.id 
and ((p.name LIKE '%owners' and p.value LIKE '%$USER%')
and (p2.name LIKE '%score' and p2.value < '3' and p2.value > '0'))
and (p3.name = 'ticket_group' and p3.value = '')