select p.Id AS [Post Link], p.body, p.creationdate from ...

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

-- Not an answer?
-- Targetting recent posts (within 30 days) that may not be answers. Marking these as not an answer may help achieve the Marshall badge. This is based on a pre-existing query by p.campbell.

select p.Id AS [Post Link], p.body, p.creationdate
from Posts as p
where posttypeid = 2
  and len(p.body)<200 
  and p.score < 1
  and body like '%?</p>'
order by p.id desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results