SELECT
	1 as SA_available
	, t.seo_model_id as SA_model_id
	, si.id as SA_izdelie_id
	, COUNT(DISTINCT pa.id) as SA_count_OLD
	,COUNT(DISTINCT
		IF (IF(t.min_available_price IS NOT NULL, CEIL(t.min_available_price), NULL) IS NOT NULL,
			IF (pa.avalaible_gen = 1 OR pa.pod_zakaz IS NULL, pa.id, NULL),
			pa.id)
	) AS SA_count
, IF(t.min_available_price IS NOT NULL, CEIL(t.min_available_price), NULL) as min_price
, si.name_ru
FROM (
	SELECT
		ta.dok_razdel_id
		, ta.seo_model_id
		, MIN(IF(pa.avalaible_gen = 1, pa.price_torg, null)) as min_available_price
		, si.id as sid
	FROM tecdoc_art2 ta
	LEFT JOIN prices_all/*_duplicate*/ pa ON ta.art_id = pa.pa_art_id
	INNER JOIN seo_izdelie si ON ta.dok_razdel_id = si.dok_razdel_id
	INNER JOIN seo_model sm ON ta.seo_model_id = sm.id
	LEFT JOIN virtual_seo_models vsm ON ta.seo_model_id = vsm.seo_model_id
	WHERE
		pa.avalaible_gen IN (0, 1)
		AND ta.seo_model_id > 0 -- AND sm.id = 21 AND si.dok_razdel_id = 141
		AND vsm.seo_model_id IS NULL

	-- AND ta.seo_model_id = 304

	GROUP BY ta.seo_model_id, si.id
) t
LEFT JOIN tecdoc_art2 ta ON t.seo_model_id = ta.seo_model_id AND t.dok_razdel_id = ta.dok_razdel_id
LEFT JOIN prices_all/*_duplicate*/ pa ON ta.art_id = pa.pa_art_id

INNER JOIN seo_izdelie si ON t.sid = si.id
INNER JOIN seo_model sm ON ta.seo_model_id = sm.id

WHERE
	pa.avalaible_gen IN (0, 1)
	AND pa.price_torg >= IFNULL(t.min_available_price, 0)

GROUP BY t.seo_model_id, t.sid

HAVING SA_count_OLD <> SA_count

ORDER BY SA_model_id, SA_izdelie_id