Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT e.`entity_id`, ee_module.`module_summary` FROM `magento_store`.`catalog_product_entity_text` AS `descr_val`
- INNER JOIN `magento_store`.`catalog_product_entity` e ON e.`entity_id` = `descr_val`.`entity_id`
- INNER JOIN `magento_store`.`eav_attribute` AS `descr_attr` ON `descr_attr`.`attribute_code` = 'description' AND `descr_val`.`attribute_id` = `descr_attr`.`attribute_id`
- INNER JOIN `magento_store`.`eav_attribute` AS `old_id_attr` ON `old_id_attr`.`attribute_code` = 'old_id'
- 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`
- INNER JOIN `magentoc_live`.`mage_module` AS `ee_module` ON `ee_module`.`module_id` = `old_id_val`.`value`
- WHERE `descr_val`.`value` = ''
Add Comment
Please, Sign In to add comment