gistfile1.txt

SELECT * FROM (select date_format(now() - INTERVAL 12 MONTH,'%Y-%m') as month UNION select date_format(now() - INTERVAL 11 MONTH,'%Y-%m') as month UNION select date_format(now() - INTERVAL 10 MONTH,'%Y-%m') as month UNION select date_format(now() - INTERVAL 9 MONTH,'%Y-%m') as month UNION select date_format(now() - INTERVAL 8 MONTH,'%Y-%m') as month UNION select date_format(now() - INTERVAL 7 MONTH,'%Y-%m') as month UNION select date_format(now() - INTERVAL 6 MONTH,'%Y-%m') as month UNION select date_format(now() - INTERVAL 5 MONTH,'%Y-%m') as month UNION select date_format(now() - INTERVAL 4 MONTH,'%Y-%m') as month UNION select date_format(now() - INTERVAL 3 MONTH,'%Y-%m') as month UNION select date_format(now() - INTERVAL 2 MONTH,'%Y-%m') as month UNION select date_format(now() - INTERVAL 1 MONTH,'%Y-%m') as month) AS `t1` NATURAL LEFT JOIN (SELECT * FROM (SELECT date_format(`sent_at`, '%Y-%m') AS `month`, count(`job_mails`.`id`) AS `count` FROM `job_mails` WHERE (`sent_at` IS NOT NULL) GROUP BY `month`) AS `t1`) AS `t2`