https://blog.csdn.net/u013227473/article/details/80991464
https://blog.csdn.net/Dax1n/article/details/81590910 sql中left join on 多个条件需要特殊注意之处
https://blog.csdn.net/minixuezhen/article/details/79763263 SQL语法——left join on 多条件
https://blog.csdn.net/joefany/article/details/79171543
MySQL日期相关函数
https://blog.csdn.net/wangziqiangai/article/details/49447075