Show all types

0

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 10000 p1.Id, p1.AcceptedAnswerId, p1.CreationDate, p1.AnswerCount
from Posts p1
where
  p1.PostTypeId = 1
  and p1.CreationDate <'2009'
  order by rand()

Enter Parameters

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