posts closed since 2012 with reasons

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language

Q&A for linguists, teachers and students of the Ukrainian language

select top 100 concat ('http://stackoverflow.com/q/', posts.id) as question, posts.score, posts.viewcount, posts.closeddate, posthistory.comment as closereasonid 
from posthistory
join posts on posts.id = posthistory.postid
where posts.closeddate > '2012-09-01' 
and posts.closeddate < '2012-12-01'
and posthistorytypeid = 10
order by newid()

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results