select distinct
    kt.id,
    tdl.article_id as tecdoclink,
    kt.kod,
    kt.proizvod,
    kt.descr,
    kt.clearkod,
    kt.tovar_type,
    kt.tovar_tip,
    kt.info_base,
    kt.internalkod,
    pr.pvaluta as valuta,
    pr.pprice as price,
    po.name as p_name,
    po.ishideall as ishide,
    po.ishide as hide_client,
    po.mainmark,
	po.clientshow,
    pr.pvimir as vimir,
    va.valutakurs,
    os.ostatok as ostatok,
    pr.base_id,
    pr.pdescr as descr2,
    pr.pkod as kod_p,
    pr.pproizvod as prproizvod,
    UNIX_TIMESTAMP(po.updated) as po_upd,
    po.clientshow,
    zm.an_src,
    sk.sname as sklad_name,
    sk.sid as sklad_id,

	CASE 1 
		WHEN 0 THEN sk.d0 
		WHEN 1 THEN sk.d1 
		WHEN 2 THEN sk.d2 
		WHEN 3 THEN sk.d3 
		WHEN 4 THEN sk.d4 
		WHEN 5 THEN sk.d5 
		WHEN 6 THEN sk.d6 
	END as waituntil,

	CASE 1 
		WHEN 0 THEN sk.nd0 
		WHEN 1 THEN sk.nd1 
		WHEN 2 THEN sk.nd2 
		WHEN 3 THEN sk.nd3 
		WHEN 4 THEN sk.nd4 
		WHEN 5 THEN sk.nd5 
		WHEN 6 THEN sk.nd6 
	END as waituntilnext,    sk.timme,
    po.koef_dostavka,
    if(pr.base_id = '909090',
        1,
        1 + pol.prozn / 100) as koef_rozn,
    if(pr.base_id = '909090'
            and nm.NomenklaturaIsDiscount = 1,
        0,
        pol.pskidka) as skidkaa,
    nm.NomenklaturaIsDiscount as discount,
    0 as altered_price,
	IF( EXISTS( SELECT 1 FROM vozvrat WHERE codepost=pr.base_id ), 1, 0 ) AS rtn,
	CASE WHEN pr.base_id='909090' THEN 1 ELSE COALESCE(spp.canReturn) END AS rtn2,
	IF( pr.base_id='909090' AND nm.NomenklaturaIsDiscount=0, 
		ROUND(caches.getDiscountFn( kt.id, '03275'),2), 
		NULL ) AS mtechno_discount
from
    (select 
        id_ktovar, id_ktovar2, min(src) as an_src
    from
        (select 
        zm1.id_ktovar, zm1.id_ktovar2, 0 as src
    from
        base.zamena as zm1
    where
        zm1.id_ktovar = 2076248
            and zm1.id_ktovar2 <> 2076248 union SELECT
  zm1.id_ktovar,
  zm2.id_ktovar2,
  1 AS src
FROM base.zamena zm1
  LEFT OUTER JOIN base.ktovar zmk
    ON zmk.id = zm1.id_ktovar2
  LEFT OUTER JOIN base.zamena zm2
    ON zm2.id_ktovar = zm1.id_ktovar2
WHERE zm1.id_ktovar = 2076248
AND zm2.id_ktovar2 <> 2076248
AND (NOT 0
OR zmk.id IS NOT NULL
AND zmk.tovar_type = 1) 
	) as zzm
    group by zzm.id_ktovar , zzm.id_ktovar2) as zm
        left outer join
    base.tecdoc_link as tdl ON tdl.id_ktovar = zm.id_ktovar2
        and tdl.catalog_id = 201304
        left outer join
    base.ktovar as kt ON kt.id = zm.id_ktovar2
        left outer join
    base.tvariant as tv ON tv.id_ktovar = kt.id
        left outer join
    base.tovar_koef as tk ON tk.id_ktovar = kt.id
        left outer join
    base.pprices as pr ON pr.idkt = tv.id_ktovar
        left outer join
    base.ktovar_price_policy as ppol ON ppol.id_ktovar = pr.idkt
        left outer join
    base.price_policy as pol ON if(ppol.policy_id is null,
        pol.policy_id = 1,
        pol.policy_id = ppol.policy_id)
        and if(pr.base_id = 909090,
        pol.tu_id = 297,
        pol.tu_id = 297)
        left outer join
    mtechno.valuta as va ON va.valutaname = rtrim(pr.pvaluta)
        left outer join
    base.postatok as os ON os.idkt = pr.idkt
        and os.obase_id = pr.base_id
        and os.okod = pr.pkod
        left outer join
    base.psklad as sk ON sk.sbase_id = pr.base_id
        and sk.sid = os.osklad
        left outer join
    mtechno.nomenklatura as nm ON nm.id_ktovar = kt.id
        and pr.base_id = 909090
        left outer join
    mtechno.postavshiki as po ON po.id = pr.base_id
		left join
	mtechno.suppliers spp ON pr.base_id=spp.Code
where
    zm.id_ktovar = 2076248

	AND ( ( (ishideall is null) OR (ishideall = 0) )  
		AND ( (( ishide is null) OR (ishide = 0) ) 
			OR '1' ) )

    and ( NOT '1' OR pr.base_id='909090' )
	and( NOT '0' OR ostatok>0 )
ORDER BY price*valutakurs;