SELECT DISTINCT a.id,a.name,`orgin_price`,`now_price`,`introduce`,`description`,`vp_score`,`cashback`,`cashback_r`,`default_imgurl`,`isvp`,`sell_count`,`is_free_shipping`,`is_supply_id` FROM weixin_commonshop_products a LEFT JOIN weixin_commonshop_types b ON type_id=b.id WHERE a.customer_id = 206 AND a.isvalid = 1 AND ( `type_id` = '943' OR b.parent_id = '943' ) AND `isout` = 0 ORDER BY asort_value desc LIMIT 0,12 二级列表
全部结果
更多选项
-
搜索
默认
|
销量
|
时间
|