Get PHP Answers


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 distinct top 1000, p.title, p.body, p.lastactivitydate, p.tags, a.body as answer
from posts p
inner join posttags pt on pt.postid =
inner join tags t on pt.tagid =
inner join posts a on = p.acceptedAnswerId
where  t.tagname in ('office') and p.lastactivitydate > '2019-01-01'
order by p.lastactivitydate desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results