Untitled query #37234

SQL

WITH MyMonths AS
  (SELECT DISTINCT DATE_FORMAT(DATE_ADD('2014-04-01', INTERVAL (t3*100 + t2*10 + t1) MONTH), '%Y-%m') AS MONTHA
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
                  WHERE DATE_ADD('2014-04-01', INTERVAL (t3*100 + t2*10 + t1) MONTH) <= '2024-02-01')
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 MyMonths on MyMonths.MONTHA = month
join actor on rev_actor = actor_id
where actor_name = 'ԱշոտՏՆՂ'
group by month;
SQL

Checking query status...
