SELECT COUNT(DISTINCT u.Id) AS UserCount FROM Users u INN...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

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

SELECT
    COUNT(DISTINCT u.Id) AS UserCount
FROM Users u
INNER JOIN Posts p on u.ID = p.OwnerUserID
WHERE 1=1
    AND u.Id <> -1

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results