SELECT
		pa.id as product_id
		, pa.art_num as product_art_num
		, pa.pa_ga_id as product_ga_id
		, ba.NAME_BRANDS AS brand_name
		, bt.country AS brand_country
		, ba.url as brand_url
		, dg.name_ru as product_name
		, pa.price_torg as price
		, pa.avalaible_gen AS available
		, pa.art_num as article
		, dr.id as razdelId
		, di.id as izdelieId
		, di.grand_parent_id as rubrikaId
		, (
				SELECT GROUP_CONCAT(DISTINCT CONCAT(ct1.text, ':',IFNULL(ct2.text, IFNULL(ca_char_int,ca_char_decimal)), IFNULL(ct3.text,'')
			) ORDER BY cd.tile SEPARATOR '/') AS tile
				FROM char_art ca
				LEFT JOIN `char` c ON ca_char_id = c.id
				LEFT JOIN char_dga cd ON c.id = cd.char_id
				LEFT JOIN char_text ct1 ON c.cha_name_id = ct1.id
				LEFT JOIN char_text ct2 ON IFNULL(ca.is_collapse, ca.ca_char_text_id) = ct2.id
				LEFT JOIN char_text ct3 ON c.cha_name_unit_id = ct3.id
				WHERE ca_pa_id = pa.id AND cd.tile IS NOT NULL
		) AS tile
		,pa_min.sort
FROM (
		SELECT DISTINCT pa.id, pd.sort
		FROM PA_DR pd
		LEFT JOIN prices_all pa ON pd.pd_pa_id = pa.id
		LEFT JOIN dok_ga dg ON pa.pa_ga_id_search = dg.GA_ID

		WHERE pa.avalaible_gen IN (0, 1)
		AND pd.pd_dr_id = 242
		-- AND pa.price_torg >= 327.17

		ORDER BY
				 -- pa.avalaible_gen DESC, pa.price_torg
			pd.sort
		LIMIT  12
		OFFSET 0
) pa_min
LEFT JOIN prices_all pa ON pa_min.id = pa.id

LEFT JOIN tecdoc_2016q1_europe.LINK_ART_GA_2017 lag ON pa.pa_art_id = lag.LAG_ART_ID

LEFT JOIN dok_ga dg ON IFNULL(lag.productid, pa.pa_ga_id_search) = dg.GA_ID
LEFT JOIN dok_razdel dr ON dg.parent_id = dr.id
LEFT JOIN dok_izdelie di ON dr.parent_id = di.id

LEFT JOIN brand_all ba ON pa.brand_id = ba.id
LEFT JOIN brand_text bt ON ba.id = bt.brand_id
WHERE
		-- Отключаем запчасти для ТО
		di.grand_parent_id IS NULL OR di.grand_parent_id <> 1
GROUP BY
		pa.id
ORDER BY
		 -- pa.avalaible_gen DESC, pa.price_torg
	pa_min.sort