Revision history for posts with PostTypeid=7

0

Please login or register to vote for this query.

(click on this box to dismiss)

Electrical Engineering

Q&A for electronics and electrical engineering professionals, students, and enthusiasts

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 meta site
loading Hold tight while we fetch your results