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 mymonths_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
   WHERE DATE_ADD('2014-04-01', INTERVAL (t3*100 + t2*10 + t1) MONTH) <= '2024-02-01'),
   editsbymonth AS (SELECT DATE_FORMAT(STR_TO_DATE(CAST(rev_timestamp AS CHAR), '%Y%m%d%H%i%s'), '%Y-%m') AS editsbymonth_month,
       COUNT(*) AS COUNT
FROM revision_userindex
JOIN actor ON rev_actor = actor_id
WHERE actor_name = 'ԱշոտՏՆՂ'
                    GROUP BY editsbymonth_month)
SELECT *
FROM editsbymonth
left join mymonths on mymonths_month = editsbymonth_month
SQL

Checking query status...
