I have a table that has the information about a log, to know how many hits there were on the pages of the website. 

This is the query that shows me the above:

```
select pageview_page, DATE(pageview_date) as pageview_date, count(*) as view_count
     from pageviews
      group by pageviews.pageview_page, DAY(pageviews.pageview_date)
      order by pageviews.pageview_date desc

```

Resulting in the following:

```
Page    Day        view_count
index   2016-01-12 50
index   2016-01-11 10
index   2016-01-10 20
contact 2016-01-12 5
contact 2016-01-11 5

```

**PD**: using `desc` on date because the chart must start on the latest date. 

**Notice:** in the above table, `contact` is not present on day `2016-01-10`, meaning no one used that page on that day.

**I want to get the query to show `0` if there is nothing on that date, how can I achieve that?** The result must be like the following

```
Page    Day        view_count
index   2016-01-12 50
index   2016-01-11 10
index   2016-01-10 20
contact 2016-01-12 5
contact 2016-01-11 5
contact 2016-01-10 0 <-------- (I want this to appear, as it is missing in the table above, in the first table)

```

Lets take the next 3 dates as an example: 2016-01-10, 2016-01-11, 2016-01-12

The point is to view the statistics by day, I use the next to get the dates above:

```
select DATE(pageview_date) as pageview_date from pageviews GROUP by DAY(pageview_date)

```

I have tried a combination with `IN` and `NOT IN` with the query above but I cant get it working.