Суппорта и их комплектующие

Прокладки, уплотнители

10.015.17480
UNIVERSAL Суппорт - MERITOR - ELSA 1
10.015.13404
UNIVERSAL Суппорт - WABCO - PAN17, PAN19 Single piston
10.015.13441
VOLVO - Series FH ver.1, 2, Series FM ver.1, 2 Суппорт - MERITOR - Series DUCO
10.015.14969
UNIVERSAL Суппорт - MERITOR - Series ELSA 195/225, ELSA 2
10.015.15004
UNIVERSAL Суппорт - MERITOR - D3
10.015.15041
VOLVO Суппорт - MERITOR - Series DUCO
10.015.15042
VOLVO Суппорт - MERITOR - Series DUCO
10.015.17513
UNIVERSAL Суппорт - MERITOR - ELSA 1
10.015.17543
MAN Суппорт - MERITOR - ELSA 1
10.015.18390
UNIVERSAL Суппорт - MERITOR - ELSA 2 Axial
1 2
searchПоиск товара
Марка, модель автомобиля
Агрегат
Высота, мм
от до
Диаметр наружный, мм
от до
Начать поиск Очистить фильтр
Корзина
Ваша корзина пуста
Контакты
t. +371 67248906 @ v7@oldi.net 
SELECT * FROM `waregroup` WHERE `waregroup`.devfilter IS TRUE and `WareGroupID` = 10

SELECT * FROM (
                                SELECT  wn.*,  (
                                                SELECT COUNT(g.GoodsID) 
                                                FROM goods AS g 
                                                
                                                WHERE g.wareGroupID=10 
                                                AND g.warenameid=wn.warenameid 
                                                AND  (`g`.`Disabled` <> 1 OR `g`.`Disabled` IS NULL) 
                                                AND `g`.`GoodsID` < '60000'
                                                
                                                )
                                                
 AS KolVo  FROM warename AS wn) AS tmpx 
            
            WHERE KolVO>0  order by `WareName` 

select  `g`.*
                    from 
                    (select `g`.*,  `skladb`.WebActionPrice(`ga`.`Price`*1, '0') AS ORDERPrice, ga.Actioncomment AS ORDERCommment, CAST(ga.Checked AS UNSIGNED INTEGER) as `checked`
                    from `goods` as `g` LEFT JOIN `skladb`.goodsaction AS ga ON (ga.goodsid=g.goodsid and ga.userid=20 AND ga.Checked=1)
                    where (`g`.`WareNameID` = '1910' or  warenameid in (select warenameid from websearchgroupwn where websearchgroupid='0'))  
                    and `g`.`GoodsID` < '60000'
                    and (`g`.`Disabled` <> 1 OR `g`.`Disabled` is NULL) ) as `g`
                    
                    group by `g`.`GoodsID`
                    order by `g`.`checked` desc, `g`.`GoodsID`
                    
                     limit 0, 10

select SQL_CALC_FOUND_ROWS  `g`.*
                    from 
                    (select `g`.*,  `skladb`.WebActionPrice(`ga`.`Price`*1, '0') AS ORDERPrice, ga.Actioncomment AS ORDERCommment, CAST(ga.Checked AS UNSIGNED INTEGER) as `checked`
                    from `goods` as `g` LEFT JOIN `skladb`.goodsaction AS ga ON (ga.goodsid=g.goodsid and ga.userid=20 AND ga.Checked=1)
                    where (`g`.`WareNameID` = '1910' or  warenameid in (select warenameid from websearchgroupwn where websearchgroupid='0'))  
                    and `g`.`GoodsID` < '60000'
                    and (`g`.`Disabled` <> 1 OR `g`.`Disabled` is NULL) ) as `g`
                    
                    group by `g`.`GoodsID`
                    order by `g`.`checked` desc, `g`.`GoodsID`
                    
                     limit 1

SELECT FOUND_ROWS() as cnt;

SELECT cc.`GoodsID` AS id
                FROM catalogcode_cut AS ccc
                LEFT JOIN catalogcode AS cc  ON cc.`CatalogCodeID` = ccc.`catalogcodeid`
                WHERE code_cut = ''


0.0015358924865723
select `g`.`GoodsID`
            from `goods` as `g`
            LEFT JOIN `analog` as `a` ON (`a`.`AnalogGoodsID` = `g`.`goodsid`) 
            LEFT JOIN analogtype AS b ON (`a`.`AnalogTypeID` = `b`.`analogtypeID`) 
            LEFT JOIN analogtype AS c ON (`b`.`LinkedAnalogTypeID` = `c`.`analogtypeID`) 
            where `a`.`goodsId` in ('17480', '13404', '13441', '14969', '15004', '15041', '15042', '17513', '17543', '18390')
            and `b`.`UseInSearch` = 1
            


Full:1761833879.8304

Array
(
    [0] => Array
        (
            [GoodsID] => 17480
            [WareNameID] => 1910
            [WareGroupID] => 10
            [WareCodeInGroup] => 15
            [WareCommentID] => 
            [AutoMakeID] => 13
            [AutoModelID] => 1029
            [AutoEngineID] => 
            [CustomGroupID] => 40
            [CustomGroupNR] => 
            [TNVDID] => 193
            [PackTypeID] => 
            [UnitID] => 3
            [Weight] => 0.020
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ELSA 1     

            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 10
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 0.00
            [ORDERCommment] => 
            [checked] => 1
            [oldi_nr] => 10.015.17480
            [qnt] => 7
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => UNIVERSAL
                )

            [dev] => Array
                (
                    [0] => Суппорт - MERITOR - ELSA 1
                )

        )

    [1] => Array
        (
            [GoodsID] => 13404
            [WareNameID] => 1910
            [WareGroupID] => 10
            [WareCodeInGroup] => 15
            [WareCommentID] => 0
            [AutoMakeID] => 13
            [AutoModelID] => 565
            [AutoEngineID] => 0
            [CustomGroupID] => 40
            [CustomGroupNR] => 
            [TNVDID] => 140
            [PackTypeID] => 
            [UnitID] => 3
            [Weight] => 0.040
            [QtyInPack] => 0
            [Place] => 
            [Comment] => WABCO 17.5, 19.5 DAF LF45/LF55, MAN L2000, SAF 
 -  + ;       ,   = .21997
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 8
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 10.015.13404
            [qnt] => 2
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => UNIVERSAL
                )

            [dev] => Array
                (
                    [0] => Суппорт - WABCO - PAN17, PAN19 Single piston
                )

        )

    [2] => Array
        (
            [GoodsID] => 13441
            [WareNameID] => 1910
            [WareGroupID] => 10
            [WareCodeInGroup] => 15
            [WareCommentID] => 0
            [AutoMakeID] => 1
            [AutoModelID] => 1029
            [AutoEngineID] => 0
            [CustomGroupID] => 40
            [CustomGroupNR] => 
            [TNVDID] => 140
            [PackTypeID] => 
            [UnitID] => 3
            [Weight] => 0.020
            [QtyInPack] => 0
            [Place] => 
            [Comment] => MERITOR 22.5  + 
            [Product] => 0
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 4
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 10.015.13441
            [qnt] => 6
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => VOLVO - Series FH ver.1, 2, Series FM ver.1, 2
                )

            [dev] => Array
                (
                    [0] => Суппорт - MERITOR - Series DUCO
                )

        )

    [3] => Array
        (
            [GoodsID] => 14969
            [WareNameID] => 1910
            [WareGroupID] => 10
            [WareCodeInGroup] => 15
            [WareCommentID] => 
            [AutoMakeID] => 1017
            [AutoModelID] => 1029
            [AutoEngineID] => 
            [CustomGroupID] => 40
            [CustomGroupNR] => 
            [TNVDID] => 1
            [PackTypeID] => 
            [UnitID] => 2
            [Weight] => 0.100
            [QtyInPack] => 0
            [Place] => 
            [Comment] => MERITOR ELSA2   -  
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 10
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 10.015.14969
            [qnt] => 5
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => UNIVERSAL
                )

            [dev] => Array
                (
                    [0] => Суппорт - MERITOR - Series ELSA 195/225, ELSA 2
                )

        )

    [4] => Array
        (
            [GoodsID] => 15004
            [WareNameID] => 1910
            [WareGroupID] => 10
            [WareCodeInGroup] => 15
            [WareCommentID] => 1082
            [AutoMakeID] => 13
            [AutoModelID] => 1029
            [AutoEngineID] => 
            [CustomGroupID] => 40
            [CustomGroupNR] => 
            [TNVDID] => 140
            [PackTypeID] => 
            [UnitID] => 3
            [Weight] => 0.200
            [QtyInPack] => 0
            [Place] => 
            [Comment] => MERITOR D3    + ,  50x65x8,  51x55x20
C   - 15006 (R)    15005 (L)
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 8
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 10.015.15004
            [qnt] => 3
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => UNIVERSAL
                )

            [dev] => Array
                (
                    [0] => Суппорт - MERITOR - D3
                )

        )

    [5] => Array
        (
            [GoodsID] => 15041
            [WareNameID] => 1910
            [WareGroupID] => 10
            [WareCodeInGroup] => 15
            [WareCommentID] => 
            [AutoMakeID] => 1
            [AutoModelID] => 1029
            [AutoEngineID] => 
            [CustomGroupID] => 40
            [CustomGroupNR] => 
            [TNVDID] => 40
            [PackTypeID] => 
            [UnitID] => 3
            [Weight] => 0.200
            [QtyInPack] => 0
            [Place] => 
            [Comment] => MERITOR DUCO  
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 8
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 10.015.15041
            [qnt] => 6
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => VOLVO
                )

            [dev] => Array
                (
                    [0] => Суппорт - MERITOR - Series DUCO
                )

        )

    [6] => Array
        (
            [GoodsID] => 15042
            [WareNameID] => 1910
            [WareGroupID] => 10
            [WareCodeInGroup] => 15
            [WareCommentID] => 
            [AutoMakeID] => 1
            [AutoModelID] => 1029
            [AutoEngineID] => 
            [CustomGroupID] => 40
            [CustomGroupNR] => 
            [TNVDID] => 40
            [PackTypeID] => 
            [UnitID] => 3
            [Weight] => 0.200
            [QtyInPack] => 0
            [Place] => 
            [Comment] => MERITOR DUCO  

            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 8
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 10.015.15042
            [qnt] => 3
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => VOLVO
                )

            [dev] => Array
                (
                    [0] => Суппорт - MERITOR - Series DUCO
                )

        )

    [7] => Array
        (
            [GoodsID] => 17513
            [WareNameID] => 1910
            [WareGroupID] => 10
            [WareCodeInGroup] => 15
            [WareCommentID] => 
            [AutoMakeID] => 13
            [AutoModelID] => 1029
            [AutoEngineID] => 
            [CustomGroupID] => 40
            [CustomGroupNR] => 
            [TNVDID] => 193
            [PackTypeID] => 
            [UnitID] => 3
            [Weight] => 0.200
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ELSA 1     
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 12
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 10.015.17513
            [qnt] => 4
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => UNIVERSAL
                )

            [dev] => Array
                (
                    [0] => Суппорт - MERITOR - ELSA 1
                )

        )

    [8] => Array
        (
            [GoodsID] => 17543
            [WareNameID] => 1910
            [WareGroupID] => 10
            [WareCodeInGroup] => 15
            [WareCommentID] => 
            [AutoMakeID] => 14
            [AutoModelID] => 1029
            [AutoEngineID] => 
            [CustomGroupID] => 40
            [CustomGroupNR] => 
            [TNVDID] => 193
            [PackTypeID] => 
            [UnitID] => 3
            [Weight] => 0.200
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ELSA 1     
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 17
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 10.015.17543
            [qnt] => 4
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => MAN
                )

            [dev] => Array
                (
                    [0] => Суппорт - MERITOR - ELSA 1
                )

        )

    [9] => Array
        (
            [GoodsID] => 18390
            [WareNameID] => 1910
            [WareGroupID] => 10
            [WareCodeInGroup] => 15
            [WareCommentID] => 
            [AutoMakeID] => 13
            [AutoModelID] => 1029
            [AutoEngineID] => 
            [CustomGroupID] => 40
            [CustomGroupNR] => 
            [TNVDID] => 1
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 0.100
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ELSA 2     .14960 ( .17519 - )
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 10
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 10.015.18390
            [qnt] => 5
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => UNIVERSAL
                )

            [dev] => Array
                (
                    [0] => Суппорт - MERITOR - ELSA 2 Axial
                )

        )

)


supplierProducts:0.0020577907562256

Full:1761833879.8309