Zur Info füge ich Ihnen den SQL-Text hier an:

-- 1. product_content_descriptions
SET SQL_SAFE_UPDATES = 0;
UPDATE
wernerscharinger_shopneu.product_content_descriptions a
JOIN wernerscharinger_shopneu.product_content_descriptions z ON a.product_content_ID=z.product_content_ID AND z.language_id=2
SET
a.title=z.title
WHERE
a.language_id <> 2 AND
a.title = ''
;


-- 2. product_content_resources
-- 2.1 Datensätze in product_content_resources vorhanden
SET SQL_SAFE_UPDATES = 0;
UPDATE
wernerscharinger_shopneu.product_content_resources target
JOIN
(
SELECT
r.product_content_description_id,
rs.resource
FROM
wernerscharinger_shopneu.product_content_descriptions d
JOIN wernerscharinger_shopneu.product_content_resources r ON d.id=r.product_content_description_id
JOIN wernerscharinger_shopneu.product_content_descriptions ds ON d.product_content_ID=ds.product_content_ID AND ds.language_id=2
JOIN wernerscharinger_shopneu.product_content_resources rs ON ds.id=rs.product_content_description_id
WHERE
r.resource='' AND d.language_id<>2
) source ON source.product_content_description_id = target.product_content_description_id
SET
target.resource=source.resource
;


-- 2.2 Keine Datensätze in product_content_resources
INSERT INTO wernerscharinger_shopneu.product_content_resources (
product_content_description_id,
product_content_types_id,
resource
)
SELECT
d.id AS product_content_description_id,
rs.product_content_types_id,
rs.resource
FROM
wernerscharinger_shopneu.product_content_descriptions d
LEFT OUTER JOIN wernerscharinger_shopneu.product_content_resources r ON d.id=r.product_content_description_id
JOIN wernerscharinger_shopneu.product_content_descriptions ds ON d.product_content_ID=ds.product_content_ID AND ds.language_id=2
JOIN wernerscharinger_shopneu.product_content_resources rs ON ds.id=rs.product_content_description_id
WHERE
r.resource IS NULL AND d.language_id<>2