Magento查询产品SKU和价格的SQL
时间:2017-04-03 23:39来源:未知 作者:最模板 点击:次
Magento查询产品SKU和价格的SQL, 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 t1.attribute_id=76 order by t2.sku 我这里 attribute_id=7
Magento查询产品SKU和价格的SQL,
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 t1.attribute_id=76 order by t2.sku
我这里 attribute_id=76是 Special Price
(责任编辑:最模板) |
------分隔线----------------------------