4 Task (in 1 query)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results