0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

/*
SELECT COUNT(*)
FROM Users
WHERE WebsiteUrl IS NULL OR 
WebsiteUrl = '' OR Location IS NULL OR Location = '';
*/

SELECT COUNT(DISTINCT u.Id) AS NumberOfUsers
FROM Users u
LEFT JOIN Posts p ON u.Id = p.OwnerUserId AND YEAR(p.CreationDate) = 2015
LEFT JOIN PostTypes pt ON p.PostTypeId = pt.Id AND pt.Name = 'Question'
WHERE p.Id IS NULL;

fork query

edited mar 27

created mar 27 anonymous