График работы
Пн.-Пт. с 9:00 до 17:00
Сб.-Вс. с 9:00 до 12:00
Доставка
Новой Почтой по Украине.
Запчастей в корзине:
нет зачастей
Error - sql = SELECT * FROM zapchasti_catList,zapchasti_productList,zapchasti_toProduct
WHERE zapchasti_catList.idCat = zapchasti_productList.idCat
AND zapchasti_productList.idMarka = 1
AND zapchasti_productList.idProduct = zapchasti_toProduct.idProduct
AND zapchasti_toProduct.id IN (
SELECT DISTINCT zapchasti_toType.id FROM zapchasti_toType
WHERE zapchasti_toType.idType = 45
)
ORDER by zapchasti_catList.titleCat ASC
Error - sql = SELECT * FROM zapchasti_catList,zapchasti_productList,zapchasti_toProduct
WHERE zapchasti_catList.idCat = zapchasti_productList.idCat
AND zapchasti_productList.idMarka = 1
AND zapchasti_productList.idCat = 7
AND zapchasti_productList.idProduct = zapchasti_toProduct.idProduct
AND zapchasti_toProduct.id IN (
SELECT DISTINCT zapchasti_toType.id FROM zapchasti_toType
WHERE zapchasti_toType.idType = 45
)
Error - sql = SELECT zapchasti_model.kod as kod,
zapchasti_model.sklad as sklad,
zapchasti_model.id as id,
zapchasti_model.countProdag as countProdag,
zapchasti_model.countProdag4 as countProdag4,
zapchasti_model.countProdag8 as countProdag8,
zapchasti_model.countProdag7 as countProdag7,
zapchasti_model.titleZapchast as titleZapchast,
zapchasti_model.titleZapchastUA as titleZapchastUA,
zapchasti_model.dateCreate as dateCreate,
zapchasti_model.ostatok as ostatok,
zapchasti_model.dateOstatok as dateOstatok,
zapchasti_model.kopisZapchast as kopisZapchast,
zapchasti_model.kopisZapchastUA as kopisZapchastUA,
zapchasti_model.textZapchast as textZapchast,
min(zapchasti_price.cenaOut) as cenaOut,
zapchasti_price.kodPrice as kodPrice,
zapchasti_price.valuta as valuta,
zapchasti_price.datePrice as datePrice,
zapchasti_price.idImporter as idImporter,
zapchasti_price.cenaIn as cenaIn,
zapchasti_price.idPrice as idPrice,
zapchasti_toType.idType as idType
FROM zapchasti_model
LEFT JOIN zapchasti_price ON zapchasti_model.id = zapchasti_price.id
LEFT JOIN zapchasti_toType ON zapchasti_model.id = zapchasti_toType.id
WHERE zapchasti_model.id IN (SELECT DISTINCT zapchasti_toProduct.id FROM zapchasti_toProduct
RIGHT JOIN zapchasti_toType ON zapchasti_toProduct.id = zapchasti_toType.id
LEFT JOIN zapchasti_productList
ON zapchasti_toProduct.idProduct = zapchasti_productList.idProduct
WHERE zapchasti_productList.idCat = 7
AND zapchasti_productList.idMarka = 1
AND zapchasti_toType.idType = 45
) AND (zapchasti_model.ostatok > 0 OR (zapchasti_model.ostatok = 0 AND (1772777615 - zapchasti_model.dayOstatok) < 172800) ) GROUP by zapchasti_model.id Order by zapchasti_model.countProdag7 DESC
Error - sql = SELECT * FROM zapchasti_pageSeo
WHERE tip = 45
AND cat = 7
AND brend = 1
AND model = 0
LIMIT 1
Роздел "помощи" в подборе типа запчасти при неизвестном производителе и модели оборудования, находится на стадии разработки.
Запчастей найдено - шт.
Формат отображения: