Elektroiekārtas

Devējs

27.019.13846
MAN - Series F2000/FE, Series L2000/LE, Series M2000/ME, TGA Max. darba spiediens, bar: 5,4 - 5,8 Vītne: M12x1.5
27.019.14659
MERCEDES - ACTROS II, ACTROS III, ACTROS IV, Series ATEGO, ANTOS, AROCS, ECONIC I
27.019.18354
MAN - Series F90/G90/M90, Series F2000/FE, Series L2000/LE, Series M2000/ME MERCEDES - Series ACTROS, Series ATEGO, Series AXOR Vītne: M20x1.5
27.019.19568
VOLVO - Series FH ver.2, Series FH ver.3, Series FM ver.3
27.019.19745
SCANIA - Series 5 (P/G/R/T)
27.019.21759
DAF IVECO MAN - Series F2000/FE, Series TGA/TGS/TGX RENAULT - MASCOTT, MASTER VOLVO Dzinejs - MAN - D2066, D2676, D2840, D2842, D2876 Vītne: M18x1.5
27.019.22672
RENAULT - KERAX III DXi, MAGNUM DXi, PREMIUM III DXi VOLVO - FM9'02, FM12'93, FH12'93, FH12'03
27.019.22674
RENAULT - KERAX III DXi, MAGNUM DXi, PREMIUM III DXi VOLVO - FM9'02, FM12'93, FH12'93, FH12'03, FH16'94 Vītne: M14x1.5
27.019.23730
MAN - Series F90/G90/M90, Series F2000/FE, Series L2000/LE, Series M2000/ME MERCEDES - Series ACTROS, Series ATEGO, Series AXOR Vītne: M20x1.5
27.019.24165
MERCEDES - Series ACTROS, Series AXOR
1 2 3 4 5 6
searchПоиск товара
Transportlīdzekļu marka, modelis
Agregats
Atslēga, SW
Max. darba spiediens, bar
Tikla spriegums, V
Vītne
Vītne 2
Garums, 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` = 27

SELECT * FROM (
                                SELECT  wn.*,  (
                                                SELECT COUNT(g.GoodsID) 
                                                FROM goods AS g 
                                                
                                                WHERE g.wareGroupID=27 
                                                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` = '547' 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 30, 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` = '547' 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 = '3'


Array
(
)


supplierProducts:0.017745018005371

Full:1761833538.0573