Sorry, there was an error. Try to reload the page or contact the phone number indicated in the contacts<pre>Array
(
    [message] => MySQL server has gone away
    [code] => 2006
    [file] => 
        select t.* from (
        
        
        select 
         p.id
        
        ,  if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        ))))  as sPFieldDefault
        ,  if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        ))))  as sPField
        ,  if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldDefaultKontrol
        ,  if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldKontrol
            
        , ( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) as sCP
        , ( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) as sCPDef
        , (p.Roznichnaya) as sCPRozn
        
        , if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) )  as sCalcPrice
        , if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as sPriceKontrol
        
        
    ,p.baz_ed_izm
    ,p.prodavat_kratno

    ,p.item_code
    ,p.id_provider
    ,p.code_in
    ,p.code_1c
    ,p.pref
    ,p.cat
    ,p.post_date
    /*,p.term*/
    ,p.stock
    ,if(LENGTH(p.description_ua)>1,p.description_ua,p.description) as description
    /*,ifnull(pgs.id_price_group,0)*/
    ,p.number_min
    ,p.is_restored
    ,p.id_1c
    ,p.url_video
    ,p.country_manufacturer
    ,p.country_brand
     , p.price as price_original
     , c.title as make , c.name as cat_name, c.id_tof as id_brand, c.title as brand, c.image as image_logo, c.id as brand_id
     , concat(ifnull(cp.name,''),' ',ifnull(p.part_eng,'')) as name
     , coalesce(cp.name_rus,p.part_ua,'') as name_translate, ifnull(cp.id, '') as id_cat_part
     , ifnull(cp.has_certificate, 0) as has_certificate
     , p.code as code_, p.item_code as item_code_
     , concat(ifnull(cp.information, ''), ' ', ifnull(if(LENGTH(p.description_ua)>1,p.description_ua,p.description),'')) as information
     , ifnull(concat('ZZZ_',p.id),'') as zzz_code
     , if(p.code in (0),0,1) as crsord
     , up.name as provider, up.name as provider_name, up.code_name as provider_code_name, up.code_delivery, up.is_our_store
     , p.term as term
     , up.term as term_day, up.id_currency
     , ifnull(prg.name,'') as price_group_name
     , ifnull(prg.name_ukr,'') as price_group_name_ukr
     , ifnull(prg.code_name,'') as price_group_code_name
     , pgs.id_price_group
     , prg.`1c_id` as price_group_1c_id, prg.`1c_parent` as price_group_1c_parent
     , if(p.price>0,1,0) as price_null  
      , p.code as code, concat(p.item_code,'::',up.id_user) as code_provider , 0 as pref_order  , 0 as code_order ,  if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price, 
        if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price_order, 
        if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as price_kontrol  ,bus.*,
        /*p.ZCh_Brend ,  
        p.ZCh_TovarnayaGruppa ,  
        p.ZCh_TipZCh ,  */
        p.ZCh_TipZCh as type_TipZCh , 
        p._Standartnaya ,  
        p.Roznichnaya ,  
        p.MinimalnayaCena ,  
        p._MinimalnayaBeznal ,  
        p._MinimalnayaKassa,

      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,6,
      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',5,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh,4,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',3,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,2,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',1,0
      )))))) as priority,
        
        p.tnved,
        p.guarantee,
        p.imported,
        c_pic.id_1c as id_1c_pic
     from price as p
     left join popular_products as pp on p.id_1c=pp.id_1c and pp.bage='offer' and pp.visible=1
     left join price_group_assign as pgs on pgs.item_code=p.item_code
     left join cat_part as cp on cp.item_code=p.item_code
     inner join cat as c on p.pref=c.pref and c.visible=1
     inner join provider_virtual as pv on p.id_provider=pv.id_provider
     inner join user_provider as up on pv.id_provider_virtual=up.id_user
     inner join provider_group as pg on up.id_provider_group=pg.id
     inner join user as u on up.id_user=u.id and u.visible=1
     inner join currency as cu on up.id_currency=cu.id
     left join price_group prg on prg.id=pgs.id_price_group
     left join price_group_param as pgp on pgp.item_code=p.item_code
     left join brand_user_sale bus on /*p.pref=bus.cat_pref and*/ bus.user_id = '' and (
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' )
     )
     left join tipy_cen as tc on bus.ZCh_SpecTipCen=tc.ID 
     left join tipy_cen as tc_kontrol on tc.KontrolnayaMinimalnayaCenaBeznal=tc_kontrol.ID 
         
     left join tipy_cen as tc_default on tc_default.ID=''
     left join tipy_cen as tc_kontrol_default on tc_kontrol_default.ID=tc_default.KontrolnayaMinimalnayaCenaBeznal
     left join cat_pic  as c_pic on p.id_1c=c_pic.id_1c
     where 1=1
      and p.stock>0  and p.deleted=0  and (p.item_code in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') ) and p.id_provider=1883
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by t.code, stock desc, price_null desc 
    [line] => 0
    [trace] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/vendor/adodb/adodb-php/adodb.inc.php
                    [line] => 1624
                    [function] => ADODB_Error_Handler
                    [args] => Array
                        (
                            [0] => mysqli
                            [1] => EXECUTE
                            [2] => 2006
                            [3] => MySQL server has gone away
                            [4] => 
        select t.* from (
        
        
        select 
         p.id
        
        ,  if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        ))))  as sPFieldDefault
        ,  if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        ))))  as sPField
        ,  if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldDefaultKontrol
        ,  if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldKontrol
            
        , ( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) as sCP
        , ( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) as sCPDef
        , (p.Roznichnaya) as sCPRozn
        
        , if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) )  as sCalcPrice
        , if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as sPriceKontrol
        
        
    ,p.baz_ed_izm
    ,p.prodavat_kratno

    ,p.item_code
    ,p.id_provider
    ,p.code_in
    ,p.code_1c
    ,p.pref
    ,p.cat
    ,p.post_date
    /*,p.term*/
    ,p.stock
    ,if(LENGTH(p.description_ua)>1,p.description_ua,p.description) as description
    /*,ifnull(pgs.id_price_group,0)*/
    ,p.number_min
    ,p.is_restored
    ,p.id_1c
    ,p.url_video
    ,p.country_manufacturer
    ,p.country_brand
     , p.price as price_original
     , c.title as make , c.name as cat_name, c.id_tof as id_brand, c.title as brand, c.image as image_logo, c.id as brand_id
     , concat(ifnull(cp.name,''),' ',ifnull(p.part_eng,'')) as name
     , coalesce(cp.name_rus,p.part_ua,'') as name_translate, ifnull(cp.id, '') as id_cat_part
     , ifnull(cp.has_certificate, 0) as has_certificate
     , p.code as code_, p.item_code as item_code_
     , concat(ifnull(cp.information, ''), ' ', ifnull(if(LENGTH(p.description_ua)>1,p.description_ua,p.description),'')) as information
     , ifnull(concat('ZZZ_',p.id),'') as zzz_code
     , if(p.code in (0),0,1) as crsord
     , up.name as provider, up.name as provider_name, up.code_name as provider_code_name, up.code_delivery, up.is_our_store
     , p.term as term
     , up.term as term_day, up.id_currency
     , ifnull(prg.name,'') as price_group_name
     , ifnull(prg.name_ukr,'') as price_group_name_ukr
     , ifnull(prg.code_name,'') as price_group_code_name
     , pgs.id_price_group
     , prg.`1c_id` as price_group_1c_id, prg.`1c_parent` as price_group_1c_parent
     , if(p.price>0,1,0) as price_null  
      , p.code as code, concat(p.item_code,'::',up.id_user) as code_provider , 0 as pref_order  , 0 as code_order ,  if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price, 
        if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price_order, 
        if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as price_kontrol  ,bus.*,
        /*p.ZCh_Brend ,  
        p.ZCh_TovarnayaGruppa ,  
        p.ZCh_TipZCh ,  */
        p.ZCh_TipZCh as type_TipZCh , 
        p._Standartnaya ,  
        p.Roznichnaya ,  
        p.MinimalnayaCena ,  
        p._MinimalnayaBeznal ,  
        p._MinimalnayaKassa,

      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,6,
      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',5,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh,4,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',3,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,2,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',1,0
      )))))) as priority,
        
        p.tnved,
        p.guarantee,
        p.imported,
        c_pic.id_1c as id_1c_pic
     from price as p
     left join popular_products as pp on p.id_1c=pp.id_1c and pp.bage='offer' and pp.visible=1
     left join price_group_assign as pgs on pgs.item_code=p.item_code
     left join cat_part as cp on cp.item_code=p.item_code
     inner join cat as c on p.pref=c.pref and c.visible=1
     inner join provider_virtual as pv on p.id_provider=pv.id_provider
     inner join user_provider as up on pv.id_provider_virtual=up.id_user
     inner join provider_group as pg on up.id_provider_group=pg.id
     inner join user as u on up.id_user=u.id and u.visible=1
     inner join currency as cu on up.id_currency=cu.id
     left join price_group prg on prg.id=pgs.id_price_group
     left join price_group_param as pgp on pgp.item_code=p.item_code
     left join brand_user_sale bus on /*p.pref=bus.cat_pref and*/ bus.user_id = '' and (
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' )
     )
     left join tipy_cen as tc on bus.ZCh_SpecTipCen=tc.ID 
     left join tipy_cen as tc_kontrol on tc.KontrolnayaMinimalnayaCenaBeznal=tc_kontrol.ID 
         
     left join tipy_cen as tc_default on tc_default.ID=''
     left join tipy_cen as tc_kontrol_default on tc_kontrol_default.ID=tc_default.KontrolnayaMinimalnayaCenaBeznal
     left join cat_pic  as c_pic on p.id_1c=c_pic.id_1c
     where 1=1
      and p.stock>0  and p.deleted=0  and (p.item_code in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') ) and p.id_provider=1883
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by t.code, stock desc, price_null desc 
                            [5] => 
                            [6] => ADODB_mysqli Object
                                (
                                    [dataProvider] => mysql
                                    [databaseType] => mysqli
                                    [database] => atpftbng
                                    [dsnType] => 
                                    [host] => 127.0.0.1
                                    [port] => 3306
                                    [user] => u_atpftbng
                                    [password] => not stored
                                    [debug] => 
                                    [maxblobsize] => 262144
                                    [concat_operator] => +
                                    [substr] => substring
                                    [length] => length
                                    [random] => rand()
                                    [upperCase] => upper
                                    [fmtDate] => 'Y-m-d'
                                    [fmtTimeStamp] => 'Y-m-d H:i:s'
                                    [true] => 1
                                    [false] => 0
                                    [replaceQuote] => \'
                                    [nameQuote] => `
                                    [leftBracket] => [
                                    [rightBracket] => ]
                                    [charSet] => 
                                    [metaDatabasesSQL] => 
                                    [metaTablesSQL] => SELECT
			TABLE_NAME,
			CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
		FROM INFORMATION_SCHEMA.TABLES
		WHERE TABLE_SCHEMA=
                                    [metaColumnsSQL] => SHOW COLUMNS FROM `%s`
                                    [identitySQL] => 
                                    [_genSeqSQL] => create table if not exists %s (id int not null)
                                    [_dropSeqSQL] => drop table if exists %s
                                    [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
                                    [uniqueOrderBy] => 
                                    [emptyDate] => &nbsp;
                                    [emptyTimeStamp] => &nbsp;
                                    [lastInsID] => 
                                    [hasInsertID] => 1
                                    [hasAffectedRows] => 1
                                    [hasTop] => 
                                    [hasLimit] => 1
                                    [readOnly] => 
                                    [hasMoveFirst] => 1
                                    [hasGenID] => 1
                                    [hasTransactions] => 1
                                    [genID] => 0
                                    [raiseErrorFn] => ADODB_Error_Handler
                                    [isoDates] => 1
                                    [cacheSecs] => 3600
                                    [memCache] => 
                                    [memCacheHost] => 
                                    [memCachePort] => 11211
                                    [memCacheCompress] => 
                                    [memCacheOptions] => Array
                                        (
                                        )

                                    [sysDate] => CURDATE()
                                    [sysTimeStamp] => NOW()
                                    [sysUTimeStamp] => 
                                    [arrayClass] => ADORecordSet_array_mysqli
                                    [noNullStrings] => 
                                    [numCacheHits] => 0
                                    [numCacheMisses] => 0
                                    [pageExecuteCountRows] => 1
                                    [uniqueSort] => 
                                    [leftOuter] => 
                                    [rightOuter] => 
                                    [ansiOuter] => 
                                    [autoRollback] => 
                                    [poorAffectedRows] => 1
                                    [fnExecute] => 
                                    [fnCacheExecute] => 
                                    [blobEncodeType] => 
                                    [rsPrefix] => ADORecordSet_
                                    [autoCommit] => 1
                                    [transOff] => 0
                                    [transCnt] => 0
                                    [fetchMode] => 2
                                    [null2null] => null
                                    [bulkBind] => 
                                    [connectStmt] => 
                                    [_oldRaiseFn] => 
                                    [_transOK] => 
                                    [_connectionID] => mysqli Object
                                        (
                                            [affected_rows] => -1
                                            [client_info] => mysqlnd 8.4.25
                                            [client_version] => 80425
                                            [connect_errno] => 0
                                            [connect_error] => 
                                            [errno] => 2006
                                            [error] => MySQL server has gone away
                                            [error_list] => Array
                                                (
                                                    [0] => Array
                                                        (
                                                            [errno] => 2006
                                                            [sqlstate] => HY000
                                                            [error] => MySQL server has gone away
                                                        )

                                                )

                                            [field_count] => 2
                                            [host_info] => 127.0.0.1 via TCP/IP
                                            [info] => 
                                            [insert_id] => 0
                                            [server_info] => 11.8.9-MariaDB-deb13-log
                                            [server_version] => 110809
                                            [sqlstate] => HY000
                                            [protocol_version] => 10
                                            [thread_id] => 328558
                                            [warning_count] => 0
                                        )

                                    [_errorMsg] => MySQL server has gone away
                                    [_errorCode] => 2006
                                    [_queryID] => 
                                    [_isPersistentConnection] => 
                                    [_bindInputArray] => 
                                    [evalAll] => 
                                    [_affected] => 
                                    [_logsql] => 
                                    [_transmode] => 
                                    [connectionParameters:protected] => Array
                                        (
                                        )

                                    [customActualTypes] => Array
                                        (
                                        )

                                    [customMetaTypes] => Array
                                        (
                                        )

                                    [_metars] => 
                                    [locale] => 
                                    [forceNewConnect] => 
                                    [clientFlags] => 0
                                    [socket] => 
                                    [optionFlags] => Array
                                        (
                                        )

                                    [multiQuery] => 
                                    [ssl_key] => 
                                    [ssl_cert] => 
                                    [ssl_ca] => 
                                    [ssl_capath] => 
                                    [ssl_cipher] => 
                                    [doNotUseBoundVariables] => 
                                    [usePreparedStatement:ADODB_mysqli:private] => 
                                    [useLastInsertStatement:ADODB_mysqli:private] => 
                                    [usingBoundVariables:ADODB_mysqli:private] => 
                                    [statementAffectedRows:ADODB_mysqli:private] => -1
                                    [isSelectStatement:ADODB_mysqli:private] => 1
                                    [_genSeqCountSQL] => select count(*) from %s
                                    [_genSeq2SQL] => insert into %s values (%s)
                                )

                        )

                )

            [1] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php
                    [line] => 1195
                    [function] => _Execute
                    [class] => ADOConnection
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
        select t.* from (
        
        
        select 
         p.id
        
        ,  if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        ))))  as sPFieldDefault
        ,  if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        ))))  as sPField
        ,  if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldDefaultKontrol
        ,  if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldKontrol
            
        , ( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) as sCP
        , ( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) as sCPDef
        , (p.Roznichnaya) as sCPRozn
        
        , if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) )  as sCalcPrice
        , if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as sPriceKontrol
        
        
    ,p.baz_ed_izm
    ,p.prodavat_kratno

    ,p.item_code
    ,p.id_provider
    ,p.code_in
    ,p.code_1c
    ,p.pref
    ,p.cat
    ,p.post_date
    /*,p.term*/
    ,p.stock
    ,if(LENGTH(p.description_ua)>1,p.description_ua,p.description) as description
    /*,ifnull(pgs.id_price_group,0)*/
    ,p.number_min
    ,p.is_restored
    ,p.id_1c
    ,p.url_video
    ,p.country_manufacturer
    ,p.country_brand
     , p.price as price_original
     , c.title as make , c.name as cat_name, c.id_tof as id_brand, c.title as brand, c.image as image_logo, c.id as brand_id
     , concat(ifnull(cp.name,''),' ',ifnull(p.part_eng,'')) as name
     , coalesce(cp.name_rus,p.part_ua,'') as name_translate, ifnull(cp.id, '') as id_cat_part
     , ifnull(cp.has_certificate, 0) as has_certificate
     , p.code as code_, p.item_code as item_code_
     , concat(ifnull(cp.information, ''), ' ', ifnull(if(LENGTH(p.description_ua)>1,p.description_ua,p.description),'')) as information
     , ifnull(concat('ZZZ_',p.id),'') as zzz_code
     , if(p.code in (0),0,1) as crsord
     , up.name as provider, up.name as provider_name, up.code_name as provider_code_name, up.code_delivery, up.is_our_store
     , p.term as term
     , up.term as term_day, up.id_currency
     , ifnull(prg.name,'') as price_group_name
     , ifnull(prg.name_ukr,'') as price_group_name_ukr
     , ifnull(prg.code_name,'') as price_group_code_name
     , pgs.id_price_group
     , prg.`1c_id` as price_group_1c_id, prg.`1c_parent` as price_group_1c_parent
     , if(p.price>0,1,0) as price_null  
      , p.code as code, concat(p.item_code,'::',up.id_user) as code_provider , 0 as pref_order  , 0 as code_order ,  if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price, 
        if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price_order, 
        if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as price_kontrol  ,bus.*,
        /*p.ZCh_Brend ,  
        p.ZCh_TovarnayaGruppa ,  
        p.ZCh_TipZCh ,  */
        p.ZCh_TipZCh as type_TipZCh , 
        p._Standartnaya ,  
        p.Roznichnaya ,  
        p.MinimalnayaCena ,  
        p._MinimalnayaBeznal ,  
        p._MinimalnayaKassa,

      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,6,
      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',5,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh,4,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',3,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,2,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',1,0
      )))))) as priority,
        
        p.tnved,
        p.guarantee,
        p.imported,
        c_pic.id_1c as id_1c_pic
     from price as p
     left join popular_products as pp on p.id_1c=pp.id_1c and pp.bage='offer' and pp.visible=1
     left join price_group_assign as pgs on pgs.item_code=p.item_code
     left join cat_part as cp on cp.item_code=p.item_code
     inner join cat as c on p.pref=c.pref and c.visible=1
     inner join provider_virtual as pv on p.id_provider=pv.id_provider
     inner join user_provider as up on pv.id_provider_virtual=up.id_user
     inner join provider_group as pg on up.id_provider_group=pg.id
     inner join user as u on up.id_user=u.id and u.visible=1
     inner join currency as cu on up.id_currency=cu.id
     left join price_group prg on prg.id=pgs.id_price_group
     left join price_group_param as pgp on pgp.item_code=p.item_code
     left join brand_user_sale bus on /*p.pref=bus.cat_pref and*/ bus.user_id = '' and (
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' )
     )
     left join tipy_cen as tc on bus.ZCh_SpecTipCen=tc.ID 
     left join tipy_cen as tc_kontrol on tc.KontrolnayaMinimalnayaCenaBeznal=tc_kontrol.ID 
         
     left join tipy_cen as tc_default on tc_default.ID=''
     left join tipy_cen as tc_kontrol_default on tc_kontrol_default.ID=tc_default.KontrolnayaMinimalnayaCenaBeznal
     left join cat_pic  as c_pic on p.id_1c=c_pic.id_1c
     where 1=1
      and p.stock>0  and p.deleted=0  and (p.item_code in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') ) and p.id_provider=1883
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by t.code, stock desc, price_null desc 
                        )

                )

            [2] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/vendor/adodb/adodb-php/adodb.inc.php
                    [line] => 2294
                    [function] => execute
                    [class] => ADODB_mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
        select t.* from (
        
        
        select 
         p.id
        
        ,  if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        ))))  as sPFieldDefault
        ,  if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        ))))  as sPField
        ,  if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldDefaultKontrol
        ,  if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldKontrol
            
        , ( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) as sCP
        , ( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) as sCPDef
        , (p.Roznichnaya) as sCPRozn
        
        , if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) )  as sCalcPrice
        , if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as sPriceKontrol
        
        
    ,p.baz_ed_izm
    ,p.prodavat_kratno

    ,p.item_code
    ,p.id_provider
    ,p.code_in
    ,p.code_1c
    ,p.pref
    ,p.cat
    ,p.post_date
    /*,p.term*/
    ,p.stock
    ,if(LENGTH(p.description_ua)>1,p.description_ua,p.description) as description
    /*,ifnull(pgs.id_price_group,0)*/
    ,p.number_min
    ,p.is_restored
    ,p.id_1c
    ,p.url_video
    ,p.country_manufacturer
    ,p.country_brand
     , p.price as price_original
     , c.title as make , c.name as cat_name, c.id_tof as id_brand, c.title as brand, c.image as image_logo, c.id as brand_id
     , concat(ifnull(cp.name,''),' ',ifnull(p.part_eng,'')) as name
     , coalesce(cp.name_rus,p.part_ua,'') as name_translate, ifnull(cp.id, '') as id_cat_part
     , ifnull(cp.has_certificate, 0) as has_certificate
     , p.code as code_, p.item_code as item_code_
     , concat(ifnull(cp.information, ''), ' ', ifnull(if(LENGTH(p.description_ua)>1,p.description_ua,p.description),'')) as information
     , ifnull(concat('ZZZ_',p.id),'') as zzz_code
     , if(p.code in (0),0,1) as crsord
     , up.name as provider, up.name as provider_name, up.code_name as provider_code_name, up.code_delivery, up.is_our_store
     , p.term as term
     , up.term as term_day, up.id_currency
     , ifnull(prg.name,'') as price_group_name
     , ifnull(prg.name_ukr,'') as price_group_name_ukr
     , ifnull(prg.code_name,'') as price_group_code_name
     , pgs.id_price_group
     , prg.`1c_id` as price_group_1c_id, prg.`1c_parent` as price_group_1c_parent
     , if(p.price>0,1,0) as price_null  
      , p.code as code, concat(p.item_code,'::',up.id_user) as code_provider , 0 as pref_order  , 0 as code_order ,  if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price, 
        if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price_order, 
        if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as price_kontrol  ,bus.*,
        /*p.ZCh_Brend ,  
        p.ZCh_TovarnayaGruppa ,  
        p.ZCh_TipZCh ,  */
        p.ZCh_TipZCh as type_TipZCh , 
        p._Standartnaya ,  
        p.Roznichnaya ,  
        p.MinimalnayaCena ,  
        p._MinimalnayaBeznal ,  
        p._MinimalnayaKassa,

      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,6,
      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',5,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh,4,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',3,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,2,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',1,0
      )))))) as priority,
        
        p.tnved,
        p.guarantee,
        p.imported,
        c_pic.id_1c as id_1c_pic
     from price as p
     left join popular_products as pp on p.id_1c=pp.id_1c and pp.bage='offer' and pp.visible=1
     left join price_group_assign as pgs on pgs.item_code=p.item_code
     left join cat_part as cp on cp.item_code=p.item_code
     inner join cat as c on p.pref=c.pref and c.visible=1
     inner join provider_virtual as pv on p.id_provider=pv.id_provider
     inner join user_provider as up on pv.id_provider_virtual=up.id_user
     inner join provider_group as pg on up.id_provider_group=pg.id
     inner join user as u on up.id_user=u.id and u.visible=1
     inner join currency as cu on up.id_currency=cu.id
     left join price_group prg on prg.id=pgs.id_price_group
     left join price_group_param as pgp on pgp.item_code=p.item_code
     left join brand_user_sale bus on /*p.pref=bus.cat_pref and*/ bus.user_id = '' and (
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' )
     )
     left join tipy_cen as tc on bus.ZCh_SpecTipCen=tc.ID 
     left join tipy_cen as tc_kontrol on tc.KontrolnayaMinimalnayaCenaBeznal=tc_kontrol.ID 
         
     left join tipy_cen as tc_default on tc_default.ID=''
     left join tipy_cen as tc_kontrol_default on tc_kontrol_default.ID=tc_default.KontrolnayaMinimalnayaCenaBeznal
     left join cat_pic  as c_pic on p.id_1c=c_pic.id_1c
     where 1=1
      and p.stock>0  and p.deleted=0  and (p.item_code in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') ) and p.id_provider=1883
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by t.code, stock desc, price_null desc 
                            [1] => 
                        )

                )

            [3] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/vendor/adodb/adodb-php/adodb.inc.php
                    [line] => 2087
                    [function] => GetArray
                    [class] => ADOConnection
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
        select t.* from (
        
        
        select 
         p.id
        
        ,  if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        ))))  as sPFieldDefault
        ,  if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        ))))  as sPField
        ,  if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldDefaultKontrol
        ,  if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldKontrol
            
        , ( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) as sCP
        , ( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) as sCPDef
        , (p.Roznichnaya) as sCPRozn
        
        , if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) )  as sCalcPrice
        , if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as sPriceKontrol
        
        
    ,p.baz_ed_izm
    ,p.prodavat_kratno

    ,p.item_code
    ,p.id_provider
    ,p.code_in
    ,p.code_1c
    ,p.pref
    ,p.cat
    ,p.post_date
    /*,p.term*/
    ,p.stock
    ,if(LENGTH(p.description_ua)>1,p.description_ua,p.description) as description
    /*,ifnull(pgs.id_price_group,0)*/
    ,p.number_min
    ,p.is_restored
    ,p.id_1c
    ,p.url_video
    ,p.country_manufacturer
    ,p.country_brand
     , p.price as price_original
     , c.title as make , c.name as cat_name, c.id_tof as id_brand, c.title as brand, c.image as image_logo, c.id as brand_id
     , concat(ifnull(cp.name,''),' ',ifnull(p.part_eng,'')) as name
     , coalesce(cp.name_rus,p.part_ua,'') as name_translate, ifnull(cp.id, '') as id_cat_part
     , ifnull(cp.has_certificate, 0) as has_certificate
     , p.code as code_, p.item_code as item_code_
     , concat(ifnull(cp.information, ''), ' ', ifnull(if(LENGTH(p.description_ua)>1,p.description_ua,p.description),'')) as information
     , ifnull(concat('ZZZ_',p.id),'') as zzz_code
     , if(p.code in (0),0,1) as crsord
     , up.name as provider, up.name as provider_name, up.code_name as provider_code_name, up.code_delivery, up.is_our_store
     , p.term as term
     , up.term as term_day, up.id_currency
     , ifnull(prg.name,'') as price_group_name
     , ifnull(prg.name_ukr,'') as price_group_name_ukr
     , ifnull(prg.code_name,'') as price_group_code_name
     , pgs.id_price_group
     , prg.`1c_id` as price_group_1c_id, prg.`1c_parent` as price_group_1c_parent
     , if(p.price>0,1,0) as price_null  
      , p.code as code, concat(p.item_code,'::',up.id_user) as code_provider , 0 as pref_order  , 0 as code_order ,  if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price, 
        if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price_order, 
        if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as price_kontrol  ,bus.*,
        /*p.ZCh_Brend ,  
        p.ZCh_TovarnayaGruppa ,  
        p.ZCh_TipZCh ,  */
        p.ZCh_TipZCh as type_TipZCh , 
        p._Standartnaya ,  
        p.Roznichnaya ,  
        p.MinimalnayaCena ,  
        p._MinimalnayaBeznal ,  
        p._MinimalnayaKassa,

      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,6,
      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',5,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh,4,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',3,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,2,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',1,0
      )))))) as priority,
        
        p.tnved,
        p.guarantee,
        p.imported,
        c_pic.id_1c as id_1c_pic
     from price as p
     left join popular_products as pp on p.id_1c=pp.id_1c and pp.bage='offer' and pp.visible=1
     left join price_group_assign as pgs on pgs.item_code=p.item_code
     left join cat_part as cp on cp.item_code=p.item_code
     inner join cat as c on p.pref=c.pref and c.visible=1
     inner join provider_virtual as pv on p.id_provider=pv.id_provider
     inner join user_provider as up on pv.id_provider_virtual=up.id_user
     inner join provider_group as pg on up.id_provider_group=pg.id
     inner join user as u on up.id_user=u.id and u.visible=1
     inner join currency as cu on up.id_currency=cu.id
     left join price_group prg on prg.id=pgs.id_price_group
     left join price_group_param as pgp on pgp.item_code=p.item_code
     left join brand_user_sale bus on /*p.pref=bus.cat_pref and*/ bus.user_id = '' and (
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' )
     )
     left join tipy_cen as tc on bus.ZCh_SpecTipCen=tc.ID 
     left join tipy_cen as tc_kontrol on tc.KontrolnayaMinimalnayaCenaBeznal=tc_kontrol.ID 
         
     left join tipy_cen as tc_default on tc_default.ID=''
     left join tipy_cen as tc_kontrol_default on tc_kontrol_default.ID=tc_default.KontrolnayaMinimalnayaCenaBeznal
     left join cat_pic  as c_pic on p.id_1c=c_pic.id_1c
     where 1=1
      and p.stock>0  and p.deleted=0  and (p.item_code in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') ) and p.id_provider=1883
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by t.code, stock desc, price_null desc 
                            [1] => 
                        )

                )

            [4] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/class/core/Db.php
                    [line] => 137
                    [function] => GetAll
                    [class] => ADOConnection
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
        select t.* from (
        
        
        select 
         p.id
        
        ,  if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        ))))  as sPFieldDefault
        ,  if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        ))))  as sPField
        ,  if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldDefaultKontrol
        ,  if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldKontrol
            
        , ( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) as sCP
        , ( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) as sCPDef
        , (p.Roznichnaya) as sCPRozn
        
        , if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) )  as sCalcPrice
        , if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as sPriceKontrol
        
        
    ,p.baz_ed_izm
    ,p.prodavat_kratno

    ,p.item_code
    ,p.id_provider
    ,p.code_in
    ,p.code_1c
    ,p.pref
    ,p.cat
    ,p.post_date
    /*,p.term*/
    ,p.stock
    ,if(LENGTH(p.description_ua)>1,p.description_ua,p.description) as description
    /*,ifnull(pgs.id_price_group,0)*/
    ,p.number_min
    ,p.is_restored
    ,p.id_1c
    ,p.url_video
    ,p.country_manufacturer
    ,p.country_brand
     , p.price as price_original
     , c.title as make , c.name as cat_name, c.id_tof as id_brand, c.title as brand, c.image as image_logo, c.id as brand_id
     , concat(ifnull(cp.name,''),' ',ifnull(p.part_eng,'')) as name
     , coalesce(cp.name_rus,p.part_ua,'') as name_translate, ifnull(cp.id, '') as id_cat_part
     , ifnull(cp.has_certificate, 0) as has_certificate
     , p.code as code_, p.item_code as item_code_
     , concat(ifnull(cp.information, ''), ' ', ifnull(if(LENGTH(p.description_ua)>1,p.description_ua,p.description),'')) as information
     , ifnull(concat('ZZZ_',p.id),'') as zzz_code
     , if(p.code in (0),0,1) as crsord
     , up.name as provider, up.name as provider_name, up.code_name as provider_code_name, up.code_delivery, up.is_our_store
     , p.term as term
     , up.term as term_day, up.id_currency
     , ifnull(prg.name,'') as price_group_name
     , ifnull(prg.name_ukr,'') as price_group_name_ukr
     , ifnull(prg.code_name,'') as price_group_code_name
     , pgs.id_price_group
     , prg.`1c_id` as price_group_1c_id, prg.`1c_parent` as price_group_1c_parent
     , if(p.price>0,1,0) as price_null  
      , p.code as code, concat(p.item_code,'::',up.id_user) as code_provider , 0 as pref_order  , 0 as code_order ,  if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price, 
        if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price_order, 
        if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as price_kontrol  ,bus.*,
        /*p.ZCh_Brend ,  
        p.ZCh_TovarnayaGruppa ,  
        p.ZCh_TipZCh ,  */
        p.ZCh_TipZCh as type_TipZCh , 
        p._Standartnaya ,  
        p.Roznichnaya ,  
        p.MinimalnayaCena ,  
        p._MinimalnayaBeznal ,  
        p._MinimalnayaKassa,

      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,6,
      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',5,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh,4,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',3,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,2,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',1,0
      )))))) as priority,
        
        p.tnved,
        p.guarantee,
        p.imported,
        c_pic.id_1c as id_1c_pic
     from price as p
     left join popular_products as pp on p.id_1c=pp.id_1c and pp.bage='offer' and pp.visible=1
     left join price_group_assign as pgs on pgs.item_code=p.item_code
     left join cat_part as cp on cp.item_code=p.item_code
     inner join cat as c on p.pref=c.pref and c.visible=1
     inner join provider_virtual as pv on p.id_provider=pv.id_provider
     inner join user_provider as up on pv.id_provider_virtual=up.id_user
     inner join provider_group as pg on up.id_provider_group=pg.id
     inner join user as u on up.id_user=u.id and u.visible=1
     inner join currency as cu on up.id_currency=cu.id
     left join price_group prg on prg.id=pgs.id_price_group
     left join price_group_param as pgp on pgp.item_code=p.item_code
     left join brand_user_sale bus on /*p.pref=bus.cat_pref and*/ bus.user_id = '' and (
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' )
     )
     left join tipy_cen as tc on bus.ZCh_SpecTipCen=tc.ID 
     left join tipy_cen as tc_kontrol on tc.KontrolnayaMinimalnayaCenaBeznal=tc_kontrol.ID 
         
     left join tipy_cen as tc_default on tc_default.ID=''
     left join tipy_cen as tc_kontrol_default on tc_kontrol_default.ID=tc_default.KontrolnayaMinimalnayaCenaBeznal
     left join cat_pic  as c_pic on p.id_1c=c_pic.id_1c
     where 1=1
      and p.stock>0  and p.deleted=0  and (p.item_code in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') ) and p.id_provider=1883
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by t.code, stock desc, price_null desc 
                        )

                )

            [5] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/class/module/Catalog.php
                    [line] => 2777
                    [function] => GetAll
                    [class] => Core\Db
                    [type] => ::
                    [args] => Array
                        (
                            [0] => 
        select t.* from (
        
        
        select 
         p.id
        
        ,  if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        ))))  as sPFieldDefault
        ,  if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        ))))  as sPField
        ,  if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldDefaultKontrol
        ,  if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      ))))  as sPFieldKontrol
            
        , ( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) as sCP
        , ( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) as sCPDef
        , (p.Roznichnaya) as sCPRozn
        
        , if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) )  as sCalcPrice
        , if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as sPriceKontrol
        
        
    ,p.baz_ed_izm
    ,p.prodavat_kratno

    ,p.item_code
    ,p.id_provider
    ,p.code_in
    ,p.code_1c
    ,p.pref
    ,p.cat
    ,p.post_date
    /*,p.term*/
    ,p.stock
    ,if(LENGTH(p.description_ua)>1,p.description_ua,p.description) as description
    /*,ifnull(pgs.id_price_group,0)*/
    ,p.number_min
    ,p.is_restored
    ,p.id_1c
    ,p.url_video
    ,p.country_manufacturer
    ,p.country_brand
     , p.price as price_original
     , c.title as make , c.name as cat_name, c.id_tof as id_brand, c.title as brand, c.image as image_logo, c.id as brand_id
     , concat(ifnull(cp.name,''),' ',ifnull(p.part_eng,'')) as name
     , coalesce(cp.name_rus,p.part_ua,'') as name_translate, ifnull(cp.id, '') as id_cat_part
     , ifnull(cp.has_certificate, 0) as has_certificate
     , p.code as code_, p.item_code as item_code_
     , concat(ifnull(cp.information, ''), ' ', ifnull(if(LENGTH(p.description_ua)>1,p.description_ua,p.description),'')) as information
     , ifnull(concat('ZZZ_',p.id),'') as zzz_code
     , if(p.code in (0),0,1) as crsord
     , up.name as provider, up.name as provider_name, up.code_name as provider_code_name, up.code_delivery, up.is_our_store
     , p.term as term
     , up.term as term_day, up.id_currency
     , ifnull(prg.name,'') as price_group_name
     , ifnull(prg.name_ukr,'') as price_group_name_ukr
     , ifnull(prg.code_name,'') as price_group_code_name
     , pgs.id_price_group
     , prg.`1c_id` as price_group_1c_id, prg.`1c_parent` as price_group_1c_parent
     , if(p.price>0,1,0) as price_null  
      , p.code as code, concat(p.item_code,'::',up.id_user) as code_provider , 0 as pref_order  , 0 as code_order ,  if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price, 
        if(if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) <if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )),if(bus.sale is not null, if(( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ) <> 0,( if(tc.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc.name='_Стандартная',p._Standartnaya,
        if(tc.name='_Розничная',p.Roznichnaya,0
        )))) *((100-bus.sale)/100) ),(p.Roznichnaya)), if(( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ) <> 0,( if(tc_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
        if(tc_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
        if(tc_default.name='_Стандартная',p._Standartnaya,
        if(tc_default.name='_Розничная',p.Roznichnaya,0
        )))) *((100-0)/100) ),(p.Roznichnaya)) ) ) as price_order, 
        if(bus.sale is not null,( if(tc_kontrol.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol.name='_Розничная',p.Roznichnaya,0
      )))) ),( if(tc_kontrol_default.name='_МинимальнаяБезнал',p._MinimalnayaBeznal,
      if(tc_kontrol_default.name='_МинимальнаяКасса',p._MinimalnayaKassa,
      if(tc_kontrol_default.name='_Стандартная',p._Standartnaya,
      if(tc_kontrol_default.name='_Розничная',p.Roznichnaya,0
      )))) )) as price_kontrol  ,bus.*,
        /*p.ZCh_Brend ,  
        p.ZCh_TovarnayaGruppa ,  
        p.ZCh_TipZCh ,  */
        p.ZCh_TipZCh as type_TipZCh , 
        p._Standartnaya ,  
        p.Roznichnaya ,  
        p.MinimalnayaCena ,  
        p._MinimalnayaBeznal ,  
        p._MinimalnayaKassa,

      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,6,
      if(p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',5,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh,4,
      if(p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',3,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh,2,
      if(bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000',1,0
      )))))) as priority,
        
        p.tnved,
        p.guarantee,
        p.imported,
        c_pic.id_1c as id_1c_pic
     from price as p
     left join popular_products as pp on p.id_1c=pp.id_1c and pp.bage='offer' and pp.visible=1
     left join price_group_assign as pgs on pgs.item_code=p.item_code
     left join cat_part as cp on cp.item_code=p.item_code
     inner join cat as c on p.pref=c.pref and c.visible=1
     inner join provider_virtual as pv on p.id_provider=pv.id_provider
     inner join user_provider as up on pv.id_provider_virtual=up.id_user
     inner join provider_group as pg on up.id_provider_group=pg.id
     inner join user as u on up.id_user=u.id and u.visible=1
     inner join currency as cu on up.id_currency=cu.id
     left join price_group prg on prg.id=pgs.id_price_group
     left join price_group_param as pgp on pgp.item_code=p.item_code
     left join brand_user_sale bus on /*p.pref=bus.cat_pref and*/ bus.user_id = '' and (
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( p.ZCh_Brend=bus.ZCh_Brend and bus.ZCh_TovarnayaGruppa='00000000-0000-0000-0000-000000000000' and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and p.ZCh_TipZCh=bus.ZCh_TipZCh ) or
         ( bus.ZCh_Brend='00000000-0000-0000-0000-000000000000' and p.ZCh_TovarnayaGruppa=bus.ZCh_TovarnayaGruppa and bus.ZCh_TipZCh='00000000-0000-0000-0000-000000000000' )
     )
     left join tipy_cen as tc on bus.ZCh_SpecTipCen=tc.ID 
     left join tipy_cen as tc_kontrol on tc.KontrolnayaMinimalnayaCenaBeznal=tc_kontrol.ID 
         
     left join tipy_cen as tc_default on tc_default.ID=''
     left join tipy_cen as tc_kontrol_default on tc_kontrol_default.ID=tc_default.KontrolnayaMinimalnayaCenaBeznal
     left join cat_pic  as c_pic on p.id_1c=c_pic.id_1c
     where 1=1
      and p.stock>0  and p.deleted=0  and (p.item_code in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('EQA_Д24С20Б','EQA_111107010','EQA_2401015671','EQA_75241095Б','EQA_Д24С06ГР3','EQA_5010240922А','EQA_501024029В','EQA_350120951001','EQA_2401024116','EQA_РПД2002А','EQA_3501200510','EQA_Д24022А','EQA_2401024115','EQA_35001005000','EQA_2401015650А','EQA_3500301100','EQA_3Х5','EQA_СТ362А3708000','EQA_2401015571А','EQA_Д24С18А','EQA_Д24020Б','EQA_СМД219181','EQA_3501208000','EQA_Д24072Б','EQA_Д27102','EQA_М124Б13728000А','EQA_М149А','EQA_2401024119','EQA_Д24101А','EQA_Д27101','EQA_Д24С09В','EQA_3501211100','EQA_3500100201','EQA_111107010387521001','EQA_М124Б3','EQA_А11','EQA_501024029В01','EQA_СТД24127А1Р1','EQA_Д24079','EQA_Д24075Б','EQA_Д24С015','EQA_КОМПТПРКПД10','BJB_А11','EUI_Д27102','EUI_501024029В','EUI_Д24072Б','FAG_35001005000','EUI_2401015650А','EUI_2401024119','EUI_Д24079','EUI_3501208000','EUI_3501200510','EUI_3501211100','EUI_РПД2002А','EZD_КОМПТПРКПД10','EUI_2401015571А','EUR_Д24С06ГР3','EWD_2401015671','EUI_75241095Б','EWU_Д24101А','ERO_111107010387521001','EUI_СМД219181','EUI_3500100201','EUI_350120951001','EUI_2401024115','DAU_Д24С015','EUI_3Х5','EYD_Д24С20Б','EUI_2401024116','DAU_Д24С20Б','EUI_Д24020Б','ETC_5010240922А','EUI_501024029В01','FAG_СТ362А3708000','EUI_3500301100','EUI_Д24022А','ERO_М124Б13728000А','EUI_Д27101','EYI_Д24075Б','ERR_Д24033Б','FAX_Д24С09В','FAX_Д24С18А','EYT_СТД24127А1Р1','EYT_СТД24127А1Р2','EYT_СТД24127А1Н','EUR_Д24023ДН','FAX_111107010','FAX_ПД10Н1','EUI_РПД2000','FAX_35001005000','EUI_7524С321А','EUR_Д24023ДР2','EUI_501024111А','FAX_ПД10Р2','EUR_Д24023ДР1','EZD_Д24026А','EUI_Д24019В','ETC_Д27С11В','FAX_3501202501','EUI_Д27С12В','EUI_Д27111','EUI_РПД1040','EUI_РПД2010','EUI_СМД219С71Б','EUI_СМД819041Г','EUI_РПД1000М','EUI_3500100101','EUI_Д24С21В','EUI_3500405000','EUI_РПД10032','EUI_РПД1005А','FAX_3500301012','EUI_СМД21954Б','EQA_70Л1024315','EUI_СМД21917А','EUI_75241043Г','EUI_Д27С15А','EUI_Д271061А','EUI_Д271051А','EUI_Д27116Б','EUI_3501202710','EUI_3500105001','EUI_3500100301','EUI_5Х9','EUI_4Х65','EUI_Д24047А','EUI_Д24070','EQA_СТ362А3708','FAX_701119020','EUP_3500100500','FAX_362А600','FAX_СМД21916110','FAX_СМД21915110','FAX_70Л1119070','FAX_РКПД10','EUI_Д24С0141','FAX_Д24028','FAX_СТ367А3708','FAX_141905А','FAX_ПД10Р3','EQA_Д27С15А','FAX_Д24С015','DAU_М124Б3','EQA_50Л1024270','FAX_ПД10Р1','EZD_7524С321','FAX_СМД219141','EQA_362А800','ERP_68000','FAX_3501207400','FAG_Д24033Б','FAG_111107010387521001','EVS_СТД24127А1Р2','EVS_СТД24127А1Н','FAG_М124Б13728000А','EVS_СТД24127А1Р1','DAU_5010240922А','FKP_КОМПТПРКПД10','EVO_Д24С20Б','ETC_М124Б13728000А','ETC_111107010','FKP_3661','EVO_111107010387521001','EVO_М124Б13728000А','ESJ_ПУПДМ10','EVO_362А800','ESJ_Д27С15А','EVO_Д24С09В','EVO_Д27С15А','ETC_М124Б13728000Б3','ETC_М124Б13728000Б1','EYD_М124Б33728000','DAU_3500302000','DAU_ПД101119560','DAU_3500405000','DAU_35001005000','DAU_СТ362А3708','DAU_Д24033Б','FAG_СТД24127А1Н','EVO_35001005000','DAU_А11','DAU_Д24С09В','FAG_Д24023Г','FOA_7524С321','FOA_Д24026А','FNZ_Д27С11В','FNZ_М124Б13728000Б1','FNZ_111107010','FNI_СТД24127А','FNI_СТД24127АР1','FNI_СТД24127АР3','FNI_СТД24127АР2','DAU_М149А3728000','ESJ_РПД10200032','FAG_Д24С20Б','EVO_А11','DAU_111107010387521001','FAG_111107010','FAG_Д24026А','EQA_М124Б13728000Б1','FPU_Д24026А','FPU_7524С321','FAG_7524С321','FAG_75241095Б','DAU_А113707','FRB_РПД10032','EUI_3501209412','FRB_3501209412РПД10032') ) and p.id_provider=1883
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by t.code, stock desc, price_null desc 
                        )

                )

            [6] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/spec/catalog.php
                    [line] => 38
                    [function] => ViewInfoPart
                    [class] => Module\Catalog
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [7] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/action_includer.php
                    [line] => 46
                    [args] => Array
                        (
                            [0] => /var/www/atpvko/atp.com.ua/spec/catalog.php
                        )

                    [function] => include_once
                )

            [8] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/index.php
                    [line] => 23
                    [args] => Array
                        (
                            [0] => /var/www/atpvko/atp.com.ua/action_includer.php
                        )

                    [function] => require
                )

        )

    [user_agent] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
    [refer] => https://atp.com.ua/buy/GZPD_5%D0%A59_77849
    [request_uri] => /buy/GZPD_5%D0%A59_77849/
    [request_data] => Array
        (
            [locale] => ua
            [action] => catalog_part_info_view
            [cat_name] => GZPD
            [code] => 5Х9
            [code_id] => 77849
            [PHPSESSID] => 70b39d4008fdfdd987dd3736fa9cbc12
            [id_region] => 0
        )

    [session_data] => Array
        (
            [mobile] => 0
            [spam_form_token] => b65d41cf272f3f86e7841b1a6a74af37
            [referer_page] => locale=&action=catalog_part_info_view&cat_name=GZPD&code=5Х9&code_id=77849
            [current_page] => locale=&action=catalog_part_info_view&cat_name=GZPD&code=5Х9&code_id=77849
        )

)
</pre>