DELETE FROM
eav_entity_attribute
WHERE
eav_entity_attribute.entity_type_id = (
select
entity_type_id
from
eav_entity_type
where
entity_type_code = 'catalog_product'
)
and
eav_entity_attribute.attribute_id
in
(
select
eav_attribute.attribute_id
from
eav_attribute
where
eav_attribute.entity_type_id = (
select
entity_type_id
from
eav_entity_type
where
entity_type_code = 'catalog_product'
)
and
(
eav_attribute.attribute_code = 'ts_dimensions_height'
or
eav_attribute.attribute_code = 'ts_dimensions_length'
or
eav_attribute.attribute_code = 'ts_dimensions_width'
)
);