tr.Created, at.id, at.Subject, at.Content, us.Name
FROM Tickets as tk, Transactions as tr, Users as us
LEFT OUTER JOIN Attachments as at ON tr.id=at.TransactionId
tr.Created, at.id, at.Subject, at.Content, us.Name
FROM Tickets as tk, Transactions as tr, Users as us
LEFT OUTER JOIN Attachments as at ON tr.id=at.TransactionId
#WHERE (tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>39896 AND tk.id<42241 AND ## (oct15th2008)
#WHERE (tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>40800 AND ## (1st3months)
#WHERE (tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>39896 AND tk.id<42241 AND ## (oct15th2008)
#WHERE (tk.Queue=22) AND tk.id=tr.ObjectId AND tk.id>40800 AND ## (1st3months)