Revision history for posts with PostTypeid=7

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

Select TOP(##num?5000##)
  p.Id as [Post Link], p.CreationDate,
  p.PostTypeId, url = 'site://posts/' + CAST(p.Id AS varchar)+'/revisions'
From Posts p 
Where (p.PostTypeId=8)
---Where NOT (p.PostTypeId IN (1,2,3,4))
Order By CreationDate DESC

Enter Parameters

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