select `product_skus`.id as skuId, `wname` as sku名称,
if(`sku_attributes`.`status`=1,'上架','下架') as 状态,
(select name from brands where brands.id = product_skus.brand_id) as 品牌,
`sku_attributes`.`attribute_name` as 非价值属性, `sku_attributes`.`attribute_value_name` as 非价值属性值,
`product_attributes`.`attribute_name` as 价值属性,`product_attributes`.`attribute_value_name` as 价值属性值
from product_skus left join `sku_attributes` on `product_skus`.id = `sku_attributes`.sku_id and `sku_attributes`.`status` = 1
left join `product_attributes` on `product_skus`.product_id = `product_attributes`.product_id and `product_skus`.status = 1;
