Crap Answers (link-only)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select a.Id as [Post Link], a.Body
from Posts a
INNER JOIN Posts p ON p.Id = a.ParentId
where p.OwnerUserId != a.OwnerUserId 
  and p.ClosedDate IS NULL
  and a.PostTypeId=2 
  and a.Score<=0 
--  and a.Body like '%<a href=%'
  and a.Body like '%check this%'
  and a.Id in
    (SELECT PostId 
      from Comments 
      where Text like '%While this link may answer the question, it is better to include the essential%')
order by LEN(a.Body)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results