SELECT c.Name, b.Name, a.DateDeleted FROM forum.comment_table AS a
LEFT JOIN forum.user_table AS b
ON a.DeleteUserID = b.UserID
LEFT JOIN forum.discussion_table AS c
ON a.DiscussionID = c.DiscussionID
WHERE a.Deleted='1'
AND a.DateDeleted>='2012-09-01 00:00:00'
AND a.DateDeleted<='2012-09-30 23:59:59'
AND a.AuthUserID in (
SELECT d.UserID FROM forum.user_table AS d
WHERE d.RoleID=2)
ORDER BY a.DateDeleted DESC;