0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

/*SELECT COUNT(*) AS IncompleteProfiles
FROM Users
WHERE WebsiteUrl IS NULL 
OR 
Location IS NULL 
*/

/*SELECT *
FROM PostTypes
WHERE Name = 'Question';
*/

SELECT COUNT(DISTINCT u.Id) AS UsersWithoutQuestions
FROM Users u
LEFT JOIN Posts p ON u.Id = p.OwnerUserId AND p.PostTypeId = 1 AND YEAR(p.CreationDate) = 2015
WHERE p.Id IS NULL

fork query

edited mar 27

created mar 27 anonymous