They came, they asked, they never came back, not even for a quick word.
Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
-- Hit and Run -- They came, they asked, they never came back, not even for a quick word. -- Modified the query to find questions that are hit and run and have no answers and are not closed. SELECT U.ID as [User Link], P.Id As [Post Link], P.CreationDate, P.Score, P.ViewCount, P.CommentCount FROM Users As u INNER JOIN Posts As p ON u.Id = p.OwnerUserId WHERE u.LastAccessDate < p.CreationDate + 10 AND p.PostTypeId = 1 AND p.AnswerCount = 0 AND p.ClosedDate is Null --AND p.CommentCount < 2 --AND p.ViewCount < 500 --AND p.Score < 3 ORDER BY p.CreationDate