0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

select distinct top 1000 p.id, p.title, p.body, p.tags, a.body as answer
from posts p
inner join posttags pt on pt.postid = p.id
inner join tags t on pt.tagid = t.id
inner join posts a on a.id = p.acceptedAnswerId
where  t.tagname in ('windows', 'login')
and p.lastactivitydate > '2019-06-01'

fork query

edited jun 26 19

created jun 26 19 anonymous