select distinct top 100 p.id as [Post Link] , creationdat...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select distinct top 100 
       p.id as [Post Link]
     , creationdate
from posts p
inner join posttags pt on pt.postid = p.id
inner join tags t on t.id = pt.tagid
and t.tagname like ##include:string## + '%'
and p.tags not like '%<' + ##exclude:string##  + '>%'
order by p.creationdate desc

Enter Parameters

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