Exhaust system

Exhaust pipe with corrugation

29.032.00461
DAF - 95-XF, XF-95
29.032.15633
MERCEDES - ACTROS I, ACTROS II, ACTROS III Diameter, mm: 126 Length, mm: 780
29.032.26057
MERCEDES - ACTROS IV, AXOR II, ANTOS
29.032.00441
DAF - 95-XF Diameter, mm: 127 Diameter, mm: 127
29.032.00459
DAF - F-95, 95-XF
29.032.00460
DAF - 95-XF
29.032.00927
MERCEDES - Series ATEGO, AXOR II Diameter, mm: 90
29.032.01306
MERCEDES - Series SPRINTER
29.032.10778
MERCEDES - Series ACTROS
29.032.11918
MERCEDES - Series ACTROS, Series ATEGO
1 2 3 4 5 6 7
searchПоиск товара
Vehicle model
Clear filter
Cart
Your cart is empty
Contacts
t. +371 67248906 @ v7@oldi.net 
SELECT * FROM `waregroup` WHERE `waregroup`.devfilter IS TRUE and `WareGroupID` = 29

SELECT * FROM (
                                SELECT  wn.*,  (
                                                SELECT COUNT(g.GoodsID) 
                                                FROM goods AS g 
                                                
                                                WHERE g.wareGroupID=29 
                                                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 `WareNameEng` 

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` = '2518' 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` = '2518' 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.001072883605957
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 ('461', '15633', '26057', '441', '459', '460', '927', '1306', '10778', '11918')
            and `b`.`UseInSearch` = 1
            


Full:1761833891.9597

Array
(
    [0] => Array
        (
            [GoodsID] => 461
            [WareNameID] => 2518
            [WareGroupID] => 29
            [WareCodeInGroup] => 32
            [WareCommentID] => 0
            [AutoMakeID] => 9
            [AutoModelID] => 407
            [AutoEngineID] => 0
            [CustomGroupID] => 33
            [CustomGroupNR] => 87089290
            [TNVDID] => 33
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 7.095
            [QtyInPack] => 0
            [Place] => 
            [Comment] => 
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 11
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 0.00
            [ORDERCommment] => 
            [checked] => 1
            [oldi_nr] => 29.032.00461
            [qnt] => 3
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => DAF - 95-XF, XF-95
                )

            [dev] => Array
                (
                    [0] => 
                )

        )

    [1] => Array
        (
            [GoodsID] => 15633
            [WareNameID] => 2518
            [WareGroupID] => 29
            [WareCodeInGroup] => 32
            [WareCommentID] => 
            [AutoMakeID] => 5
            [AutoModelID] => 1536
            [AutoEngineID] => 16
            [CustomGroupID] => 33
            [CustomGroupNR] => 
            [TNVDID] => 33
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 4.200
            [QtyInPack] => 0
            [Place] => 
            [Comment] =>    .
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 1
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 0.00
            [ORDERCommment] => 
            [checked] => 1
            [oldi_nr] => 29.032.15633
            [qnt] => 10
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 2
                            [Property] => , 
                            [PropertyLV] => Diametrs, mm
                            [PropertyEN] => Diameter, mm
                            [Type] => 0
                            [Value] => 126
                            [name] => Array
                                (
                                    [1] => Диаметр, мм
                                    [2] => Diameter, mm
                                    [3] => Diametrs, mm
                                )

                        )

                    [1] => Array
                        (
                            [PropertyID] => 5
                            [Property] => , 
                            [PropertyLV] => Garums, mm
                            [PropertyEN] => Length, mm
                            [Type] => 0
                            [Value] => 780
                            [name] => Array
                                (
                                    [1] => Длина, мм
                                    [2] => Length, mm
                                    [3] => Garums, mm
                                )

                        )

                )

            [models] => Array
                (
                    [0] => MERCEDES - ACTROS I, ACTROS II, ACTROS III
                )

            [dev] => Array
                (
                    [0] => 
                )

        )

    [2] => Array
        (
            [GoodsID] => 26057
            [WareNameID] => 2518
            [WareGroupID] => 29
            [WareCodeInGroup] => 32
            [WareCommentID] => 
            [AutoMakeID] => 5
            [AutoModelID] => 567
            [AutoEngineID] => 
            [CustomGroupID] => 33
            [CustomGroupNR] => 
            [TNVDID] => 33
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 3.000
            [QtyInPack] => 0
            [Place] => 
            [Comment] => 
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 2
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 0.00
            [ORDERCommment] => 
            [checked] => 1
            [oldi_nr] => 29.032.26057
            [qnt] => 6
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => MERCEDES - ACTROS IV, AXOR II, ANTOS
                )

            [dev] => Array
                (
                    [0] => 
                )

        )

    [3] => Array
        (
            [GoodsID] => 441
            [WareNameID] => 2518
            [WareGroupID] => 29
            [WareCodeInGroup] => 32
            [WareCommentID] => 0
            [AutoMakeID] => 9
            [AutoModelID] => 187
            [AutoEngineID] => 0
            [CustomGroupID] => 33
            [CustomGroupNR] => 87089290
            [TNVDID] => 33
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 7.714
            [QtyInPack] => 0
            [Place] => 
            [Comment] => 
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 50
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 29.032.00441
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 2
                            [Property] => , 
                            [PropertyLV] => Diametrs, mm
                            [PropertyEN] => Diameter, mm
                            [Type] => 0
                            [Value] => 127
                            [name] => Array
                                (
                                    [1] => Диаметр, мм
                                    [2] => Diameter, mm
                                    [3] => Diametrs, mm
                                )

                        )

                    [1] => Array
                        (
                            [PropertyID] => 2
                            [Property] => , 
                            [PropertyLV] => Diametrs, mm
                            [PropertyEN] => Diameter, mm
                            [Type] => 0
                            [Value] => 127
                            [name] => Array
                                (
                                    [1] => Диаметр, мм
                                    [2] => Diameter, mm
                                    [3] => Diametrs, mm
                                )

                        )

                )

            [models] => Array
                (
                    [0] => DAF - 95-XF
                )

            [dev] => Array
                (
                    [0] => 
                )

        )

    [4] => Array
        (
            [GoodsID] => 459
            [WareNameID] => 2518
            [WareGroupID] => 29
            [WareCodeInGroup] => 32
            [WareCommentID] => 0
            [AutoMakeID] => 9
            [AutoModelID] => 407
            [AutoEngineID] => 0
            [CustomGroupID] => 33
            [CustomGroupNR] => 87089290
            [TNVDID] => 33
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 8.060
            [QtyInPack] => 0
            [Place] => 
            [Comment] => 
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 10
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 29.032.00459
            [qnt] => 1
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => DAF - F-95, 95-XF
                )

            [dev] => Array
                (
                    [0] => 
                )

        )

    [5] => Array
        (
            [GoodsID] => 460
            [WareNameID] => 2518
            [WareGroupID] => 29
            [WareCodeInGroup] => 32
            [WareCommentID] => 0
            [AutoMakeID] => 9
            [AutoModelID] => 187
            [AutoEngineID] => 0
            [CustomGroupID] => 33
            [CustomGroupNR] => 87089290
            [TNVDID] => 33
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 6.880
            [QtyInPack] => 0
            [Place] => 
            [Comment] => 
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 10
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 29.032.00460
            [qnt] => 2
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => DAF - 95-XF
                )

            [dev] => Array
                (
                    [0] => 
                )

        )

    [6] => Array
        (
            [GoodsID] => 927
            [WareNameID] => 2518
            [WareGroupID] => 29
            [WareCodeInGroup] => 32
            [WareCommentID] => 0
            [AutoMakeID] => 5
            [AutoModelID] => 242
            [AutoEngineID] => 0
            [CustomGroupID] => 33
            [CustomGroupNR] => 
            [TNVDID] => 33
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 5.429
            [QtyInPack] => 0
            [Place] => 
            [Comment] => D=90mm  Atego, Axor II
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 2
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 29.032.00927
            [qnt] => 1
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 2
                            [Property] => , 
                            [PropertyLV] => Diametrs, mm
                            [PropertyEN] => Diameter, mm
                            [Type] => 0
                            [Value] => 90
                            [name] => Array
                                (
                                    [1] => Диаметр, мм
                                    [2] => Diameter, mm
                                    [3] => Diametrs, mm
                                )

                        )

                )

            [models] => Array
                (
                    [0] => MERCEDES - Series ATEGO, AXOR II
                )

            [dev] => Array
                (
                    [0] => 
                )

        )

    [7] => Array
        (
            [GoodsID] => 1306
            [WareNameID] => 2518
            [WareGroupID] => 29
            [WareCodeInGroup] => 32
            [WareCommentID] => 0
            [AutoMakeID] => 5
            [AutoModelID] => 221
            [AutoEngineID] => 0
            [CustomGroupID] => 33
            [CustomGroupNR] => 87089290
            [TNVDID] => 33
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 1.650
            [QtyInPack] => 0
            [Place] => 
            [Comment] => 
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 0
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 29.032.01306
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => MERCEDES - Series SPRINTER
                )

            [dev] => Array
                (
                    [0] => 
                )

        )

    [8] => Array
        (
            [GoodsID] => 10778
            [WareNameID] => 2518
            [WareGroupID] => 29
            [WareCodeInGroup] => 32
            [WareCommentID] => 0
            [AutoMakeID] => 5
            [AutoModelID] => 63
            [AutoEngineID] => 16
            [CustomGroupID] => 33
            [CustomGroupNR] => 87089290
            [TNVDID] => 33
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 4.200
            [QtyInPack] => 0
            [Place] => 
            [Comment] =>    
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 11
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 29.032.10778
            [qnt] => 4
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => MERCEDES - Series ACTROS
                )

            [dev] => Array
                (
                    [0] => 
                )

        )

    [9] => Array
        (
            [GoodsID] => 11918
            [WareNameID] => 2518
            [WareGroupID] => 29
            [WareCodeInGroup] => 32
            [WareCommentID] => 7
            [AutoMakeID] => 5
            [AutoModelID] => 322
            [AutoEngineID] => 0
            [CustomGroupID] => 33
            [CustomGroupNR] => 87089290
            [TNVDID] => 33
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 3.490
            [QtyInPack] => 0
            [Place] => 
            [Comment] => 
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 10
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 29.032.11918
            [qnt] => 2
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

            [models] => Array
                (
                    [0] => MERCEDES - Series ACTROS, Series ATEGO
                )

            [dev] => Array
                (
                    [0] => 
                )

        )

)


supplierProducts:0.0018689632415771

Full:1761833891.9604