SELECT pa.id AS 'pd_pa_id', dr.id AS 'pd_dr_id', la.productid AS 'pd_ga_id'

FROM tecdoc_2016q1_europe.LINK_ART_GA_2017 la

INNER JOIN yii_doc.prices_all pa ON la.LAG_ART_ID = pa.pa_art_id

INNER JOIN yii_doc.dok_ga dga ON la.productid = dga.id

INNER JOIN yii_doc.dok_razdel dr ON dga.parent_id = dr.id

WHERE 1 AND dr.id = 276

GROUP BY pa.id, dr.id