SELECT pa.art_num
     , pa.brand_id
     , ba.NAME_BRANDS
     , ba.parent_id AS parent_brand_id
     , ba11.NAME_BRANDS AS parent_brand
     , pa.avalaible_gen
     , pa.price_sredn
     , pa.price_torg
     , pa.pa_ga_id_search
FROM yii_doc.prices_all pa
LEFT JOIN yii_doc.brand_all ba ON ba.id = pa.brand_id
LEFT JOIN yii_doc.brand_all ba11 ON ba11.id = ba.parent_id
WHERE pa.id = 37765083
UNION ALL
SELECT pad.art_num
     , pad.brand_id
     , ba2.NAME_BRANDS
     , ba2.parent_id AS parent_brand_id
     , ba22.NAME_BRANDS AS parent_brand
     , pad.avalaible_gen
     , pad.price_sredn
     , pad.price_torg
     , pad.pa_ga_id_search
FROM yii_doc.prices_all_duplicate pad
LEFT JOIN yii_doc.brand_all ba2 ON ba2.id = pad.brand_id
LEFT JOIN yii_doc.brand_all ba22 ON ba22.id = ba2.parent_id
WHERE pad.id = 37765083
;