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 Users_Without_Questions_2015
FROM Users u
LEFT JOIN Posts p ON u.Id = p.OwnerUserId
LEFT JOIN PostTypes pt ON p.PostTypeId = pt.Id
WHERE YEAR(p.CreationDate) = 2015
    AND (pt.Name IS NULL OR pt.Name != 'Question');

fork query

created mar 27 anonymous