There are at least two. Here is one.

SELECT r.dateorder, COUNT(r.id) AS count
FROM (
SELECT id,
FROM_UNIXTIME(timeregistered, '%Y%m') AS dateorder
FROM

Unknown macro: {hub_site_directory}

WHERE timeregistered > 0 AND
timeregistered < :thismonth
) r
GROUP BY r.dateorder
ORDER BY r.dateorder ASC