1

Please login or register to vote for this query.

(click on this box to dismiss)

Вопросы и ответы о сайте для программистов

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

fork query

edited nov 11

created nov 11 Kamushek