insert into oc_product_attribute (product_id, attribute_id, language_id, text)
SELECT product_id, if(attr_new=-1, 798, if(attr_new=-2, 797, 796)), language_id, SUBSTRING_BY_INDEX(text, 'x', attr_new)
FROM oc_product_attribute, (SELECT -1 attr_new UNION SELECT -2 UNION SELECT -3) dummy
where `attribute_id` = 629
and `language_id` = 4
AND SUBSTRING_BY_INDEX(TEXT,  'x', attr_new) != '';

SELECT product_id, attribute_id, language_id, attr_new, SUBSTRING_BY_INDEX(text, 'x', attr_new) attr
FROM oc_product_attribute, (SELECT -2 attr_new) dummy
where `attribute_id` = 75
and `product_id` = 227
AND SUBSTRING_BY_INDEX(TEXT,  'x', attr_new) != ''
order by `product_id`

insert into oc_product_attribute (product_id, attribute_id, language_id, text)
SELECT product_id, if(attr_new=-2, 796), language_id, SUBSTRING_BY_INDEX(text, 'x', attr_new)
FROM oc_product_attribute, (SELECT -2 attr_new ) dummy
where `attribute_id` = 75
and `product_id` = 227
AND SUBSTRING_BY_INDEX(TEXT,  'x', attr_new) != '';