MySQL LEFT JOIN与GROUP BY和WHERE IN(子查询)

我有一张表，每个日期都有一些统计信息，我想在MySQL中列出.对于某些日期，将没有统计信息，因此结果应类似于以下内容:
2013-03-01:3
2013-03-02:2
2013-03-03:0
2013-03-04:1

I have one table with some statistics per date, which I want listed out with MySQL. For some dates there will be no statistics, so the result should look something like this:
2013-03-01: 3
2013-03-02: 2
2013-03-03: 0
2013-03-04: 1

我发现，可以使用单独的表格(包含所有可能的日期和LEFT JOIN)来解决0-零-的问题.到目前为止一切顺利.

I figured out that filling in the gaps with 0 -zero- could be solved with a separate table with all possible dates and LEFT JOIN. So far so good.

统计信息(展示次数)位于"campaigndata"表中:

The statistics (impressions) is in the table 'campaigndata':

id - int(11)
date - date
campaignid - int(11)
impressions - int(11)

但是我只想获取一些统计信息.更具体地说，我只希望来自"campaigndata"行中的"campaignid"位于表"campaignfilter"中且"campaigntype"设置为1的行(例如).

But I want to get only some of the statistics. To be more specific, I only want the rows from 'campaigndata' where 'campaignid' is in the table 'campaignfilter' with 'campaigntype' set to 1 (as an example).

这是表"campaignfilter":

This is the table 'campaignfilter':

id - int(11)
campaigntype - int(11)
campaignid - int(11)

有人知道如何做到这一点吗?

Anyone have clue how this could be done?

PS:"campaigndata"表的结构已被锁定，因为它是基于从外部系统自动导入的.

PS: The structure of table 'campaigndata' is pretty much locked, since it is based on an automatic import from an external system.

样品记录

CREATE TABLE demo_campaigndata (
  id int(11) NOT NULL AUTO_INCREMENT,
  date date NOT NULL,
  campaignid int(11) NOT NULL,
  impressions int(11) NOT NULL,
  PRIMARY KEY (id)
);
INSERT INTO demo_campaigndata (id, date, campaignid, impressions) VALUES
(1, '2013-03-03', 1, 100),
(2, '2013-03-03', 2, 100),
(3, '2013-03-03', 3, 100),
(4, '2013-03-04', 2, 100),
(5, '2013-03-05', 1, 100),
(6, '2013-03-05', 2, 100);


CREATE TABLE demo_campaignfilter (
  id int(11) NOT NULL AUTO_INCREMENT,
  campaigntype int(11) NOT NULL,
  campaignid int(11) NOT NULL,
  PRIMARY KEY (id)
);
INSERT INTO demo_campaignfilter (id, campaigntype, campaignid) VALUES
(1, 1, 1),
(2, 1, 3);


CREATE TABLE demo_calendar (
  date date NOT NULL,
  PRIMARY KEY (date)
);
INSERT INTO demo_calendar (date) VALUES
('2013-03-01'),
('2013-03-02'),
('2013-03-03'),
('2013-03-04'),
('2013-03-05');

期望结果

2013-03-01: 0
2013-03-02: 0
2013-03-03: 200
2013-03-04: 0
2013-03-05: 100