1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select Id as [Post Link] from Posts p
where exists(
  select * from PostHistory ph
  where ph.PostId = p.Id
  and ph.PostHistoryTypeId = 11
  and ph.UserId = 3962914
  and substring(ph.text, 18, 8) = '3962914,')
and exists(
  select * from PostHistory ph
  where ph.PostId = p.Id
  and ph.PostHistoryTypeId = 10
  and (ph.UserId = 3732271
     or substring(ph.text, 18, 8) = '3732271,'))
order by p.LastActivityDate desc

fork query

edited aug 28 21 Oğuz

created aug 15 14 svick