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


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 as [Post Link]
     , a.score
     , a.creationdate
     , q.closeddate
from posts a
inner join posts q on = a.parentid
inner join posttags pt on pt.postid =
inner join tags t on = 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 desc

Enter Parameters

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