Pneumatic system / valves

Pneumatic valve

23.011.09685

UNIVERSAL

23.011.01236

23.011.01280

23.011.03178

UNIVERSAL Function: Pressure distributor valve

23.011.03517

UNIVERSAL

23.011.04455

_TRAILERS Function: Pressure distributor valve

23.011.05403

23.011.05410

23.011.05411

23.011.05734

VOLVO

1 2 3 4

Поиск товара

Vehicle model

Function

Max. operating pressure, bar

Thread

Clear filter

Cart
Your cart is empty

Contacts
t. +371 67248906 @ v7@oldi.net

Services

Spare parts
Truck Repair
Tachograph check

Company

History
Goods catalogue
News

Home

Maps

Shop Adresses
OLDI on map
Service

Contacts

Contacts in Latvia
Shop adresses
OLDI on the map
Bank details

Copyright SIA OLDI&CO 2025 © All Rights Reserved. A.E. Developed by MUSOYAN — изготовление сайтов

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

SELECT * FROM (
                                SELECT  wn.*,  (
                                                SELECT COUNT(g.GoodsID) 
                                                FROM goods AS g 
                                                
                                                WHERE g.wareGroupID=23 
                                                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` = '347' 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` = '347' 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.0015480518341064
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 ('9685', '1236', '1280', '3178', '3517', '4455', '5403', '5410', '5411', '5734')
            and `b`.`UseInSearch` = 1
            


Full:1761833644.7972

Array
(
    [0] => Array
        (
            [GoodsID] => 9685
            [WareNameID] => 347
            [WareGroupID] => 23
            [WareCodeInGroup] => 11
            [WareCommentID] => 0
            [AutoMakeID] => 13
            [AutoModelID] => 0
            [AutoEngineID] => 0
            [CustomGroupID] => 27
            [CustomGroupNR] => 84812090
            [TNVDID] => 143
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 1.400
            [QtyInPack] => 0
            [Place] => 
            [Comment] => R.K.WABCO=.09686    ANALOG=.09687 (OE .14889)
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 11
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 0.00
            [ORDERCommment] => 
            [checked] => 1
            [oldi_nr] => 23.011.09685
            [qnt] => 3
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

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

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

        )

    [1] => Array
        (
            [GoodsID] => 1236
            [WareNameID] => 347
            [WareGroupID] => 23
            [WareCodeInGroup] => 11
            [WareCommentID] => 0
            [AutoMakeID] => 13
            [AutoModelID] => 0
            [AutoEngineID] => 0
            [CustomGroupID] => 27
            [CustomGroupNR] => 84812090
            [TNVDID] => 143
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 1.480
            [QtyInPack] => 0
            [Place] => 
            [Comment] => R.K.-.07361      �������� �� ���� ��� ���������� - .03178 (AFM) ��� .14678 (OEM)
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 0
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 23.011.01236
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

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

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

        )

    [2] => Array
        (
            [GoodsID] => 1280
            [WareNameID] => 347
            [WareGroupID] => 23
            [WareCodeInGroup] => 11
            [WareCommentID] => 0
            [AutoMakeID] => 13
            [AutoModelID] => 0
            [AutoEngineID] => 0
            [CustomGroupID] => 27
            [CustomGroupNR] => 87089998
            [TNVDID] => 143
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 1.551
            [QtyInPack] => 0
            [Place] => 
            [Comment] => 
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 50
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 23.011.01280
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

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

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

        )

    [3] => Array
        (
            [GoodsID] => 3178
            [WareNameID] => 347
            [WareGroupID] => 23
            [WareCodeInGroup] => 11
            [WareCommentID] => 0
            [AutoMakeID] => 13
            [AutoModelID] => 0
            [AutoEngineID] => 0
            [CustomGroupID] => 27
            [CustomGroupNR] => 84812090
            [TNVDID] => 143
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 1.520
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ����������!    ��.����� OE-Wabco - .14678        ��.����� � ����� � �������� ����������� .16446       ������������ � ����������� - .01236     R.k.: Wabco - .05772      Knorr - .05731
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 1
            [OE] => 0
            [AnalogTypeID] => 4
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 23.011.03178
            [qnt] => 3
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 226
                            [Property] => ����������
                            [PropertyLV] => Iecel�ana
                            [PropertyEN] => Function
                            [Type] => 1
                            [Value] => Pressure distributor valve
                            [name] => Array
                                (
                                    [1] => Назначение
                                    [2] => Function
                                    [3] => Iecelšana
                                )

                        )

                )

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

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

        )

    [4] => Array
        (
            [GoodsID] => 3517
            [WareNameID] => 347
            [WareGroupID] => 23
            [WareCodeInGroup] => 11
            [WareCommentID] => 0
            [AutoMakeID] => 13
            [AutoModelID] => 0
            [AutoEngineID] => 0
            [CustomGroupID] => 27
            [CustomGroupNR] => 84812090
            [TNVDID] => 143
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 0.136
            [QtyInPack] => 0
            [Place] => 
            [Comment] => 
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 0
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 23.011.03517
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

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

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

        )

    [5] => Array
        (
            [GoodsID] => 4455
            [WareNameID] => 347
            [WareGroupID] => 23
            [WareCodeInGroup] => 11
            [WareCommentID] => 292
            [AutoMakeID] => 12
            [AutoModelID] => 0
            [AutoEngineID] => 0
            [CustomGroupID] => 27
            [CustomGroupNR] => 87089998
            [TNVDID] => 143
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 1.000
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ���� ���� �������� ��� WABCO      ������ ����������� ��� Knorr -.09410     R.k. wabco - .05730
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 2
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 23.011.04455
            [qnt] => 1
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                    [0] => Array
                        (
                            [PropertyID] => 226
                            [Property] => ����������
                            [PropertyLV] => Iecel�ana
                            [PropertyEN] => Function
                            [Type] => 1
                            [Value] => Pressure distributor valve
                            [name] => Array
                                (
                                    [1] => Назначение
                                    [2] => Function
                                    [3] => Iecelšana
                                )

                        )

                )

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

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

        )

    [6] => Array
        (
            [GoodsID] => 5403
            [WareNameID] => 347
            [WareGroupID] => 23
            [WareCodeInGroup] => 11
            [WareCommentID] => 132
            [AutoMakeID] => 2
            [AutoModelID] => 189
            [AutoEngineID] => 0
            [CustomGroupID] => 27
            [CustomGroupNR] => 84812090
            [TNVDID] => 143
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 0.342
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ��������� �������� R.K. - .10028
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 0
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 23.011.05403
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

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

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

        )

    [7] => Array
        (
            [GoodsID] => 5410
            [WareNameID] => 347
            [WareGroupID] => 23
            [WareCodeInGroup] => 11
            [WareCommentID] => 0
            [AutoMakeID] => 1
            [AutoModelID] => 120
            [AutoEngineID] => 0
            [CustomGroupID] => 27
            [CustomGroupNR] => 84812090
            [TNVDID] => 143
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 0.460
            [QtyInPack] => 0
            [Place] => 
            [Comment] => ������ ������  10.Bar
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 0
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 23.011.05410
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

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

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

        )

    [8] => Array
        (
            [GoodsID] => 5411
            [WareNameID] => 347
            [WareGroupID] => 23
            [WareCodeInGroup] => 11
            [WareCommentID] => 0
            [AutoMakeID] => 1
            [AutoModelID] => 120
            [AutoEngineID] => 0
            [CustomGroupID] => 27
            [CustomGroupNR] => 84812090
            [TNVDID] => 143
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 0.540
            [QtyInPack] => 0
            [Place] => 
            [Comment] => R.K.Knorr - .05863
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 0
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 23.011.05411
            [qnt] => 0
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

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

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

        )

    [9] => Array
        (
            [GoodsID] => 5734
            [WareNameID] => 347
            [WareGroupID] => 23
            [WareCodeInGroup] => 11
            [WareCommentID] => 0
            [AutoMakeID] => 1
            [AutoModelID] => 147
            [AutoEngineID] => 0
            [CustomGroupID] => 27
            [CustomGroupNR] => 84812090
            [TNVDID] => 143
            [PackTypeID] => 
            [UnitID] => 1
            [Weight] => 0.220
            [QtyInPack] => 0
            [Place] => 
            [Comment] => M22x1.5
            [Product] => 
            [Disabled] => 
            [Defect] => 0
            [note1] => 
            [AbcID] => 10
            [OE] => 
            [AnalogTypeID] => 0
            [ORDERPrice] => 
            [ORDERCommment] => 
            [checked] => 
            [oldi_nr] => 23.011.05734
            [qnt] => 2
            [move] => 0
            [pic] => 0
            [param] => Array
                (
                )

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

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

        )

)


supplierProducts:0.0018160343170166

Full:1761833644.7975