0

Please login or register to vote for this query.

(click on this box to dismiss)

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 (88111,488539,108234,942391,219525,2014525,942412,681233,13986,543,158766,2837388,2105309,15255,1438733,98094,581164,2096538,2170265,174527,1048138,277683,784849,717442,37416,1732418,24874,9506,2513062,325704,648138,1268003,8946,176336,1183357,955836)
ORDER BY Users.Id

view current version

edited jul 1 15

created jun 30 15 Sarah.Nadi