Questions which are probably to delete


Please login or register to vote for this query.

(click on this box to dismiss)

For cleaning database


Q&A for community managers, administrators, and moderators

-- Questions which are probably to delete
-- For cleaning database

select top 1000 as [Post Link], as [User Link],
  p.score as Score,
  LEN(p.Body) as BodyLength
from posts p
inner join users u on = p.owneruserid
where p.posttypeid=1 
and p.score < 0
and u.reputation < 100 
and p.closeddate is null
and acceptedanswerid is null
and answercount = 0
order by BodyLength

Enter Parameters

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