SELECT DISTINCT
pa.id AS 'PA_ID'
,art.ART_ID AS 'pa_art_id'
,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