View source for Helpful MySQL Queries

===Number of users with data:===

====Total Users with data:====
<pre>
Select count(*) 
    AS 'Number of users with data'
From
(
SELECT
    COUNT(*) Col1
  FROM t_message tm
    INNER JOIN t_uuid_mapping tum ON tm.uuid_mapping_id = tum.uid_mapping_id
    INNER JOIN t_abook ta ON ta.f_uid = tum.f_uuid
    INNER JOIN t_domains td ON ta.domain_id = td.domain_id
  GROUP BY abook_id
)
AS t
GO
</pre>

To limit it to users less than 3 months or older than 3 months add
<pre>
HAVING DATEADD(S, MAX(f_stored), '1970-01-01') > '2017-02-01'
</pre>
underneath the GROUP BY clause.  Use > for newer than and < for older than.