Auto optika un lampas

Gabarītlukturis, diožu

13.035.26349
UNIVERSAL Diodu skaits, gab: 3 Krāsa: Sarkans Attālums starp caurumiem, mm: 58 Garums, mm: 73 Kabeļa garums, mm: 450 Platums, mm: 32
13.035.26353
UNIVERSAL Diodu skaits, gab: 4 Krāsa: Balts Attālums starp caurumiem, mm: 116 Biezums, mm: 14.5 Garums, mm: 130 Kabeļa garums, mm: 450 Platums, mm: 32
13.035.26354
UNIVERSAL Diodu skaits, gab: 4 Krāsa: Oranžs Attālums starp caurumiem, mm: 116 Biezums, mm: 14.5 Garums, mm: 130 Kabeļa garums, mm: 500 Platums, mm: 32
13.035.26355
UNIVERSAL Diodu skaits, gab: 4 Krāsa: Sarkans Attālums starp caurumiem, mm: 116 Biezums, mm: 14.5 Garums, mm: 130 Kabeļa garums, mm: 500 Platums, mm: 32
13.035.26702
UNIVERSAL ADR: Ja Jauda, W: 2 Krāsa: Oranžs Spriegums, V: 12/24 Biezums, mm: 26.5 Garums, mm: 124 Kabeļa garums, mm: 500 Platums, mm: 75 Platums, mm: 51
13.035.26817
UNIVERSAL ADR: Ja Jauda, W: 2 Krāsa: Oranžs Papildus: Ar pagrieziena radītaju Spriegums, V: 12/24 Biezums, mm: 26.5 Garums, mm: 124 Kabeļa garums, mm: 500 Platums, mm: 75 Platums, mm: 51
13.035.26848
UNIVERSAL Krāsa: Balts Attālums starp caurumiem, mm: 90 Biezums, mm: 22 Garums, mm: 111 Kabeļa garums, mm: 450 Platums, mm: 52
13.035.26937
VOLVO - FH13'12, FH16'12, FMX ver.1 '10
13.035.26994
UNIVERSAL Diodu skaits, gab: 1 Krāsa: Balts Attālums starp caurumiem, mm: 75 Biezums, mm: 17 Garums, mm: 110 Kabeļa garums, mm: 450 Platums, mm: 41
13.035.26995
UNIVERSAL Krāsa: Sarkans Krāsa: Balts Puse: Kreisais Puse: Labais Attālums starp caurumiem, mm: 32 Biezums, mm: 38 Garums, mm: 139 Platums, mm: 48
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
searchПоиск товара
Transportlīdzekļu marka, modelis
Diodu skaits, gab
Krāsa
Spriegums, V
Biezums, mm
no līdz
Garums, mm
no līdz
Platums, mm
no līdz
Meklēt Nodzēst filtrus
Grozs
Jūsu grozs ir tukšs
Kontakti
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 `WareNameLV` 

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 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` = '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 = '7'


Array
(
)


supplierProducts:0.0055451393127441

Full:1761833694.7711