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, (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 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 m.projectID = AND m.messageID = AND m.categoryID = AND m.milestoneID = AND m.stamp between #createdate(arguments.y,arguments.m,'1')# AND #createDateTime(arguments.y,arguments.m,daysInMonth(createdate(arguments.y,arguments.m,'1')),'23','59','59')# AND mc.type = 'msg' ORDER BY m.stamp desc SELECT distinct u.userID, u.firstName, u.lastName, u.email, u.mobile, un.email_file_new, un.mobile_file_new, un.email_file_upd, un.mobile_file_upd, un.email_file_com, un.mobile_file_com, un.email_issue_new, un.mobile_issue_new, un.email_issue_upd, un.mobile_issue_upd, un.email_issue_com, un.mobile_issue_com, un.email_msg_new, un.mobile_msg_new, un.email_msg_upd, un.mobile_msg_upd, un.email_msg_com, un.mobile_msg_com, un.email_mstone_new, un.mobile_mstone_new, un.email_mstone_upd, un.mobile_mstone_upd, un.email_mstone_com, un.mobile_mstone_com, un.email_todo_new, un.mobile_todo_new, un.email_todo_upd, un.mobile_todo_upd, un.email_todo_com, un.mobile_todo_com, un.email_time_new, un.mobile_time_new, un.email_time_upd, un.mobile_time_upd, un.email_bill_new, un.mobile_bill_new, un.email_bill_upd, un.mobile_bill_upd, un.email_bill_paid, un.mobile_bill_paid, c.carrier, c.prefix, c.suffix FROM #variables.tableprefix#message_notify m LEFT JOIN #variables.tableprefix#users u ON m.userID = u.userID LEFT JOIN #variables.tableprefix#user_notify un ON u.userID = un.userID LEFT JOIN #variables.tableprefix#carriers c ON u.carrierID = c.carrierID WHERE m.projectID = AND m.messageID = SELECT distinct ms.milestoneid, ms.name FROM #variables.tableprefix#messages m LEFT JOIN #variables.tableprefix#milestones ms ON m.milestoneid = ms.milestoneid WHERE m.projectID = AND ms.name != '' SELECT distinct month(stamp) as m, year(stamp) as y FROM #variables.tableprefix#messages WHERE projectID = INSERT INTO #variables.tableprefix#messages (messageID,projectID,title,message,categoryID,milestoneID,allowcomments,userID,stamp) VALUES (, , , , , , , , ) UPDATE #variables.tableprefix#messages SET title = , message = , categoryid = , milestoneid = , allowcomments = WHERE projectid = AND messageid = DELETE FROM #variables.tableprefix#messages WHERE messageID = AND projectID = DELETE FROM #variables.tableprefix#comments WHERE itemID = AND projectID = DELETE FROM #variables.tableprefix#message_notify WHERE messageID = AND projectID = DELETE FROM #variables.tableprefix#file_attach WHERE itemID = AND type = 'msg' INSERT INTO #variables.tableprefix#message_notify (messageID,projectID,userID) VALUES (, , ) SELECT u.userID,u.email FROM #variables.tableprefix#message_notify mn LEFT JOIN #variables.tableprefix#users u ON mn.userID = u.userID WHERE messageID = AND projectID = DELETE FROM #variables.tableprefix#message_notify WHERE messageID = AND projectID = AND userID = SELECT c.categoryID, c.category, count(m.messageID) as numMsgs FROM #variables.tableprefix#categories c LEFT JOIN #variables.tableprefix#messages m ON c.categoryID = m.categoryID WHERE c.projectID = AND c.type = 'msg' GROUP BY c.categoryID, c.category ORDER BY c.category