0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and power users of Windows Phone OS

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%'

fork query

edited may 2 12

created may 2 12 Mark Hurd