Crap Question Cleanup


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

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results