Untitled query #37234

SQL

SELECT
    calendar.month,
    COALESCE(COUNT(revision_userindex.rev_timestamp), 0) AS count
FROM
    (
        SELECT DISTINCT
            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 (
    SELECT
        DATE_FORMAT(STR_TO_DATE(CAST(rev_timestamp AS CHAR), '%Y%m%d%H%i%s'), '%Y-%m') AS month,
        rev_actor
    FROM
        revision_userindex
) AS revision_months ON calendar.month = revision_months.month
JOIN
    actor ON revision_months.rev_actor = actor.actor_id
WHERE
    actor.actor_name = 'ԱշոտՏՆՂ'
GROUP BY
    calendar.month;
SQL

Checking query status...
