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 = '17' GROUP BY a.article_id
用户评论(共0条评论)
暂时还没有任何用户评论