# This works pretty well, but if I change the status of a ticket it doesn't give me a new entrySELECT 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 updatesSELECT 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