/* select p.OwnerDisplayName as 'Name', count(p.PostTypeI...


Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

select p.OwnerDisplayName as 'Name',
       count(p.PostTypeId) as 'Count',
       u.EmailHash as 'EmailHash',
       u.Reputation as 'Rep'
from Posts p
join Users u on (p.OwnerUserId = u.id)
group by p.OwnerDisplayName, u.EmailHash, u.Reputation
having p.OwnerDisplayName is not null and p.OwnerDisplayName != ''
order by p.OwnerDisplayName

select top 2 * from Posts

select * from CloseReasonTypes

select * from PostTypes

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results