1,sql查询发生在昨天的记录
SELECT * FROM `articles`
WHERE created_at>=(current_date - interval 1 day) and
created_at<=(current_date - interval 0 day)
2,关联表遍历分数最高的三条相关记录
表a,s
其中关联字段为a.id=s.article_id
取前三条记录sql语句为
SELECT * FROM `articles` a
JOIN (SELECT * FROM `scores` ORDER BY score DESC LIMIT 3)s
WHERE a.id = s.article_id