Show all types


Please login or register to vote for this query.

(click on this box to dismiss)

Show all values in known tables that map a type id to a type name.

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

select top 100 p1.Id, p1.AcceptedAnswerId, p1.CreationDate, p1.AnswerCount
from Posts p1
  p1.PostTypeId = 1
  and p1.CreationDate <'2009'
  order by rand()

Enter Parameters

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