您可以使用一个自连接来为每个具有最新注解的客户筛选注解表和行 date_updated ```
SELECT c.id AS vid, co.date_updated AS dts, co.id AS comments_id, co.*
FROM customer c
INNER JOIN comments co ON co.customer_id = c.id
LEFT JOIN comments co1 ON co.customer_id = co1.customer_id AND co.date_updated < co1.date_updated
WHERE co1.customer_id IS NULL AND c.id IN ('')

或内部连接

SELECT c.id AS vid, co.date_updated AS dts, co.id AS comments_id, co.*
FROM customer c
INNER JOIN comments co ON co.customer_id = c.id
INNER JOIN (
SELECT customer_id, MAX(date_updated) date_updated
FROM comments
GROUP BY customer_id
) co1 ON co.customer_id = co1.customer_id AND co.date_updated = co1.date_updated
WHERE c.id IN ('')

你忘了按条款订货

SELECT * FROM(
SELECT MAX(comments.`date_updated`), customer.id AS vid, comments.`date_updated` AS dts, comments.`id` AS comments_id, comments.* FROM customer
INNER JOIN comments ON comments.`customer_id` = customer.`id`
 WHERE customer.`id` IN ('')
) AS v
GROUP BY v.`vid` LIMIT 0,50
ORDER BY created_date desc;