List users who post questions with input tags

1

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, Users.DisplayName, WebsiteURL, 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 WebsiteURL <>''
AND Users.Id NOT IN (1927832,85095,104998,136451,286630,5218,16050,478831,1189355,227046,46926,420558,445584,18103,959,22595,287316,1038830,970986,1440785,1499731,2443043,3580433,1589522,3437352,3553277,1711446,1732418,1766143,1783716,1796540,1874690,3683163,3739919,3787984,4034158,4035943,4154201,4436513,4481326,2450000,2459759,2513062,2546444,2623052,2672178,2786783,2837388,2943800,2962624,3065701,3078552,3117915,3149192,3172652,3225598,3358950,3387259,3406052,1542796,1548214,1585340,1479853,973122,975239,1048138,1055479,1070293,1077437,1113715,1124494,1134181,1150282,1159500,1165493,1183357,1946247,1993366,2014525,2064171,2067571,2096538,2104742,2105309,2136449,2138154,2170265,2210329,2323513,2392416,2420302,2422947,2427819,299176,301587,310852,320594,325704,328085,328397,330457,344293,346994,374476,378048,383217,398460,399113,407315,417792,418096,418609,141345,143942,146718,158766,170181,174527,176336,182462,187986,199148,219525,219586,107523,108234,111398,114066,114601,116951,118339,119925,129805,132127,133936,23109,24874,27211,29995,37416,40337,43418,88111,89818,91414,96613,97724,98094,98151,102207,104181,2138,543,751,18337,20654,6400,7345,7581,8946,9506,9922,12386,13986,15255,453214,477324,420613,435161,58251,58386,77222,229109,230419,243494,247230,263639,277683,278659,1198911,1225337,1227198,1239966,1268003,1293022,1296737,1346418,1360853,1369350,1379852,1387589,1393360,1432213,1434863,1436874,1438733,486504,488539,494571,500452,505893,507466,524547,539443,559720,577485,581164,601311,603732,606904,619895,626657,640913,642653,648138,648157,659417,681233,683501,707399,717442,745835,756422,762442,765488,766527,783287,784849,846488,852971,855950,866666,879451,900305,902172,923493,942391,942412,955836)
Group by Users.Id, Posts.Id, DisplayName, WebsiteURL 
Order by Users.Id

Enter Parameters

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