SELECT pa.id
	 , pa.art_num
	 , pa.brand_id
	 , pa.pa_art_id AS current_art_id
	 , t1.ART_ID    AS new_art_id
	 , pa.pa_ga_id  AS current_ga_id
	 , t1.pa_ga_id  AS new_ga_id
FROM tecdoc_2018q2_alex.prices_all pa
	 INNER JOIN (
					SELECT pa.id AS pa_id, art.ART_ID, MIN(lag.productid) AS pa_ga_id
					FROM tecdoc_2018q2_alex.prices_all pa
						 LEFT JOIN tecdoc_2018q2_alex.2018_brand_groups bg ON pa.brand_id = bg.parent_id
						 INNER JOIN tecdoc_2018q2_alex.2018_ARTICLES_UPD art
							 ON bg.BRA_ID = art.ART_SUP_ID AND pa.art_num = art.OWN_S_CLEAR
						 INNER JOIN tecdoc_2018q2_alex.2018_LINK_ART_GA 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 1 = 1
  AND t1.pa_id = pa.id
  AND pa.pa_art_id IS NULL
  AND t1.ART_ID IS NOT NULL
#   AND pa.avalaible_gen = 1
#   AND pa.pa_ga_id IS NULL

#   AND pa.pa_art_id IS NOT NULL
# #   AND pa.pa_art_id <> -1
#   AND t1.ART_ID <> pa.pa_art_id

#   AND pa.pa_ga_id IS NOT NULL
#   AND t1.pa_ga_id IS NOT NULL
#   AND t1.pa_ga_id <> pa.pa_ga_id
;