MySQL子查询LIMIT

SELECt  comments.comment_id,        comments.content_id,        comments.user_id,        comments.`comment`,        comments.comment_time,        NULLFROM    (        SELECt  content.content_id        FROM    content        WHERe   content.user_id = 1        LIMIT 10        ) qJOIN    commentsON      comments.content_id = q.content_id

您可能会希望将an添加

ORDER BY