mysql查询语句记录

查询每一篇文章所属评论中最早评论的那一个的时间

SELECT b.`atid`,a.`pltime` 
FROM 
`pl` AS a 
LEFT JOIN 
`at` AS b 
ON 
(a.`platid`=b.`atid`) 
WHERE a.`platid` != '' 
GROUP BY b.`atid` 
ORDER BY a.`pltime` ASC 
LIMIT 50

查询文章中评论数量并按照评论数量排序

SELECT a.`atid`,COUNT(b.`plid`) AS `plcount`
FROM 
`at` AS a 
LEFT JOIN 
`pl` AS b 
ON 
(a.`atid`=b.`platid`) 
GROUP BY a.`atid` 
ORDER BY `plcount` ASC 
LIMIT 50