0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT 
Posts.id
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##'

view current version

edited jun 30 15

created jun 30 15 Sarah.Nadi