·

813

· sivaschenko

DELETE FROM catalog_product_entity_int atr
WHERE atr.attribute_id NOT IN (
 SELECT attribute_id
 FROM eav_entity_attribute a
 WHERE a.attribute_set_id = (
 SELECT attribute_set_id
 FROM catalog_product_entity e
 WHERE e.entity_id = atr.entity_id
 )
);

Repeat this query for all attribute type tables.
All attribute type queries can be selected using following query:

SELECT concat('catalog_product_entity_', backend_type)
FROM eav_attribute
WHERE backend_type != 'static'
GROUP BY backend_type;

Can anybody advice how to perform this foreach in one query?

Related protips

Have a fresh tip? Share with Coderwall community!

Post

Post a tip

Sponsored by

#native_company#

#native_desc#

#native_cta#

Post a job for only 299ドル

Sponsored by #native_company# — Learn More