SELECT total.id, ROUND(AVG(IF(total.percent_diff <= 115 AND total.percent_diff >= 85, total.price, null)), 2) AS 'newT', total.price_sredn
FROM (
	SELECT t.id, t.price, 100 * t.price / t2.avg_price as percent_diff ,t.price_sredn
	FROM (
		SELECT pa.id, pa.price_sredn, sp.price
		FROM prices_all pa
		LEFT JOIN supplier_price sp ON pa.art_num = sp.art_num AND pa.brand_id = sp.brand_id
		LEFT JOIN supplier_price_avalaible spa ON sp.`hash` = spa.`hash`
		LEFT JOIN supplier_storage ss ON spa.storage_id = ss.id
		WHERE
			spa.avalaible IS NOT NULL
-- 			AND ss.no_active_price IS NULL
		GROUP BY pa.id, sp.id
	) t
	LEFT JOIN (
		SELECT pa.id, COUNT(DISTINCT sp.id) as count, AVG(sp.price) as avg_price
		FROM prices_all pa
		LEFT JOIN supplier_price sp ON pa.art_num = sp.art_num AND pa.brand_id = sp.brand_id
		LEFT JOIN supplier_price_avalaible spa ON sp.`hash` = spa.`hash`
		LEFT JOIN supplier_storage ss ON spa.storage_id = ss.id
		WHERE
			spa.avalaible IS NOT NULL
-- 			AND ss.no_active_price IS NULL
		GROUP BY pa.id
	) t2 ON t.id = t2.id
) total
LEFT JOIN prices_all pa ON total.id = pa.id
LEFT JOIN prices_median pm ON pa.art_num = pm.art_num AND pa.brand_id = pm.brand_id
WHERE pm.art_num IS NULL
GROUP BY total.id