SELECT q.Id as [Post Link] ,
q.Score, users.Id, users.DisplayName, a.Score, q.AcceptedAnswerId
FROM posts q
INNER JOIN posts a ON (q.Id=a.ParentId)
LEFT JOIN users ON (q.OwnerUserId=users.Id)
INNER JOIN comments c on (a.Id=c.PostId)
WHERE a.Score >= 2
AND a.Score = ( SELECT MAX(p3.Score) FROM posts p3 WHERE p3.ParentId=q.Id )
AND users.Reputation < 15
AND q.PostTypeId = 1
AND q.AcceptedAnswerId is null
AND datediff(day, users.LastAccessDate, q.LastActivityDate) < 8
AND c.UserId = users.id
AND (c.Text LIKE '%hank%' OR c.Text LIKE '%preciate%' OR c.Text LIKE '%:)%')
GROUP BY q.Id, q.Score, users.Id, users.DisplayName, a.Score, q.AcceptedAnswerId