Optics and bulbs

Side marking light, LED

13.035.12413
TRAILOR Color: Orange Voltage, V: 24 Length, mm: 111 Width, mm: 48
13.035.12415
UNIVERSAL Color: Orange Lamp type: LED Voltage, V: 24 Length, mm: 127 Thickness, mm: 37 Width, mm: 39
13.035.12416
UNIVERSAL Color: Orange Lamp type: LED Voltage, V: 24 Length, mm: 80 Thickness, mm: 35 Width, mm: 44
13.035.12896
SCANIA - Series 3, Series 4, Series 5 (P/G/R/T) VOLVO - FH12'93, FH16'02, FH16'94, FM9'02, FM7'93, FM12'93 Color: Orange Lamp type: LED Length, mm: 104 Width, mm: 55
13.035.12914
MAN - Series 2000/E, TGA, TGX Color: Orange LED quantity, pcs: 3 Length, mm: 65 Thickness, mm: 30 Width, mm: 65
13.035.12959
VOLVO - NH, FM9'02, FM12'93, FH12'93, FH16'02, FM7'93, Series FL ver.1 Color: Orange Lamp type: LED Length, mm: 102 Width, mm: 54
13.035.13213
UNIVERSAL Color: Orange Voltage, V: 24 Distance between holes, mm: 70 Length, mm: 119 Thickness, mm: 25.2 Width, mm: 45.9
13.035.13214
UNIVERSAL Color: Orange Lamp type: LED Voltage, V: 24 Distance between holes, mm: 70 Length, mm: 119 Width, mm: 44
13.035.13215
UNIVERSAL Color: Orange Voltage, V: 12 Voltage, V: 24 Cable length, mm: 220 Length, mm: 114 Thickness, mm: 25 Width, mm: 40
13.035.14049
UNIVERSAL Color: White Lamp type: LED Length, mm: 116 Width, mm: 46
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
searchПоиск товара
Vehicle model
Color
LED quantity, pcs
Voltage, V
Length, mm
from to
Thickness, mm
from to
Width, 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` = 13

SELECT * FROM (
                                SELECT  wn.*,  (
                                                SELECT COUNT(g.GoodsID) 
                                                FROM goods AS g 
                                                
                                                WHERE g.wareGroupID=13 
                                                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` = '828' 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 20, 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` = '828' 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 = '2'


Array
(
)


supplierProducts:0.017164945602417

Full:1761833830.8435