SELECT *, CEIL(t1.median * (1 + prm.margin / 100))
FROM (
	SELECT
		MEDIAN(spd.price) AS 'median'
	FROM `supplier_price_duplicate_10_01_18` spd
	WHERE spd.art_num = '530031610' AND spd.brand_id = 1031
) t1
LEFT JOIN parse_rule_median AS prm ON t1.median >= prm.min_price AND t1.median < prm.max_price
;

SELECT CEIL(t1.median * (1 + prm.margin / 100))
FROM (
	SELECT
		MEDIAN(spd.price) AS 'median'
	FROM `supplier_price_duplicate_10_01_18` spd
	WHERE spd.art_num = 'TC2144' AND spd.brand_id = 520
) t1
LEFT JOIN parse_rule_median AS prm ON t1.median >= prm.min_price AND t1.median < prm.max_price
;

SELECT
	CAST(pac.price_sredn + (pac.price_sredn * prm.margin/100) AS DECIMAL(10,2))
FROM prices_all_duplicate_10_01_18 AS pac
LEFT JOIN parse_rule_dok_ga_count pc ON pac.pa_ga_id = pc.ga_id
LEFT JOIN parse_rule_median AS prm ON
	IF(pc.product_count IS NOT NULL AND MOD(pc.product_count, 2) = 0,
		(pac.price_sredn * pc.product_count) > prm.min_price AND (pac.price_sredn * pc.product_count) <= prm.max_price,
		 pac.price_sredn > prm.min_price AND pac.price_sredn <= prm.max_price)
WHERE pac.id = 41
;