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 = '30' GROUP BY a.article_id
促销诺基亚N96_手机促销_指尖云商 - Powered by ECShop
用户评论(共0条评论)
暂时还没有任何用户评论