SELECT c.commentID, c.itemID, c.commentText, c.stamp, m.messageID, m.title, i.issueID, i.issue, u.userID, u.firstName, u.lastName, u.avatar, p.projectID, p.name as projName FROM #variables.tableprefix#comments c INNER JOIN #variables.tableprefix#projects p ON c.projectID = p.projectID LEFT JOIN #variables.tableprefix#messages m ON c.itemID = m.messageID AND c.type = 'msg' LEFT JOIN #variables.tableprefix#issues i ON c.itemID = i.issueID AND c.type = 'issue' LEFT JOIN #variables.tableprefix#users u ON c.userid = u.userid WHERE c.commentText like AND p.projectID IN () ORDER BY c.stamp desc SELECT f.fileID, f.title, f.categoryID, f.description, f.filename, f.serverfilename, f.filetype, f.filesize,f.uploaded,f.uploadedBy,u.firstName, u.lastName, fc.category, p.projectID, p.name as projName FROM #variables.tableprefix#files f INNER JOIN #variables.tableprefix#projects p ON f.projectID = p.projectID LEFT JOIN #variables.tableprefix#users u ON f.uploadedBy = u.userID LEFT JOIN #variables.tableprefix#categories fc on f.categoryID = fc.categoryID WHERE fc.type = 'file' AND (f.title like OR f.description like ) AND p.projectID IN () ORDER BY f.title asc 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.projectID, p.name as projName, 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 INNER 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 (i.issue like OR i.detail like ) AND p.projectID IN () SELECT u.userID,u.firstName,u.lastName,u.avatar,m.messageID,m.categoryID,m.milestoneID,m.title,m.message, m.allowcomments,m.stamp,ms.name,mc.category, p.projectID, p.name as projName, (SELECT count(commentID) FROM #variables.tableprefix#comments c where m.messageid = c.itemid and type = 'msg') as commentcount, (SELECT count(fileID) FROM #variables.tableprefix#file_attach fa where m.messageid = fa.itemid and fa.type = 'msg') as attachcount FROM #variables.tableprefix#messages m INNER JOIN #variables.tableprefix#projects p ON m.projectID = p.projectID LEFT JOIN #variables.tableprefix#categories mc ON m.categoryID = mc.categoryID LEFT JOIN #variables.tableprefix#users u ON u.userID = m.userID LEFT JOIN #variables.tableprefix#milestones ms ON m.milestoneid = ms.milestoneid WHERE mc.type = 'msg' AND (m.title like OR m.message like ) AND p.projectID IN () ORDER BY m.stamp desc SELECT milestoneid, m.projectID, m.name, m.description, dueDate, completed, m.forid, m.userid, u.firstName, u.lastName, p.projectID, p.name as projName FROM #variables.tableprefix#milestones m INNER JOIN #variables.tableprefix#projects p ON m.projectID = p.projectID LEFT JOIN #variables.tableprefix#users u ON m.forid = u.userid WHERE (m.name like OR m.description like ) AND p.projectID IN () SELECT p.projectID, p.name, p.description FROM #variables.tableprefix#projects p INNER JOIN #variables.tableprefix#project_users pu ON p.projectID = pu.projectID LEFT JOIN #variables.tableprefix#users u ON pu.userid = u.userid LEFT JOIN #variables.tableprefix#clients c on p.clientID = c.clientID WHERE (p.name like OR p.description like ) AND p.projectID IN () ORDER BY p.name SELECT s.fileID, s.issueID, s.title, s.description, s.filename, s.serverfilename, s.filetype, s.filesize,s.uploaded,s.uploadedBy,u.firstName, u.lastName, p.projectID, p.name as projName FROM #variables.tableprefix#screenshots s INNER JOIN #variables.tableprefix#issues i ON s.issueID = i.issueID INNER JOIN #variables.tableprefix#projects p ON i.projectID = p.projectID LEFT JOIN #variables.tableprefix#users u ON s.uploadedBy = u.userID WHERE (s.title like OR s.filename like OR s.description like ) AND p.projectID IN () SELECT t.todoID, t.todolistID, t.projectID, t.task, t.userID, t.rank, t.due, t.completed, tl.title, tl.description, u.firstName, u.lastName, p.projectID, p.name as projName FROM #variables.tableprefix#todos t INNER JOIN #variables.tableprefix#projects p ON t.projectID = p.projectID LEFT JOIN #variables.tableprefix#todolists tl ON t.todolistID = tl.todolistID LEFT JOIN #variables.tableprefix#users u ON t.userID = u.userID WHERE (t.task like OR tl.title like OR tl.description like ) AND p.projectID IN () ORDER BY tl.rank,tl.added,t.added