INSERT INTO `access_log` (`aid`, `site_id`, `count`, `date`) VALUES (‘10‘, ‘6‘, ‘111‘, ‘2016-03-09‘);

1 SELECT
2     w.`name`,
3     al.count,
4     al.date
5 FROM
6     websites AS w
7 RIGHT JOIN access_log AS al ON al.site_id = w.id
8 ORDER BY
9     al.count DESC;