magento eav sql

piaoling  2011-07-25 11:01:13
SELECT `e`. * , `_table_color`.`value` AS `color`
FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_entity_int` AS `_table_color` ON ( _table_color.entity_id = e.entity_id )
AND (
_table_color.attribute_id = '272'
)
AND (
_table_color.store_id =0
)
WHERE (
(
_table_color.value
IN (
'24,11'
)
)
)
LIMIT 0 , 30
类别 :  magento(258)  |  浏览(3562)  |  评论(0)
发表评论(评论将通过邮件发给作者):

Email: