select rev.creationdate, u.displayname, 1 from posts a in...

0

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 
  rev.creationdate,
  u.displayname,
  1
from posts a
inner join posthistory rev on rev.postid = a.id and rev.userid = a.owneruserid
inner join users u on rev.userid = u.id
inner join posts q on a.parentid = q.id and a.posttypeid = 2
inner join posttags pt on q.id = pt.postid
inner join tags t on t.id = pt.tagid
where t.tagname = 'cypress'
and a.owneruserid in (
4716245,
8745435,
9161752,
9622173,
12697177,
14783414,
14903560,
15239601,
15544695,
16003578,
16461847
)
order by rev.creationdate

Enter Parameters

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