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.

Q&A for anime and manga fans

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

fork query

edited jan 26 12 jrg

created nov 28 11 Chris S