SELECT c.commentID,c.itemID,c.commentText,c.stamp,u.userID,u.firstName,u.lastName,u.avatar FROM #variables.tableprefix#comments c LEFT JOIN #variables.tableprefix#users u ON c.userid = u.userid WHERE c.projectID = AND c.itemID = AND c.type = 'msg' AND c.itemID = AND c.type = 'issue' ORDER BY c.stamp desc INSERT INTO #variables.tableprefix#comments (commentID,projectID,type,itemID,userID,commentText,stamp) VALUES (, , , , , , #Now()#) DELETE FROM #variables.tableprefix#comments WHERE userID = AND commentID =