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 distinct PostTypeId -- Count(distinct id)as id,Count(distinct posttypeid)as ptid,Count(distinct AcceptedAnswerId)as aaid,Count(distinct ParentId)as pid,Count(distinct CreationDate)as cd,Count(distinct Score)as s,Count(distinct ViewCount)as vc,Count(distinct Body)as b,Count(distinct OwnerUserId)as ouid,Count(distinct OwnerDisplayName)as odn,Count(distinct LastEditorUserId)as leuid,Count(distinct LastEditorDisplayName)as ledn,Count(distinct LastEditDate)as led,Count(distinct LastActivityDate)as lad,Count(distinct Title)as t,Count(distinct Tags)as tags,Count(distinct AnswerCount)as ac,Count(distinct CommentCount)as cc,Count(distinct FavoriteCount)as fc,Count(distinct ClosedDate)as cd,Count(distinct CommunityOwnedDate)as cod
from Posts where Id in (select PostId from PostHistory) -- where PostId In (Select Id from Posts
-- where PostTypeId=5) -- and Lower(body) like '%data[- ]explorer%'

Enter Parameters

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