0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for peer programmer code reviews

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 = 9357
  and substring(ph.text,18, 5) = '9357,')
and exists(
  select * from PostHistory ph
  where ph.PostId = p.Id
  and ph.PostHistoryTypeId = 10
  and (ph.UserId != 9357
     or substring(ph.text,18, 5) != '9357,'))

fork query

edited aug 15 14

created aug 15 14 svick