Q&A for scientists using computers to solve scientific problems
select Comments.Id as [Comment Link], Comments.Score, Comments.CreationDate as CommentDate, a.CreationDate as PostDate, datediff(day, a.CreationDate, Comments.CreationDate) as Diff, Comments.Text from Comments join Posts a on Comments.PostId = a.Id inner join Posts q ON a.ParentId = q.Id where datediff(day, a.CreationDate, Comments.CreationDate) > 365 and q.ViewCount > 1000 and not Comments.UserId = a.OwnerUserId order by Comments.CreationDate desc