select count (p.Id) K from Posts p, Posts a where p.Post...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sitecore Meta

Q&A about the site for developers and end users of the Sitecore CMS and multichannel marketing software

select count (p.Id) K
from
Posts p, Posts a
    where  p.PostTypeId = 1
	  and a.PostTypeId = 2
	  and p.AcceptedAnswerId = a.Id
	  and p.OwnerUserId =  a.OwnerUserId 
    and p.CreationDate < '2014-10-08'
    and p.OwnerUserId is not null

Enter Parameters

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