Get questions with particular tags asked by specific user

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 
Users.Id, Posts.id AS [Post Link]
FROM 
Users, Posts
WHERE
Users.id = Posts.OwnerUserId
AND Posts.PostTypeId = 1
AND Posts.Tags LIKE '%##TAG1##%'
AND Posts.Tags LIKE '%##TAG2##%'
AND Posts.Tags NOT LIKE '%##EXCLUDEDTAG##%'
--AND Users.id = '##USERID##'
AND Users.id IN (4154201,2962624,3078552,973122,1124494,1360853,751,1113715,3117915,2104742)
ORDER BY Users.Id

Enter Parameters

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