Engine parts

Shaft seal oil

33.070.24012
DAF - CF-75, CF-85 Dzinejs - DAF - PE183, PE212, PE228, PE235, PE250, PE265, PE310, P Installation place: Front Diameter external, mm: 105 Diameter internal, mm: 90 Thickness, mm: 11
33.070.24417
DAF - CF-85IV, XF-105 Dzinejs - DAF - MX 13 - serie Installation place: Front Standart: EURO 3/4 Diameter external, mm: 156 Diameter internal, mm: 134 Thickness, mm: 12
33.070.24418
DAF - CF-85IV, XF-105 Dzinejs - DAF - MX 13 - serie Installation place: Front Standart: EURO 5 Diameter external, mm: 161 Diameter internal, mm: 134 Thickness, mm: 16
33.070.24419
DAF - CF-85IV, XF-105 Installation place: Rear Standart: EURO 3/4 Diameter external, mm: 191 Diameter internal, mm: 166 Thickness, mm: 12
33.070.25393
MERCEDES - O305, Series NG Installation place: Front Diameter external, mm: 90 Diameter internal, mm: 65 Thickness, mm: 14
33.070.25789
RENAULT - MAGNUM AE, MAGNUM E-TECH Dzinejs - RENAULT - Mack E.TECH A/B/C /46, MIDR 06.24.65 A, MIDR 06.24 Installation place: Front Diameter external, mm: 101.6 Diameter internal, mm: 82.5 Thickness, mm: 12
33.070.25792
RENAULT - MAGNUM AE, MAGNUM E-TECH Dzinejs - RENAULT - MIDR 06.24.65 A, MIDR 06.24.65 B, MIDR 06.24.65 C, Installation place: Rear Diameter external, mm: 171 Diameter internal, mm: 153 Thickness, mm: 11
33.070.25852
SCANIA - Series 5 (P/G/R/T), Series 6 Dzinejs - SCANIA - D9, D13 Installation place: Front Diameter external, mm: 153 Diameter internal, mm: 135 Thickness, mm: 13
33.070.25857
FIAT - Ducato IVECO - Daily-IV (2006-), Daily-V (2011-) Dzinejs - IVECO - F1A Installation place: Front Rotation direction: Clockwise Diameter external, mm: 80 Diameter internal, mm: 50 Thickness, mm: 11
33.070.25949
AUDI FORD-TRUCK MERCEDES - VITO, Viano VOLVO VW - TRANSPORTER, LT, CRAFTER, CADDY Installation place: Rear Diameter external, mm: 105 Diameter internal, mm: 85 Thickness, mm: 11
1 2 3 4 5 6 7 8 9 10
searchПоиск товара
Vehicle model
Agregats
Installation place
Diameter external, mm
from to
Diameter internal, mm
from to
Apply Clear filter
Cart
Your cart is empty
Contacts
t. +371 67248906 @ v7@oldi.net 
SELECT * FROM `waregroup` WHERE `waregroup`.devfilter IS TRUE and `WareGroupID` = 33

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


Array
(
)


supplierProducts:0.0081260204315186

Full:1761833912.9668