SELECT s.fileID, s.title, s.description, s.filename, s.serverfilename, s.filetype, s.filesize,s.uploaded,s.uploadedBy,u.firstName, u.lastName FROM #variables.tableprefix#screenshots s LEFT JOIN #variables.tableprefix#users u ON s.uploadedBy = u.userID WHERE s.issueID = AND s.fileID = INSERT INTO #variables.tableprefix#screenshots (fileID, issueID, title, description, filename, serverfilename, filetype, filesize, uploaded, uploadedBy) VALUES(, , , , , , , , , ) UPDATE #variables.tableprefix#screenshots SET title = , description = WHERE issueID = AND fileID = DELETE FROM #variables.tableprefix#screenshots WHERE issueID = AND fileID = AND uploadedBy =