select t3.sku from catalog_category_entity_varchar as t1
left join catalog_category_product as t2 on t2.category_id=t1.entity_id
left join catalog_product_entity as t3 on t3.entity_id=t2.product_id
where t1.attribute_id=41 and t1.value='Tables';
[Magento SQL] 更加分类名称,查询该分类下所有的sku
最新推荐文章于 2019-10-21 22:33:17 发布