Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement