UPDATE migrate.prices_all AS pa
INNER JOIN (
	SELECT DISTINCT
		pa.id AS 'pa_id',
		pa.pa_art_id AS '(real)pa_art_id',
		pa.pa_ga_id AS '(real)pa_ga_id',
		art.ART_ID AS 'pa_art_id',
		MIN(lag.productid) AS 'pa_ga_id'
	FROM
		migrate.prices_all pa
	LEFT JOIN yii_doc.brand_groups bg ON pa.brand_id = bg.parent_id
	INNER JOIN tecdoc_2016q1_europe.ARTICLES_UPD_2017 art ON bg.BRA_ID = art.ART_SUP_ID
	AND pa.art_num = art.OWN_S_CLEAR
	INNER JOIN tecdoc_2016q1_europe.LINK_ART_GA_2017 lag ON art.ART_ID = lag.LAG_ART_ID
	GROUP BY
		pa.id
) AS t1
SET pa.pa_art_id = t1.pa_art_id, pa.pa_ga_id = t1.pa_ga_id
WHERE
	t1.pa_id = pa.id