sql查询昨天记录，遍历最高N条记录
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
