select top 1000 postid [Post Link] from posthistory ph in...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 1000 postid [Post Link]
from posthistory ph
inner join posts on posts.id = postid
where posthistorytypeid = 10
and comment = 103 -- need focus
and tags like '%<javascript>%'
and closeddate is not null -- still closed
order by closeddate desc

select *
from CloseReasonTypes

Enter Parameters

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