-- ## 10: Tickets Recently Updated ## -- -- -- * List top 50 tickets ordered by recently updated. -- * No coloring based on priority or anything else. SELECT date_format(from_unixtime(changetime), '%b %e %Y %a') as 'Updated When . . .', id AS ticket, summary, component, version, milestone, t.type AS type, owner, status, date_format(from_unixtime(time), '%b %e %Y') as 'Created When', description AS _description, reporter AS _reporter FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' ORDER BY changetime desc, p.value, milestone, t.type LIMIT 50