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 = '4' GROUP BY a.article_id
联系我们_网店信息_系统分类_指尖云商 - Powered by ECShop
