0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for information security professionals

select top 100
       a.id as [Post Link]
     , a.score
     , q.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 t.tagname  = ##tag:string?apache-spark##
and a.ownerUserId = 1144035
order by a.id desc

fork query

edited mar 2 mck

created mar 2 rene