All closed questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Italian Language Meta

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

select *

from posts p 
inner join posthistory ph on ph.postid = p.id
--inner join closereasontypes crt on crt.id = cast(ph.comment as tinyint)
INNER JOIN PostTags ON PostTags.PostId = p.id
INNER JOIN Tags ON PostTags.TagId = Tags.id
where Tags.TagName in (
'python'
--'elm'
--'clojure'
--'angularjs'
--'opengl'
--'c++'
)
and ph.posthistorytypeid = 10 -- Close event
and p.closeddate is not null  -- question is still closed
and p.posttypeid = 1 -- Question

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results