Guest User

Untitled

a guest
Feb 19th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.31 KB | None | 0 0
  1. SELECT e.`entity_id`, `ee_module`.`module_description` FROM `magento_store`.`catalog_product_entity_text` AS `descr_val`
  2. #UPDATE `magento_store`.`catalog_product_entity_text` AS `descr_val`
  3. INNER JOIN `magento_store`.`catalog_product_entity` e ON e.`entity_id` = `descr_val`.`entity_id`
  4. INNER JOIN `magento_store`.`eav_attribute` AS `descr_attr` ON `descr_attr`.`attribute_code` = 'description' AND `descr_val`.`attribute_id` = `descr_attr`.`attribute_id`
  5. INNER JOIN `magento_store`.`eav_attribute` AS `old_id_attr` ON `old_id_attr`.`attribute_code` = 'old_id'
  6. INNER JOIN `magento_store`.`catalog_product_entity_int` AS `old_id_val` ON `old_id_val`.`attribute_id` = `old_id_attr`.`attribute_id` AND `old_id_val`.`entity_id` = e.`entity_id`
  7. INNER JOIN `magentoc_live`.`mage_module` AS `ee_module` ON `ee_module`.`module_id` = `old_id_val`.`value`
  8. INNER JOIN `magento_store`.`eav_attribute` status_attr ON status_attr.`attribute_code` = 'extension_status' AND status_attr.`entity_type_id` = e.`entity_type_id`
  9. INNER JOIN `magento_store`.`catalog_product_entity_int` status_val ON status_val.`attribute_id` = status_attr.`attribute_id` AND status_val.`entity_id` = e.`entity_id`
  10. #SET `descr_val`.`value` = `ee_module`.`module_description`
  11. WHERE `descr_val`.`value` = '' AND `ee_module`.`module_description` > '' AND status_val.VALUE = 5
Add Comment
Please, Sign In to add comment