select top 100 a.id as [Post Link] , a.score , a.creation...

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 100
       a.id as [Post Link]
     , a.score
     , a.creationdate
     , q.closeddate
from posts a
inner join posts q on q.id = a.parentid
inner join posttags pt on pt.postid = q.id
inner join tags t on t.id = pt.tagid
where a.posttypeid = 2
and q.posttypeid = 1
and q.closeddate is not null 
and a.body like '%##search##%'
and t.tagname  = ##tag:string?apache-spark##
order by a.id desc

Enter Parameters

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