test

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

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 = 3732271
  and substring(ph.text, 18, 8) = '3732271,')
and exists(
  select * from PostHistory ph
  where ph.PostId = p.Id
  and ph.PostHistoryTypeId = 10
  and (ph.UserId = 3962914
     or substring(ph.text, 18, 8) = '3962914,'))
order by p.LastActivityDate desc

Enter Parameters

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