0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists, academics, teachers, and students in the field of chemistry

select distinct top(10) p.id,p.creationdate, STUFF(
             (SELECT ',' + tagname 
              FROM tags t2
              join posttags pt2 on pt2.tagid=t2.id
              join posts p2 on pt2.postid=p2.id
              where p2.id=p.id and tagname='python'
              FOR XML PATH (''))
              , 1, 1, '')
from posts p
join posttags pt on pt.postid=p.id
join tags t1 on t1.id=pt.tagid
where year(p.creationdate) >= 2016

fork query

edited oct 20 17

created oct 20 17 anonymous