Crap Question Cleanup

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions with at least one delete vote already, and no answers.

The Great Outdoors

Q&A for people who love outdoor activities, excursions, and outdoorsmanship

-- 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 <1
and not exists (select * from posthistory ph where p.id = ph.postid and ph.posthistorytypeid = 18)
order by BodyLength

Enter Parameters

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