test

piaoling  2012-10-25 16:45:02
SELECT `default`.`entity_id`, `default`.`attribute_id`, `default`.`value` AS `default_value`, `store`.`value` AS `store_value`, IF(store.value_id>0, store.value, default.value) AS `value` FROM `catalog_product_entity_varchar` AS `default`
 LEFT JOIN `catalog_product_entity_varchar` AS `store` ON store.attribute_id=default.attribute_id
                AND store.entity_id=default.entity_id
                AND store.store_id=2 WHERE (default.entity_type_id=4) AND (default.entity_id in (866)) AND (default.attribute_id in ('60', '75', '76', '86', '100', '101', '102')) AND (default.store_id = 0) UNION SELECT `default`.`entity_id`, `default`.`attribute_id`, `default`.`value` AS `default_value`, `store`.`value` AS `store_value`, IF(store.value_id>0, store.value, default.value) AS `value` FROM `catalog_product_entity_text` AS `default`
 LEFT JOIN `catalog_product_entity_text` AS `store` ON store.attribute_id=default.attribute_id
                AND store.entity_id=default.entity_id
                AND store.store_id=2 WHERE (default.entity_type_id=4) AND (default.entity_id in (866)) AND (default.attribute_id in ('62')) AND (default.store_id = 0) UNION SELECT `default`.`entity_id`, `default`.`attribute_id`, `default`.`value` AS `default_value`, `store`.`value` AS `store_value`, IF(store.value_id>0, store.value, default.value) AS `value` FROM `catalog_product_entity_decimal` AS `default`
 LEFT JOIN `catalog_product_entity_decimal` AS `store` ON store.attribute_id=default.attribute_id
                AND store.entity_id=default.entity_id
                AND store.store_id=2 WHERE (default.entity_type_id=4) AND (default.entity_id in (866)) AND (default.attribute_id in ('64', '65')) AND (default.store_id = 0) UNION SELECT `default`.`entity_id`, `default`.`attribute_id`, `default`.`value` AS `default_value`, `store`.`value` AS `store_value`, IF(store.value_id>0, store.value, default.value) AS `value` FROM `catalog_product_entity_datetime` AS `default`
 LEFT JOIN `catalog_product_entity_datetime` AS `store` ON store.attribute_id=default.attribute_id
                AND store.entity_id=default.entity_id
                AND store.store_id=2 WHERE (default.entity_type_id=4) AND (default.entity_id in (866)) AND (default.attribute_id in ('66', '67', '81', '82')) AND (default.store_id = 0) UNION SELECT `default`.`entity_id`, `default`.`attribute_id`, `default`.`value` AS `default_value`, `store`.`value` AS `store_value`, IF(store.value_id>0, store.value, default.value) AS `value` FROM `catalog_product_entity_int` AS `default`
 LEFT JOIN `catalog_product_entity_int` AS `store` ON store.attribute_id=default.attribute_id
                AND store.entity_id=default.entity_id
                AND store.store_id=2 WHERE (default.entity_type_id=4) AND (default.entity_id in (866)) AND (default.attribute_id in ('84', '85', '111', '113', '114', '115', '116', '119', '120')) AND (default.store_id = 0)
类别 :  默认(706)  |  浏览(2416)  |  评论(0)
发表评论(评论将通过邮件发给作者):

Email: