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
  q.Id,a.CreationDate
from
  Posts q,
  Posts a
where
  q.Id = a.ParentId and 
  a.postTypeId = 2 and 
  q.postTypeId = 1 and
  a.OwnerUserId = q.Id
order by q.Id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results