Untitled query #37234

SQL

SELECT
    calendar.month,
    COALESCE(COUNT(revision_userindex.rev_timestamp), 0) AS count
FROM
    (
        SELECT
            DATE_FORMAT(DATE_ADD('2000-01-01', INTERVAL (t3*100 + t2*10 + t1) MONTH), '%Y-%m') AS month
        FROM
            (SELECT 0 AS t1 UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) AS t1,
            (SELECT 0 AS t2 UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) AS t2,
            (SELECT 0 AS t3 UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) AS t3
    ) calendar
LEFT JOIN
    revision_userindex ON calendar.month = DATE_FORMAT(STR_TO_DATE(CAST(revision_userindex.rev_timestamp AS CHAR), '%Y%m%d%H%i%s'), '%Y-%m')
JOIN
    actor ON revision_userindex.rev_actor = actor.actor_id
WHERE
    actor.actor_name = 'ԱշոտՏՆՂ'
GROUP BY
    calendar.month;
SQL

Checking query status...
