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)>1,p.description,p.description_ua) 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_rus,'') 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)>1,p.description,p.description_ua),'')) 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.deleted=0  and (p.item_code in ('FAX_2601602312','BGO_T207249') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('FAX_2601602312','BGO_T207249') )
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by stock desc, t.code, 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)>1,p.description,p.description_ua) 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_rus,'') 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)>1,p.description,p.description_ua),'')) 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.deleted=0  and (p.item_code in ('FAX_2601602312','BGO_T207249') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('FAX_2601602312','BGO_T207249') )
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by stock desc, t.code, 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.23
                                            [client_version] => 80423
                                            [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.8-MariaDB-deb13-log
                                            [server_version] => 110808
                                            [sqlstate] => HY000
                                            [protocol_version] => 10
                                            [thread_id] => 361552
                                            [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)>1,p.description,p.description_ua) 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_rus,'') 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)>1,p.description,p.description_ua),'')) 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.deleted=0  and (p.item_code in ('FAX_2601602312','BGO_T207249') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('FAX_2601602312','BGO_T207249') )
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by stock desc, t.code, 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)>1,p.description,p.description_ua) 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_rus,'') 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)>1,p.description,p.description_ua),'')) 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.deleted=0  and (p.item_code in ('FAX_2601602312','BGO_T207249') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('FAX_2601602312','BGO_T207249') )
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by stock desc, t.code, 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)>1,p.description,p.description_ua) 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_rus,'') 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)>1,p.description,p.description_ua),'')) 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.deleted=0  and (p.item_code in ('FAX_2601602312','BGO_T207249') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('FAX_2601602312','BGO_T207249') )
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by stock desc, t.code, 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)>1,p.description,p.description_ua) 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_rus,'') 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)>1,p.description,p.description_ua),'')) 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.deleted=0  and (p.item_code in ('FAX_2601602312','BGO_T207249') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('FAX_2601602312','BGO_T207249') )
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by stock desc, t.code, price_null desc 
                        )

                )

            [5] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/class/system/Content.php
                    [line] => 1278
                    [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)>1,p.description,p.description_ua) 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_rus,'') 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)>1,p.description,p.description_ua),'')) 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.deleted=0  and (p.item_code in ('FAX_2601602312','BGO_T207249') or CONCAT( VendorOEM,  '_', NumberOEM ) in ('FAX_2601602312','BGO_T207249') )
         
         having 1 order by priority desc ) as t 
        group by t.id 
         
          order by stock desc, t.code, price_null desc 
                        )

                )

            [6] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/class/system/Content.php
                    [line] => 350
                    [function] => GetViewedBlockData
                    [class] => System\Content
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

            [7] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/class/core/Base.php
                    [line] => 553
                    [function] => Init
                    [class] => System\Content
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

            [8] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/init.php
                    [line] => 129
                    [function] => Init
                    [class] => Core\Base
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

            [9] => Array
                (
                    [file] => /var/www/atpvko/atp.com.ua/index.php
                    [line] => 16
                    [args] => Array
                        (
                            [0] => /var/www/atpvko/atp.com.ua/init.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/pages/user_change_current_locale/?new_loc=ru&url=%2Fru%2Fbuy%2FSILA_650551323220_182558%2F
    [request_uri] => /ru/buy/SILA_650551323220_182558/
    [request_data] => Array
        (
            [locale] => ru
            [action] => catalog_part_info_view
            [cat_name] => SILA
            [code] => 650551323220
            [code_id] => 182558
            [PHPSESSID] => 179efd594176de1bff974d08ec180c6c
            [current_locale] => ru
            [id_region] => 0
        )

    [session_data] => Array
        (
            [mobile] => 0
            [spam_form_token] => e0f3d41768972df59faccf844a4ee6bc
            [referer_page] => action=user_change_current_locale&new_loc=ru&url=%2Fru%2Fbuy%2FSILA_650551323220_182558%2F
            [current_page] => locale=ru&action=catalog_part_info_view&cat_name=SILA&code=650551323220&code_id=182558
        )

)
</pre>