/*查询所有产品的原价*/
SELECT t2.sku,t1.`value` from catalog_product_entity_decimal AS t1
LEFT JOIN catalog_product_entity AS t2 ON t2.entity_id = t1.entity_id
WHERE attribute_id=75
查询所有产品的原价的SQL
最新推荐文章于 2023-04-22 19:23:32 发布
/*查询所有产品的原价*/
SELECT t2.sku,t1.`value` from catalog_product_entity_decimal AS t1
LEFT JOIN catalog_product_entity AS t2 ON t2.entity_id = t1.entity_id
WHERE attribute_id=75