[cherie]

Thanks for clarifying. However, the query did not fail because of the location of the product name. Your implicit JOIN is interesting but not clear. I prefer this:

UPDATE xcart_products p JOIN xcart_products_lng_en pl ON pl.productid = p.productid
SET
  title_tag = pl.product,
  meta_keywords = pl.product,
  meta_description = pl.product