# This works pretty well, but if I change the status of a ticket it doesn't give me a new entry

SELECT id AS ticket, summary, component, status, severity, priority, owner,
   changetime AS modified, description AS _description_,
   time AS _time, reporter AS _reporter
  FROM ticket t,enum p
  WHERE p.name=t.priority AND p.type='priority'
  ORDER BY modified DESC


# Removing the WHERE statement above has a very strange effect. You get around a dozen entries per item, and not the desired updates

SELECT id AS ticket, summary, component, status, severity, priority, owner,
   changetime AS modified, description AS _description_,
   time AS _time, reporter AS _reporter
  FROM ticket t,enum p
  ORDER BY modified DESC