As the title says, I wanted a workaround for this...
SELECT
comments.comment_id,
comments.content_id,
comments.user_id,
comments.`comment`,
comments.comment_time,
NULL
FROM
comments
WHERE
(comments.content_id IN (SELECT content.content_id FROM content WHERE content.user_id = 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 content
WHERE content.user_id = 1
LIMIT 10
) q
JOIN comments
ON comments.content_id = q.content_id
You probably will want to add an ORDER BY
into the nested query.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With