Revision history for posts with PostTypeid=7

0

Please login or register to vote for this query.

(click on this box to dismiss)

Islam Meta

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

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=6)
---Where NOT (p.PostTypeId IN (1,2,3,4))
Order By CreationDate DESC

Enter Parameters

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