# 30193
SELECT
# 	COUNT(DISTINCT pa.id)
	pa.*
	, ba.*
FROM prices_all pa
LEFT JOIN brand_groups bg
			  ON bg.parent_id = pa.brand_id
LEFT JOIN tecdoc_2016q1_europe.ARTICLES_UPD_2017 art
			  ON art.ART_SUP_ID = bg.BRA_ID AND art.OWN_S_CLEAR = pa.art_num
LEFT JOIN brand_all ba ON pa.brand_id = ba.id
WHERE
	1 = 1
	AND art.ART_ID IS NOT NULL
	AND pa.avalaible_gen = 1
	AND art.OWN_ART_TYP = '2018'