Untitled query #37234

SQL

select    DATE_FORMAT(STR_TO_DATE(CAST(rev_timestamp AS CHAR), '%Y%m%d%H%i%s'), '%Y-%m') AS month,
    COUNT(*) AS count
from revision_userindex 
join actor on rev_actor = actor_id
where actor_name = 'ԱշոտՏՆՂ'
group by month;
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
SQL

Checking query status...
