SELECT AVG(Reputation) from Users; SELECT COUNT(Id) from ...

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 AVG(Reputation) from Users;
SELECT COUNT(Id) from Users;
SELECT COUNT(Id) from Comments;
SELECT COUNT(Id) from Posts;
SELECT COUNT(Id) from Posts where PostTypeId = 1;
SELECT COUNT(Id) from Posts where PostTypeId = 2;
SELECT SUM(totalPosts) totalPosts
FROM
        ( 
            select count(Id) totalPosts from Posts where PostTypeId = 1
            UNION ALL
            select count(Id) totalPosts from Posts where PostTypeId = 2
        ) s;
SELECT SUM(CAST(daysActive AS BIGINT)) daysActive
FROM
        (
        SELECT DATEDIFF (day,CreationDate,LastAccessDate) daysActive from Users
        ) r;

Enter Parameters

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