Детали редуктора и ведущего моста

Шестерни конической пары

31.029.09970
SCANIA - Series 4, Series 5 (P/G/R/T) Редуктор - SCANIA - RB 660 Передаточное число: 41x12 (3,42:1)
31.029.10139
MERCEDES - T1, T2 Редуктор - MERCEDES - HL2, HL4, HL5 Передаточное число: 40:11 (3,64:1) Диаметр конической шестерни, мм: 312
31.029.12088
MERCEDES - Series LK, Series MK, Series NG, Series SK, ACTROS I, ATEGO I Редуктор - MERCEDES - HL7 Передаточное число: 26x24 (1,08:1) Диаметр конической шестерни, мм: 300
31.029.12093
SCANIA - Series 4, Series 5 (P/G/R/T) Редуктор - SCANIA - RBP 735
31.029.12148
SCANIA - Series 3, Series 2 Редуктор - SCANIA - RB 652 Передаточное число: 34x10 (3,40:1)
31.029.13973
SCANIA - Series 2 Редуктор - SCANIA - RBP 730 Передаточное число: 31:28 (4,24:1)
31.029.14196
SCANIA - Series 3 Редуктор - SCANIA - R 641, R 642 Передаточное число: 39x12 (3,25:1)
31.029.14207
SCANIA - Series 3, Series 4 Редуктор - SCANIA - RP 831, RP 832 Передаточное число: 26x19 (3,87:1)
31.029.15163
MERCEDES Редуктор - MERCEDES - HL2 Передаточное число: 41x13 (3,15:1) Диаметр конической шестерни, мм: 312
31.029.17549
VOLVO - F10, FL12'85, Series FM ver.1, 2, Series FH ver.1, 2, NH Редуктор - VOLVO - EV 90, EV 91, RS 1356SV Передаточное число: 31x9 (3,44:1)
1 2 3
searchПоиск товара
Марка, модель автомобиля
Агрегат
Передаточное число
Диаметр конической шестерни, мм
от до
Начать поиск Очистить фильтр
Корзина
Ваша корзина пуста
Контакты
t. +371 67248906 @ v7@oldi.net 
SELECT * FROM `waregroup` WHERE `waregroup`.devfilter IS TRUE and `WareGroupID` = 31

SELECT * FROM (
                                SELECT  wn.*,  (
                                                SELECT COUNT(g.GoodsID) 
                                                FROM goods AS g 
                                                
                                                WHERE g.wareGroupID=31 
                                                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` = '734' 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 10, 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` = '734' 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 = '1'


Array
(
)


supplierProducts:0.012847900390625

Full:1761833514.3624