Name: Вибротрамбовка PATRIOT PVR 75
Brand: PATRIOT
SKU: PTRT-570123075
Price: 121590 RUB
Availability: InStock

Код товара: 570123075

Производитель

PATRIOT

121590 р

Ближайшая доставка: дата
Самовывоз: дата, бесплатно по адресу Москва, ул. Ивана Сусанина, 2с2

Артикул ВЭД

PVR 75 Honda-83G

Базовая единица

шт

Бренд

PATRIOT

Вес товара, кг

Видеоролик

K4m2tUqAR7s;

Все характеристики

Вибротрамбовка PATRIOT PVR-75 Honda – это устройство, предназначенное для уплотнения грунта, песка, гравия, сыпучих материалов. Вибротрамбовка успешно справляются с задачами по уплотнению грунта и сыпучих строительных материалов в тех случаях, когда крупная дорожная техника не может применяться в силу своих больших габаритов или размеров рабочей поверхности. Вибротрамбовка отлично подойдет в случае уплотнения траншей, при подготовке оснований дорожек, вдоль бордюров и обочин. Данная модель рекомендуется к использованию для работы со всеми видами сыпучих материалов и типами грунтов.

PVR-75 Honda отличается высокой производительностью, повышенной надежностью, экономичностью расходования масла и топлива. Простая конструкция упрощает обслуживание моторов, замену расходных материалов, что делает расходы на плановые работы минимальными.

Характеристики

Артикул ВЭД

PVR 75 Honda-83G

Базовая единица

шт

Бренд

PATRIOT

Вес товара, кг

Видеоролик

K4m2tUqAR7s;

Воздушный фильтр

фильтр воздушный HEPA

Габариты подошвы плиты, мм

345х285

Гарантия

2 года

Дата стадии quot;Вывод без остатков quot;

2022-09-30T00:00:00

Дата стадии quot;Действующая quot;

2023-12-04T00:00:00

Дата стадии quot;Новинка quot;

2023-05-30T00:00:00

Дополнительная гарантия

нет

Категория сервиса

Бензиновые виброплиты

Колеса для транспортировки

есть

Краткие характеристики (ТТХ)

5.5 л.с, 4.8 кВт, 163 см.куб, бак 3 л, 4-х тактный двигатель, 10-13 м/мин, уплотнение 14 кН, частота вибрации 90 Гц, 345х285 подошва

Линейка продукции

EXPERT

Материал плиты

чугун

Модель двигателя

Honda GX160

Мощность, кВт

4.8

Мощность, л.с.

5.5

Название модели

PVR 75 Honda

Объем двигателя, см.куб

163

Объем заправки редуктора, л

1,2

Объем масла в вибраторе, мл

900

Объем топливного бака, л

Ответственный менеджер

Хасанов Фархат Асгатович

Охлаждение

воздушное

Расход топлива (при 100% нагрузке), л/час

1,1

Реверс

нет

Редуктор

шестеренчатый, чугунный

Свеча зажигания

F7RTC

Сканировать с/н при упаковке на складе

Да

Складской типоразмер номенклатуры

01.Оч.тяж(50+)

Скорость перемещения, м/мин

10-13

Ссылка на сайт (редактируется автоматически)

https://onlypatriot.com/catalog/stroitelnaya_tekhnika/vibrotrambovki/vibrotrambovka_patriot_pvr_75_honda/

Стадия жизненного цикла

Действующая

Стартер

ручной

Тип двигателя

4-х тактный бензиновый

Тип заправки редуктора

масло трансмиссионное

Тип топлива

бензин АИ-92

Усилие уплотнения, кН

Частота вибрации, Гц

Отзывов: 0

Средняя оценка: 0.0

Нет отзывов об этом товаре.

Вопросов: 0

Пока нет вопросов об этом товаре. Станьте первым!

Аналогичные товары

Вибротрамбовка PATRIOT PVR 85

85660 р

Вибратор для бетона глубинный PATRIOT CV 120

16990 р

Коврик ПУ для виброплиты SVR 60

2190 р

Комплект для подачи воды PATRIOT WT 12

4710 р

Виброплита PATRIOT SVR 80

51890 р

0.0343058109	event/translation (50 action)
0.0160541534	event/theme (25 action)
0.0079610347	event/language (95 action)

6.6044139862	startup/router (1 action)
0.0149760246	startup/startup (1 action)
0.0109939575	startup/seo_url (1 action)
0.0010628700	startup/event (1 action)
0.0003728867	startup/session (1 action)
0.0000941753	startup/error (1 action)
0.0000600815	startup/maintenance (1 action)

1.3343167304	extension/module/uni_new_data (7 action)
1.2841949463	extension/module/uni_auto_related (1 action)
0.0136179924	extension/module/bundles (1 action)
0.0121898651	extension/module/uni_request (1 action)
0.0065789222	extension/advertise/google (2 action)
0.0049560070	extension/module/uni_news_related (1 action)
0.0035231113	extension/module/banner (2 action)
0.0027990341	extension/module/uni_subscribe (1 action)
0.0019111633	extension/module/uni_slideshow_v2 (1 action)
0.0014410019	extension/module/uni_notification (1 action)
0.0012693407	extension/module/ocfilter (25 action)
0.0001339912	extension/module/uni_tool (1 action)
0.0001189709	extension/module/uni_viewed (1 action)

6.6040508747	product/product (1 action)
0.0044548512	product/uni_reviews (1 action)

0.1171081066	common/header (1 action)
0.0347201824	common/cart (1 action)
0.0330829620	common/menu (1 action)
0.0229468346	common/footer (1 action)
0.0208909512	common/content_bottom (1 action)
0.0165860652	common/currency (2 action)
0.0104610920	common/column_left (2 action)
0.0065431595	common/column_right (2 action)
0.0061528683	common/search (1 action)
0.0052790642	common/language (1 action)
0.0031790733	common/content_top (1 action)

0.0151000023	DELETE FROM `oc_session` WHERE `expire` < '2025-12-17 00:51:56'
0.0107600689	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE (c.parent_id = '0' OR c.category_id IN(SELECT category_id FROM oc_category_parent cpr WHERE cpr.parent_id = '0' )) AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.0077180862	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '236552' AND od.language_id = '1' ORDER BY o.sort_order
0.0054659843	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '236616' AND od.language_id = '1' ORDER BY o.sort_order
0.0052669048	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '236377' AND od.language_id = '1' ORDER BY o.sort_order
0.0051150322	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '236632' AND od.language_id = '1' ORDER BY o.sort_order
0.0048270226	SELECT p.product_id FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '1013' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id > '236377' AND p.product_id != '236377' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
0.0046889782	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '236803' AND od.language_id = '1' ORDER BY o.sort_order
0.0046780109	SELECT category_id, parent_id FROM oc_category ORDER BY parent_id
0.0046401024	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '236544' AND od.language_id = '1' ORDER BY o.sort_order
0.0038089752	SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=236377' AND store_id = '0' AND language_id = '1' LIMIT 1
0.0032939911	SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '3' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
0.0031130314	SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
0.0031120777	UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '236377'
0.0028278828	SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/uni_reviews' OR route = 'ru-ru')
0.0027959347	SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
0.0021178722	SELECT p.product_id FROM `oc_product` p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '1025' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id > '236377' AND p.product_id != '236377' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
0.0020990372	SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
0.0018899441	SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
0.0018460751	SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '236377' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015819073	SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/uni_request' OR route = 'ru-ru')
0.0015251637	SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
0.0014779568	SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '236377' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0013530254	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '236544' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0013260841	SHOW TABLES LIKE 'oc_cartkeeper'
0.0013129711	SHOW TABLES LIKE 'oc_ocfilter_setting'
0.0012629032	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '236616' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0012509823	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '236552' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0012249947	SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = '35051e0af4ef1b5da8b2bd922e'
0.0011878014	SHOW TABLES LIKE 'oc_cartkeeper_share'
0.0011749268	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '236632' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0011579990	SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'
0.0011470318	SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'unishop2' AND route = 'common/search'
0.0011410713	SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
0.0010979176	SELECT image FROM `oc_product_image` WHERE product_id = '236552' ORDER BY sort_order ASC LIMIT 4
0.0010960102	SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=236552' AND store_id = '0' AND language_id = '1' LIMIT 1
0.0010919571	SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'product_id=236544' AND store_id = '0' AND language_id = '1' LIMIT 1
0.0010700226	SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'account/wishlist' AND store_id = '0' AND language_id = '1' LIMIT 1
0.0010540485	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '236803' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0010271072	SELECT DISTINCT , pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '236377' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

Вибротрамбовка PATRIOT PVR 75

Характеристики

event

startup

extension

product

common