SELECT posts.Id, posts.Body, answers.Body, posts.Tags FRO...

0

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 posts.Id, posts.Body, answers.Body, posts.Tags
FROM Posts posts
JOIN Posts answers ON posts.AcceptedAnswerId=answers.Id
WHERE 
(posts.Tags like '%<python>%' or 
posts.Tags like '%<scala>%') and 
posts.Tags like '%<algorithm>%'and
posts.CreationDate>Convert(datetime, '2015-01-01' )
ORDER BY posts.score DESC;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results