Query strings having Syntax Problems

[C. M.]

I've received a couple of different errors that seem to manifest from the SQL string. Both SQL strings appear to be incorrectly structured with values outside of parens and quotes not closing.

......... SELECT t.id AS id,t.summary AS summary,t.priority AS priority,t.time AS time,t.changetime AS changetime,t.status AS status,t.owner AS owner,t.type AS type,priority.value AS priority_value,action_item.value AS action_item FROM ticket AS t LEFT OUTER JOIN ticket_custom AS action_item ON (id=action_item.ticket AND action_item.name='action_item') LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority) WHERE COALESCE(t.status,) IN (u'accepted',u'assigned',u'new',u'reopened') AND COALESCE(t.owner,)=u'username' AND COALESCE(t.type,)=u'task'

---

SELECT t.id AS id,t.summary AS summary,t.priority AS priority,t.time AS time,t.changetime AS changetime,t.'status AS 'status,priority.value AS priority_value,action_item.value AS action_item FROM ticket AS t LEFT OUTER JOIN ticket_custom AS action_item ON (id=action_item.ticket AND action_item.name='action_item') LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)WHERE COALESCE(t.'status,)!=u"closed'"