TagWikis

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

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

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