Сцепные устройства

Наконечник дышла прицепа

24.014.03924

_TRAILERS Фаркоп - VBG - VBG-200, VBG-620, VBG-623, VBG-6000, VBG-760 Диаметр сцепного пальца, мм: 57

24.014.03925

_TRAILERS Фаркоп - VBG - VBG-820, VBG-821, VBG-1050, VBG-1700 Диаметр сцепного пальца, мм: 50

24.014.03926

_TRAILERS Диаметр сцепного пальца, мм: 40

24.014.10417

ROCKINGER Диаметр сцепного пальца, мм: 57

24.014.10418

UNIVERSAL Диаметр сцепного пальца, мм: 50

24.014.10419

UNIVERSAL Диаметр сцепного пальца, мм: 40

24.014.10420

UNIVERSAL Диаметр сцепного пальца, мм: 50

24.014.10421

UNIVERSAL Диаметр сцепного пальца, мм: 50

24.014.10645

UNIVERSAL Диаметр сцепного пальца, мм: 57

24.014.30622

UNIVERSAL Диаметр сцепного пальца, мм: 40

1 2

Поиск товара

Марка, модель автомобиля

Агрегат

Диаметр сцепного пальца, мм

Очистить фильтр

Корзина
Ваша корзина пуста

Контакты
t. +371 67248906 @ v7@oldi.net

SELECT * FROM `waregroup` WHERE `waregroup`.devfilter IS TRUE and `WareGroupID` = 24

SELECT * FROM (
                                SELECT  wn.*,  (
                                                SELECT COUNT(g.GoodsID) 
                                                FROM goods AS g 
                                                
                                                WHERE g.wareGroupID=24 
                                                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` = '436' 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` = '436' 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.0015900135040283
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 ('3924', '3925', '3926', '10417', '10418', '10419', '10420', '10421', '10645', '30622')
            and `b`.`UseInSearch` = 1
            


Full:1761833676.6866

Array
(
    [0] => Array
        (
            [GoodsID] => 3924
            [WareNameID] => 436
            [WareGroupID] => 24
            [WareCodeInGroup] => 14
            [WareCommentID] => 706
            [AutoMakeID] => 136
            [AutoModelID] => 2079
            [AutoEngineID] => 0
            [CustomGroupID] => 23
            [CustomGroupNR] => 87169090
            [TNVDID] => 145
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 12.000
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ��� ������� VBG-200/620/623/6000/760    ������ Rockinger .10417
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 2
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 24.014.03924
            [qnt] => 1
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 172
                            [Property] => ������� �������� ������, ��
                            [PropertyLV] => Sakabes pirksta diametrs, mm
                            [PropertyEN] => Coupling pin diameter, mm
                            [Type] => 1
                            [Value] => 57
                            [name] => Array
                                (
                                    [1] => Диаметр сцепного пальца, мм
                                    [2] => Coupling pin diameter, mm
                                    [3] => Sakabes pirksta diametrs, mm
                                )

                        )

                )

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

            [dev] => Array
                (
                    [0] => Фаркоп - VBG - VBG-200, VBG-620, VBG-623, VBG-6000, VBG-760
                )

        )

    [1] => Array
        (
            [GoodsID] => 3925
            [WareNameID] => 436
            [WareGroupID] => 24
            [WareCodeInGroup] => 14
            [WareCommentID] => 707
            [AutoMakeID] => 136
            [AutoModelID] => 2078
            [AutoEngineID] => 0
            [CustomGroupID] => 23
            [CustomGroupNR] => 87169090
            [TNVDID] => 145
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 10.500
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ��� ������� VBG-820/821/1050/1700        ������ Rockinger -.10418
		������ �� ��/��� ������� .32329	
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 50
            [OE] => 
            [AnalogTypeID] => 20
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 24.014.03925
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 172
                            [Property] => ������� �������� ������, ��
                            [PropertyLV] => Sakabes pirksta diametrs, mm
                            [PropertyEN] => Coupling pin diameter, mm
                            [Type] => 1
                            [Value] => 50
                            [name] => Array
                                (
                                    [1] => Диаметр сцепного пальца, мм
                                    [2] => Coupling pin diameter, mm
                                    [3] => Sakabes pirksta diametrs, mm
                                )

                        )

                )

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

            [dev] => Array
                (
                    [0] => Фаркоп - VBG - VBG-820, VBG-821, VBG-1050, VBG-1700
                )

        )

    [2] => Array
        (
            [GoodsID] => 3926
            [WareNameID] => 436
            [WareGroupID] => 24
            [WareCodeInGroup] => 14
            [WareCommentID] => 708
            [AutoMakeID] => 136
            [AutoModelID] => 2080
            [AutoEngineID] => 0
            [CustomGroupID] => 23
            [CustomGroupNR] => 87169090
            [TNVDID] => 145
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 7.300
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ������ ROCKINGER = .10419 - ������� !!!
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 50
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 24.014.03926
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 172
                            [Property] => ������� �������� ������, ��
                            [PropertyLV] => Sakabes pirksta diametrs, mm
                            [PropertyEN] => Coupling pin diameter, mm
                            [Type] => 1
                            [Value] => 40
                            [name] => Array
                                (
                                    [1] => Диаметр сцепного пальца, мм
                                    [2] => Coupling pin diameter, mm
                                    [3] => Sakabes pirksta diametrs, mm
                                )

                        )

                )

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

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

        )

    [3] => Array
        (
            [GoodsID] => 10417
            [WareNameID] => 436
            [WareGroupID] => 24
            [WareCodeInGroup] => 14
            [WareCommentID] => 706
            [AutoMakeID] => 141
            [AutoModelID] => 2079
            [AutoEngineID] => 0
            [CustomGroupID] => 23
            [CustomGroupNR] => 87089997
            [TNVDID] => 145
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 12.000
            [QtyInPack] => 0
            [Place] => 
            [Comment] => �������.      ������ VBG -  .03924
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 11
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 24.014.10417
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 172
                            [Property] => ������� �������� ������, ��
                            [PropertyLV] => Sakabes pirksta diametrs, mm
                            [PropertyEN] => Coupling pin diameter, mm
                            [Type] => 1
                            [Value] => 57
                            [name] => Array
                                (
                                    [1] => Диаметр сцепного пальца, мм
                                    [2] => Coupling pin diameter, mm
                                    [3] => Sakabes pirksta diametrs, mm
                                )

                        )

                )

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

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

        )

    [4] => Array
        (
            [GoodsID] => 10418
            [WareNameID] => 436
            [WareGroupID] => 24
            [WareCodeInGroup] => 14
            [WareCommentID] => 707
            [AutoMakeID] => 141
            [AutoModelID] => 2078
            [AutoEngineID] => 0
            [CustomGroupID] => 23
            [CustomGroupNR] => 87089997
            [TNVDID] => 145
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 10.700
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ��� ��/��� - ROCKINGRER - ������.       ������ - VBG = .03925 - ������ �� ������ ������
������ �� ��/��� ������� .32329
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 2
            [OE] => 
            [AnalogTypeID] => 20
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 24.014.10418
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 172
                            [Property] => ������� �������� ������, ��
                            [PropertyLV] => Sakabes pirksta diametrs, mm
                            [PropertyEN] => Coupling pin diameter, mm
                            [Type] => 1
                            [Value] => 50
                            [name] => Array
                                (
                                    [1] => Диаметр сцепного пальца, мм
                                    [2] => Coupling pin diameter, mm
                                    [3] => Sakabes pirksta diametrs, mm
                                )

                        )

                )

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

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

        )

    [5] => Array
        (
            [GoodsID] => 10419
            [WareNameID] => 436
            [WareGroupID] => 24
            [WareCodeInGroup] => 14
            [WareCommentID] => 708
            [AutoMakeID] => 141
            [AutoModelID] => 2080
            [AutoEngineID] => 0
            [CustomGroupID] => 23
            [CustomGroupNR] => 87089997
            [TNVDID] => 145
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 8.200
            [QtyInPack] => 0
            [Place] => 
            [Comment] => 40mm.   ������ VBG = .03926 - ������, �� ������ ������ !!!
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 80
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 24.014.10419
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 172
                            [Property] => ������� �������� ������, ��
                            [PropertyLV] => Sakabes pirksta diametrs, mm
                            [PropertyEN] => Coupling pin diameter, mm
                            [Type] => 1
                            [Value] => 40
                            [name] => Array
                                (
                                    [1] => Диаметр сцепного пальца, мм
                                    [2] => Coupling pin diameter, mm
                                    [3] => Sakabes pirksta diametrs, mm
                                )

                        )

                )

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

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

        )

    [6] => Array
        (
            [GoodsID] => 10420
            [WareNameID] => 436
            [WareGroupID] => 24
            [WareCodeInGroup] => 14
            [WareCommentID] => 707
            [AutoMakeID] => 141
            [AutoModelID] => 2078
            [AutoEngineID] => 0
            [CustomGroupID] => 23
            [CustomGroupNR] => 87089997
            [TNVDID] => 145
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 11.500
            [QtyInPack] => 0
            [Place] => 
            [Comment] => �������� � ������� ���������     �����������. 
��������� ���������=17mm. �����=154�154�� �������
������ �������� �������� ������ ��������� - .23719
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 2
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 24.014.10420
            [qnt] => 1
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 172
                            [Property] => ������� �������� ������, ��
                            [PropertyLV] => Sakabes pirksta diametrs, mm
                            [PropertyEN] => Coupling pin diameter, mm
                            [Type] => 1
                            [Value] => 50
                            [name] => Array
                                (
                                    [1] => Диаметр сцепного пальца, мм
                                    [2] => Coupling pin diameter, mm
                                    [3] => Sakabes pirksta diametrs, mm
                                )

                        )

                )

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

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

        )

    [7] => Array
        (
            [GoodsID] => 10421
            [WareNameID] => 436
            [WareGroupID] => 24
            [WareCodeInGroup] => 14
            [WareCommentID] => 707
            [AutoMakeID] => 141
            [AutoModelID] => 2078
            [AutoEngineID] => 0
            [CustomGroupID] => 23
            [CustomGroupNR] => 87089997
            [TNVDID] => 145
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 17.350
            [QtyInPack] => 0
            [Place] => 
            [Comment] => C����������. ��������� ���������=21��. ����� 190x190mm. �������

            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 0
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 24.014.10421
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 172
                            [Property] => ������� �������� ������, ��
                            [PropertyLV] => Sakabes pirksta diametrs, mm
                            [PropertyEN] => Coupling pin diameter, mm
                            [Type] => 1
                            [Value] => 50
                            [name] => Array
                                (
                                    [1] => Диаметр сцепного пальца, мм
                                    [2] => Coupling pin diameter, mm
                                    [3] => Sakabes pirksta diametrs, mm
                                )

                        )

                )

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

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

        )

    [8] => Array
        (
            [GoodsID] => 10645
            [WareNameID] => 436
            [WareGroupID] => 24
            [WareCodeInGroup] => 14
            [WareCommentID] => 706
            [AutoMakeID] => 144
            [AutoModelID] => 2079
            [AutoEngineID] => 0
            [CustomGroupID] => 23
            [CustomGroupNR] => 87169090
            [TNVDID] => 145
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 6.900
            [QtyInPack] => 0
            [Place] => 
            [Comment] => �������� ������ ��������� - .23719
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 0
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 24.014.10645
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 172
                            [Property] => ������� �������� ������, ��
                            [PropertyLV] => Sakabes pirksta diametrs, mm
                            [PropertyEN] => Coupling pin diameter, mm
                            [Type] => 1
                            [Value] => 57
                            [name] => Array
                                (
                                    [1] => Диаметр сцепного пальца, мм
                                    [2] => Coupling pin diameter, mm
                                    [3] => Sakabes pirksta diametrs, mm
                                )

                        )

                )

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

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

        )

    [9] => Array
        (
            [GoodsID] => 30622
            [WareNameID] => 436
            [WareGroupID] => 24
            [WareCodeInGroup] => 14
            [WareCommentID] => 708
            [AutoMakeID] => 141
            [AutoModelID] => 2080
            [AutoEngineID] => 0
            [CustomGroupID] => 23
            [CustomGroupNR] => 87089997
            [TNVDID] => 145
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 7.500
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ��� ��� Quality ������.  /  ������ �� ��/��� ������� .32326

            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 16
            [OE] => 
            [AnalogTypeID] => 20
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 24.014.30622
            [qnt] => 1
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 172
                            [Property] => ������� �������� ������, ��
                            [PropertyLV] => Sakabes pirksta diametrs, mm
                            [PropertyEN] => Coupling pin diameter, mm
                            [Type] => 1
                            [Value] => 40
                            [name] => Array
                                (
                                    [1] => Диаметр сцепного пальца, мм
                                    [2] => Coupling pin diameter, mm
                                    [3] => Sakabes pirksta diametrs, mm
                                )

                        )

                )

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

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

        )

)


supplierProducts:0.0024170875549316

Full:1761833676.6874