Вопросы и ответы о сайте для программистов
select top 50 displayname from (SELECT displayname from users u join posts p on u.id=p.owneruserid left join posttags pt1 on p.parentid=pt1.postid and pt1.tagid=17 left join posttags pt2 on p.parentid=pt2.postid and pt2.tagid=22 where u.reputation>100 and p.posttypeid=2 and (pt1.postid is not null or pt2.postid is not null) group by displayname having count(pt1.postid)>0 and count(pt2.postid)>0 ) x