MySQL Subquery LIMIT -

As the title, I wanted an alternative solution for this ...

  Select the comment .comment_id, comments.content_id, comments.user_id, comments.comcomment`, comments.comment_time, where's the comments? (Comments.content_id IN (Choose content content_id from the content, where content is user1di = 1 LIMIT 0, 10))  

Cheers

  select comments.comment_id, Comments Content_id, comments.user_id, comments.comment`, comments.comment_time, NULL FROM (select content.content_id from the content where the content is content.user_id = 1 LIMIT 10) q comments.content_id = q.content_id  / pre> 
 Maybe you would like to add a  ORDER BY  to nested queries.