Question by userXYZ probably to flag

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

-- Question by userXYZ probably to flag
-- 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 < 10 
and p.closeddate is null
order by BodyLength

Enter Parameters

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