select top 100 p.id, p.id [Post Link], p.body, h.* from p...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

select top 100 p.id, p.id [Post Link], p.body, h.*
from posts p
join posttypes pt on p.posttypeid=pt.id and pt.name='Answer'
join posthistory h on p.id = h.postid
where p.body like '%://svn.apache%'
and p.id = 11783104
;

Enter Parameters

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