Детали пневмосистемы / краны

Кран тоpмозной главный

23.002.05430
MERCEDES
23.002.06919
MERCEDES
23.002.07374
UNIVERSAL
23.002.08093
DAF - XF-105, CF-85IV, CF-75IV
23.002.08736
MERCEDES - ACTROS II, ACTROS III, ECONIC I Макс. рабочее давление, bar: 10,0
23.002.14039
DAF
23.002.14881
VOLVO - Series FM ver.1, 2 Макс. рабочее давление, bar: 8,5
23.002.15313
MERCEDES - ACTROS I, AXOR I
23.002.16043
SCANIA - Series 5 (P/G/R/T)
23.002.16225
VOLVO
searchПоиск товара
Марка, модель автомобиля
Очистить фильтр
Корзина
Ваша корзина пуста
Контакты
t. +371 67248906 @ v7@oldi.net
SELECT * FROM `waregroup` WHERE `waregroup`.devfilter IS TRUE and `WareGroupID` = 23

SELECT * FROM ( SELECT wn.*, ( SELECT COUNT(g.GoodsID) FROM goods AS g WHERE g.wareGroupID=23 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` = '54' 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` = '54' 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.18075513839722 Full:1761833836.0086