Detaļas

Gāzes trose

01.018.18645
RENAULT - Series G-Truck, Series R, MAGNUM AE Garums, mm: 1700
01.018.18646
RENAULT - KERAX I, KERAX II
01.018.19929
MAN - FE Garums, mm: 2285
01.018.19930
MAN - Series L2000/LE, Series M2000/ME Garums, mm: 1652
01.018.19931
MAN - LE Garums, mm: 1280
01.018.19932
MAN - LE Garums, mm: 1532
01.018.19933
MAN - LE, M2000 Garums, mm: 1362
01.018.19934
MAN - LE Garums, mm: 1294
01.018.19935
MAN - ME Garums, mm: 1376
01.018.19936
MAN - LE, ME Garums, mm: 1560
searchПоиск товара
Transportlīdzekļu marka, modelis
Vītne
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` = 1

SELECT * FROM ( SELECT wn.*, ( SELECT COUNT(g.GoodsID) FROM goods AS g WHERE g.wareGroupID=1 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` = '526' 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` = '526' 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.0086710453033447 Full:1761833659.5228