SELECT t.todoID,t.todolistID,t.projectID,t.task,t.userID,t.rank,t.due,t.completed, tl.title, p.projectID, p.name, u.firstName,u.lastName, count(tt.timetrackid) as numTimeTracks, sum(tt.hours) as numHours, count(c.commentid) as numComments FROM #variables.tableprefix#todos t LEFT JOIN #variables.tableprefix#todolists tl ON t.todolistID = tl.todolistID LEFT JOIN #variables.tableprefix#projects p ON tl.projectID = p.projectID LEFT JOIN #variables.tableprefix#users u ON t.userID = u.userID LEFT JOIN #variables.tableprefix#timetrack tt ON t.todoID = tt.itemid LEFT JOIN #variables.tableprefix#comments c ON t.todoID = c.itemID WHERE 0=0 AND t.projectID = AND t.projectID IN () AND todolistID = AND todoID = AND t.completed IS NOT NULL AND t.completed IS NULL AND t.userID = AND t.due < #CreateODBCDate(Now())# AND t.completed IS NULL AND t.due >= #CreateODBCDate(Now())# AND t.completed IS NULL AND t.due <= #DateAdd("m",arguments.limit,CreateODBCDate(Now()))# AND t.completed IS NOT NULL AND t.completed IS NULL GROUP BY p.name, p.projectID, tl.title, t.todoID,t.todolistID,t.projectID,t.task,t.userID,t.rank,t.added,t.due, t.completed,u.firstName,u.lastName ORDER BY #arguments.order_by# INSERT INTO #variables.tableprefix#todos (todoID,todolistID,projectID,task,userid,rank,added,due) VALUES (, , , , , 999, , NULL ) UPDATE #variables.tableprefix#todos SET task = , userID = , due = NULL WHERE projectID = AND todolistID = AND todoID = DELETE FROM #variables.tableprefix#todos WHERE projectID = AND todolistID = AND todoID = UPDATE #variables.tableprefix#todos SET rank = WHERE todoID = AND todolistID = UPDATE #variables.tableprefix#todos SET completed = NULL WHERE todoID = AND todolistID =