Questions which are probably to delete

0

Please login or register to vote for this query.

(click on this box to dismiss)

For cleaning database

Moderators

Q&A for community managers, administrators, and moderators

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

select top 1000
  p.id as [Post Link],
  u.id as [User Link],
  u.Reputation,
  p.score as Score,
  LEN(p.Body) as BodyLength
from posts p
inner join users u on
  u.id = 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

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