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

--MaxQScore: Max Question Score
declare @qscore INT = ##MaxQScore:INT?1##
--MaxAScore: Max Answer Score
declare @ascore INT = ##MaxAScore:INT?1##

select distinct top ##Top:int?500##
  p.Id as [Post Link],
  max(a.Score) as [Best Answer],
from Posts p
left join PostHistory ph on ph.postid =
left join Votes v on (v.PostId = p.Id and v.VoteTypeId = '10')
left join Posts a on p.Id = 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 not like '%' + ##TagsDoNotContain:string? ## + '%'
  --and p.ViewCount < ##ViewCount:int?20000##
  and datediff(d, p.ClosedDate, getdate()) >= 9
  and p.Score <= @qscore
  and (p.Score > 0 or a.Score > 0)
  -- post is not locked
  and coalesce((select top 1 PostHistoryTypeId
  from PostHistory
  where PostHistory.PostId = p.Id
    and PostHistory.PostHistoryTypeId in (14, 15) -- post locked, unlocked
  order by Id desc), 0) <> 14

group by p.Id, p.Score, p.CreationDate, p.ViewCount--, crt.Name
having count(v.VoteTypeId) = 0 and coalesce(max(a.Score),0) <= @ascore
order by p.Score, max(a.Score), CreationDate

select getdate() as [Time of query]

Enter Parameters

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