Closed question roomba


Please login or register to vote for this query.

(click on this box to dismiss)

With great power comes great responsibility. See The check for reopen votes is usually too conservative, but votes should expire after 14 days at the most. This query excludes questions that are duplicate targets, even though the roomba would be willing to delete them.

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

select top 100 as [Post Link], p.score, count(v.votetypeid) as 'Delete Votes'
from posts p
left join posthistory ph on ph.postid =
left join votes v on (v.postid = and v.votetypeid = '10')
inner join posthistorytypes phn on = ph.posthistorytypeid
inner join posts a on = a.parentid
ph.comment != 1 and ph.comment != 101
and ph.posthistorytypeid = 10
and p.acceptedanswerid is null
and p.closeddate is not null
and p.tags like '%' + ##TagsContain:string?<source-code>## + '%'
and p.tags not like '%' + ##TagsDoNotContain:string?xyzzy## + '%'
and p.viewcount < ##ViewCount:int?2000##
and p.closeddate <= '2015-07-12'
and p.score >= ##MinScore:int?-10##
group by, p.score, v.votetypeid
having count(v.votetypeid) = 0 and max(a.score) <= 1
order by p.score asc

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results