select distinct top 50000 p.id, p.title, p.body, a.body a...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

select distinct top 50000 p.id, p.title, p.body, a.body as answer, a.score, p.tags
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 p.lastactivitydate > '2019-06-01'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results