Questions unilateraly reopened by 200_success

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

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,'))

Enter Parameters

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