...
JOIN `oc_product_attribute` pat ON pat.text = pat.text

product_id        | 102           | 102           
language_id      | 4              | 1               
name               | Вытяжка    | Вытяжка    
description        | ........        | ........

product_id         | 102                             | 102                             | 102
attribute_id        | 2                                | 2                                | 3 
language_id       | 4                                 | 1                               | 4
text                  | встраиваемая в шкаф    | встраиваемая в шкаф   | серый

attribute_id    |  2           | 2                 | 3
language_id   | 4            | 1                 | 4
name            | Установка | Установка   | Цвет

select 
  concat( 
  'Вы можете приобрести "', pd.name, "' с гарантией от производителя',
  ' "', max(case when ad.attribute_id=2 then ad.name end), '" ',
  ' "', max(case when ad.attribute_id=2 then pa.text end), '" ',
  ' и ',
  ' "', max(case when ad.attribute_id=3 then ad.name end), '" ',
  ' "', max(case when ad.attribute_id=3 then pa.text end), '" ') as xz
  
from oc_product_description pd 
inner join oc_product_attribute pa on pd.product_id=pa.product_id and pd.language_id=pa.language_id
inner join oc_attribute_description ad on pa.attribute_id=ad.attribute_id and pa.language_id=ad.language_id

where pd.language_id=4
  and pa.attribute_id in (2,3)

group by pd.name

select 
  concat( 
  'Вы можете приобрести "', pd.name, '" с гарантией от производителя',
  ' "', max(case when ad.attribute_id=2 then ad.name end), '" ',
  ' "', max(case when ad.attribute_id=2 then pa.text end), '" ',
  ' и ',
  ' "', max(case when ad.attribute_id=3 then ad.name end), '" ',
  ' "', max(case when ad.attribute_id=3 then pa.text end), '" ') as xz
  
from oc_product_description pd 
inner join oc_product_to_category pc on pd.product_id=pc.product_id
inner join oc_product_attribute pa on pd.product_id=pa.product_id and pd.language_id=pa.language_id
inner join oc_attribute_description ad on pa.attribute_id=ad.attribute_id and pa.language_id=ad.language_id

where pd.language_id=4
  and pa.attribute_id in (2,3)
  and pc.category_id=146

group by pd.name

UPDATE pd
set pd.`description`= concat( 
'Вы можете приобрести ', pd.name, ' с гарантией от производителя',
' ', max(case when ad.attribute_id=2 then ad.name end), ' ',
' ', max(case when ad.attribute_id=2 then pa.text end), ' ',
' и ',
' ', max(case when ad.attribute_id=3 then ad.name end), ' ',
' ', max(case when ad.attribute_id=3 then pa.text end), ' ')

from oc_product_description pd 
inner join oc_product_attribute pa on pd.product_id=pa.product_id and 

pd.language_id=pa.language_id
inner join oc_attribute_description ad on pa.attribute_id=ad.attribute_id and 

pa.language_id=ad.language_id
inner join oc_product_to_category pc on pc.product_id=pa.product_id

where pd.language_id=4
and pa.attribute_id in (2,3)
and pc.category_id = 121
and pa.product_id = 102
group by pd.name

update pd
set pd.description=a.xz
from oc_product_description pd

inner join

(select pd.product_id,
  concat( 
  'Вы можете приобрести "', pd.name, '" с гарантией от производителя',
  ' "', max(case when ad.attribute_id=2 then ad.name end), '" ',
  ' "', max(case when ad.attribute_id=2 then pa.text end), '" ',
  ' и ',
  ' "', max(case when ad.attribute_id=3 then ad.name end), '" ',
  ' "', max(case when ad.attribute_id=3 then pa.text end), '" ') as xz
  
from oc_product_description pd 
inner join oc_product_to_category pc on pd.product_id=pc.product_id
inner join oc_product_attribute pa on pd.product_id=pa.product_id and pd.language_id=pa.language_id
inner join oc_attribute_description ad on pa.attribute_id=ad.attribute_id and pa.language_id=ad.language_id

where pd.language_id=4
  and pa.attribute_id in (2,3)
  and pc.category_id=146

group by pd.name, pd.product_id) a

on pd.product_id=a.product_id