Most recent posts - testing

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT TOP(##num?100##)
  Id AS [Post Link],
  'site://q/' + CAST(id AS varchar) AS [Post URL],  
  OwnerUserId AS [User Link],
  'site://users/' + CAST(OwnerUserId AS varchar) AS [User URL],
  CreationDate, Score, Viewcount, Tags,
  CASE PostTypeId
    WHEN 1 THEN 'Question'
    WHEN 2 THEN 'Answer'
    WHEN 3 THEN 'Orphaned tag wiki'
    WHEN 4 THEN 'Tag wiki excerpt'
    WHEN 5 THEN 'Tag wiki'
    WHEN 6 THEN 'Moderator nomination'
    WHEN 7 THEN 'Wiki placeholder'
    WHEN 8 THEN 'Privilege wiki'    
  END  
FROM Posts  
ORDER BY Id DESC

Enter Parameters

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