SELECT a.activityID,a.projectID,a.type,a.id,a.name,a.activity,a.stamp, u.userid,u.firstName,u.lastName,p.projectID,p.name as projectName, 'red' as thiscolor , pu.files, pu.issues, pu.msgs, pu.mstones, pu.todos FROM #variables.tableprefix#activity a INNER JOIN #variables.tableprefix#projects p ON a.projectID = p.projectID INNER JOIN #variables.tableprefix#users u ON a.userID = u.userID INNER JOIN #variables.tableprefix#project_users pu ON u.userID = pu.userID AND pu.projectID = p.projectID WHERE 0=0 AND a.projectID = AND a.projectID IN ('#replace(arguments.projectIDlist,",","','","ALL")#') AND a.stamp > #DateAdd("m",-1,Now())# AND a.type = AND a.id = ORDER BY stamp desc SELECT a.activityID,a.projectID,a.type,a.id,a.name,a.activity,a.activity + ' by' as activityText,a.stamp, u.userid,u.firstName + ' ' + u.lastName as fullname,p.projectID,p.name as projectName FROM #arguments.tableprefix#activity a LEFT JOIN #arguments.tableprefix#projects p ON a.projectID = p.projectID INNER JOIN #arguments.tableprefix#users u ON a.userID = u.userID WHERE 0=0 AND a.projectID = AND a.stamp > #DateAdd("m",-1,Now())# ORDER BY a.[#arguments.sortcol#]stamp #arguments.sortdir#desc INSERT INTO #variables.tableprefix#activity (activityID,projectID,userid,type,id,name,activity,stamp) VALUES(, , , , , , , #Now()#) DELETE FROM #variables.tableprefix#activity WHERE 0=0 AND projectID = AND type = AND id =