SELECT issueID, i.projectID, i.shortID, i.issue, i.detail, i.type, i.severity, i.status, i.created, i.createdBy, i.assignedTo, i.milestoneID, i.relevantURL, i.updated, i.updatedBy, i.resolution, i.resolutionDesc, p.name, c.firstName as createdFirstName, c.lastName as createdLastName, u.firstName as updatedFirstName, u.lastName as updatedLastName, a.firstName as assignedFirstName, a.lastName as assignedLastName, m.name as milestone FROM #variables.tableprefix#issues i LEFT JOIN #variables.tableprefix#projects p ON i.projectID = p.projectID LEFT JOIN #variables.tableprefix#users c ON i.createdBy = c.userID LEFT JOIN #variables.tableprefix#users u ON i.updatedBy = u.userID LEFT JOIN #variables.tableprefix#users a ON i.assignedTo = a.userID LEFT JOIN #variables.tableprefix#milestones m ON i.milestoneID = m.milestoneID WHERE 0=0 AND i.projectID = AND i.projectID IN ('#replace(arguments.projectIDlist,",","','","ALL")#') AND issueID = AND i.status IN ('#replace(arguments.status,"|","','","ALL")#') AND i.type = AND i.severity = AND i.assignedTo = AND i.milestoneID = SELECT count(*) as numTix FROM #variables.tableprefix#issues WHERE projectID = INSERT INTO #variables.tableprefix#issues (issueID, projectID, shortID, issue, detail, type, severity, status, assignedTo, milestoneID, relevantURL, created, createdBy) VALUES(, , '#arguments.ticketPrefix##qCountTix.numTix+1#', , , , , 'NewAccepted', , , , #Now()#, ) UPDATE #variables.tableprefix#issues SET projectID = , issue = , detail = , type = , severity = , assignedTo = , status = 'Accepted', status = 'New', milestoneID = , relevantURL = , updated = #Now()#, updatedBy = WHERE 0=0 AND issueID = UPDATE #variables.tableprefix#issues SET status = 'Accepted', assignedTo = , updated = #CreateODBCDateTime(Now())#, updatedBy = WHERE projectID = AND issueID = UPDATE #variables.tableprefix#issues SET status = 'New', assignedTo = '', updated = #CreateODBCDateTime(Now())#, updatedBy = WHERE projectID = AND issueID = UPDATE #variables.tableprefix#issues SET status = 'Resolved', resolution = , resolutionDesc = , updated = #CreateODBCDateTime(Now())#, updatedBy = WHERE projectID = AND issueID = UPDATE #variables.tableprefix#issues SET status = 'Closed', updated = #CreateODBCDateTime(Now())#, updatedBy = WHERE projectID = AND issueID = UPDATE #variables.tableprefix#issues SET status = 'Accepted', updated = #CreateODBCDateTime(Now())#, updatedBy = WHERE projectID = AND issueID =