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 (
AND (
WHERE (
LIMIT 0 , 30
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 (
)IN (
'24,11'
)LIMIT 0 , 30
发表评论(评论将通过邮件发给作者):