SELECT a.*, IFNULL(AVG(r.comment_rank), 0) AS comment_rank FROM `xmrcnet_com`.`ecs_article` AS a LEFT JOIN `xmrcnet_com`.`ecs_comment` AS r ON r.id_value = a.article_id AND comment_type = 1 WHERE a.is_open = 1 AND a.article_id = '33' GROUP BY a.article_id
用户评论(共5条评论)
匿名用户 ( 2026-08-24 10:13:36 )
KliBqh
匿名用户 ( 2026-08-24 10:13:27 )
KliBqh
匿名用户 ( 2026-08-24 10:13:15 )
KliBqh
匿名用户 ( 2026-08-24 10:13:10 )
KliBqh
匿名用户 ( 2026-08-24 10:13:02 )
KliBqh