Name: ЗУБР 7 л.с., мотоблок с понижающей передачей (МТБ-400)
Brand: ЗУБР
SKU: MKSM-МТБ-400
Price: 43860 RUB
Availability: InStock

Код товара: МТБ-400

ЗУБР 212 см3, мотоблок бензиновый МТБ-400

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

ЗУБР

43860 р

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

Габариты, см

80x60x70

Гарантия

Глубина вспашки, мм

350

Двигатель

ЗУБР

Диски защиты растений

нет

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

Мощный бензиновый мотоблок предназначен для рыхления и культивирования, а при использовании дополнительного навесного оборудования спектр применения мотоблока значительно расширится. Модель предлагает отличное сочетание высокой производительности, управляемости и устойчивости. Сделано в России. Обратите внимание, что c 07.2021 сошник поставляется без транспортировочных колес

Преимущества

Кронштейн для крепления навесного оборудования (диаметр 30 мм) и шкив отбора мощности позволяют использовать широкую гамму навесного оборудования: снегоуборщик, щетку, роторную косилку
3 скорости вперед (понижающая, основная и повышающая) и 1 назад позволяют комфортно работать на любых типах почвы
Чугунный шестеренчато-цепной редуктор с закаленной шестигранной осью 23 мм
Cамозатачивающиеся закаленные фрезы из конструкционной стали
Универсальная сцепка позволяет использовать различное навесное оборудование
Рукоять мотоблока с возможностью регулировки по вертикали делает управление более комфортным
Клиновидный зубчатый ремень в приводе культиватора обладает повышенной износостойкостью по сравнению с обычными ремнями
Регулируемый сошник надежно фиксируется к раме культиватора и отвечает за регулировку глубины вспашки
Защитный кожух ограничивает доступ к вращающимся частям клиноременной передачи и обеспечивает безопасность
Закаленные фрезы прекрасно закапываются на полную глубину и способствуют продвижению мотоблока вперед
Конструкция мотоблока позволяет использовать его с различными навесными оборудованием
Большие пневматические колеса обеспечивают отличную проходимость
На корпусе предусмотрен щиток, защищающий оператора от попадания земли

Использование

Для обработки почвы

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

Габариты, см

80x60x70

Гарантия

Глубина вспашки, мм

350

Двигатель

ЗУБР

Диски защиты растений

нет

Емкость масляного бака, л

0.6

Емкость топливного бака, л

3.6

Колеса

есть

Масса в упаковке, кг

Масса изделия, кг

Мощность, Вт

5150

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

Норма расхода топлива, л/маш.-час

1.9

Объем двигателя, см³

212

Размер колес в комплекте, см

40х10

Сцепление

ременное

Тактность двигателя

4-х тактный

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

бензиновый

Тип колес в комплекте

19х7-8D

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

шестеренчато-цепной

Тип упаковки

коробка картонная

Топливо

АИ92

Число оборотов вала, об/мин

37 / 1-ая, 82 / 2-ая, 113 / 3-ая, 51 / задняя

Число скоростей

3 вперед/1 назад

Ширина вспашки, мм

850

Лишние

Cошник

есть

Отзывов: 0

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

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

Вопросов: 0

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

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

ЗУБР 7 л.с., усиленный мотоблок (МТУ-350)

53460 р

ЗУБР 7 л.с., усиленный мотоблок с понижающей передачей (МТУ-450)

56590 р

ЗУБР тип 1, шаг 3/8″, паз 1.3 мм, 53 звена, цепь для бензопил, Профессионал (70301-35)

790 р

ЗУБР тип 1, шаг 3/8″, паз 1.3 мм, 57 звеньев, цепь для бензопил, Профессионал (70301-40)

850 р

ЗУБР тип 2, шаг 0.325″, паз 1.5 мм, 66 звеньев, цепь для бензопил, Профессионал (70302-40)

970 р

0.0270946026	event/translation (50 action)
0.0124223230	event/theme (25 action)
0.0067660805	event/language (95 action)

1.4009358883	startup/router (1 action)
0.0169410706	startup/startup (1 action)
0.0142509937	startup/seo_url (1 action)
0.0016899109	startup/event (1 action)
0.0005559921	startup/session (1 action)
0.0002000332	startup/error (1 action)
0.0001389980	startup/maintenance (1 action)

0.1435301304	extension/module/uni_new_data (7 action)
0.0959110260	extension/module/uni_auto_related (1 action)
0.0114090443	extension/module/uni_request (1 action)
0.0102059841	extension/module/bundles (1 action)
0.0059530735	extension/advertise/google (2 action)
0.0043449402	extension/module/uni_subscribe (1 action)
0.0040149689	extension/module/uni_news_related (1 action)
0.0025839806	extension/module/banner (2 action)
0.0012741089	extension/module/uni_slideshow_v2 (1 action)
0.0011990070	extension/module/uni_notification (1 action)
0.0010516645	extension/module/ocfilter (25 action)
0.0001809597	extension/module/uni_tool (1 action)
0.0000731945	extension/module/uni_viewed (1 action)

1.4003190994	product/product (1 action)
0.0042381287	product/uni_reviews (1 action)

0.0812709332	common/header (1 action)
0.0280938148	common/menu (1 action)
0.0224080086	common/cart (1 action)
0.0204479694	common/footer (1 action)
0.0149450302	common/content_bottom (1 action)
0.0076401234	common/currency (2 action)
0.0075008869	common/column_left (2 action)
0.0037159920	common/column_right (2 action)
0.0035660267	common/search (1 action)
0.0029270649	common/language (1 action)
0.0018310547	common/content_top (1 action)

0.3401498795	UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '130848'
0.0410339832	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 = '1400' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id > '130848' AND p.product_id != '130848' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
0.0125138760	DELETE FROM `oc_session` WHERE `expire` < '2025-12-17 09:12:19'
0.0086951256	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.0054562092	SELECT category_id, parent_id FROM oc_category ORDER BY parent_id
0.0052070618	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 = '130850' AND od.language_id = '1' ORDER BY o.sort_order
0.0048730373	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 = '130849' AND od.language_id = '1' ORDER BY o.sort_order
0.0042870045	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 = '130862' AND od.language_id = '1' ORDER BY o.sort_order
0.0042748451	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 = '130861' AND od.language_id = '1' ORDER BY o.sort_order
0.0042102337	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 = '130848' AND od.language_id = '1' ORDER BY o.sort_order
0.0040709972	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 = '130863' AND od.language_id = '1' ORDER BY o.sort_order
0.0024549961	SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
0.0024139881	SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
0.0023860931	SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
0.0021579266	SHOW TABLES LIKE 'oc_cartkeeper'
0.0020139217	SHOW TABLES LIKE 'oc_ocfilter_setting'
0.0019121170	SELECT request_id, type, name, phone, mail, product_id, comment, admin_comment, date_added, date_modified, status FROM `oc_uni_request` WHERE request_id != '0' AND product_id = '130848' AND request_list = '1' AND status = '3' ORDER BY date_added DESC LIMIT 0,5
0.0016100407	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.0015830994	SHOW TABLES LIKE 'oc_cartkeeper_share'
0.0013689995	SELECT image FROM `oc_product_image` WHERE product_id = '130850' ORDER BY sort_order ASC LIMIT 4
0.0013198853	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.0013039112	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 = '130849' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0012459755	SELECT LCASE(keyword) as keyword FROM oc_seo_url WHERE query = 'category_id=1497' AND store_id = '0' AND language_id = '1' LIMIT 1
0.0012438297	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 = '130862' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0012080669	SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'unishop2' AND route = 'common/menu'
0.0011298656	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.0011179447	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 = '130863' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0010840893	SELECT * FROM oc_cart WHERE api_id = '0' AND session_id = 'a6f9ad3917e6d0bee650509aa6'
0.0010671616	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.0009989738	SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'unishop2' AND route = 'extension/module/uni_request_list'
0.0009789467	SELECT query FROM oc_seo_url WHERE keyword = 'zubr_212_sm3_motoblok_benzinovyy_mtb_400' AND store_id = '0' AND language_id = '1' LIMIT 1
0.0009520054	SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
0.0009450912	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 = '130850' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0009448528	SELECT language_id FROM oc_language WHERE code = '0' AND status = '1' LIMIT 1
0.0009410381	SELECT image FROM `oc_product_image` WHERE product_id = '130849' ORDER BY sort_order ASC LIMIT 4
0.0009179115	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 = '1425' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id > '130848' AND p.product_id != '130848' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
0.0009069443	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 = '130861' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0008988380	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 = '130848' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0008361340	SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.0008020401	SELECT * FROM oc_ocfilter_setting

ЗУБР 212 см3, мотоблок бензиновый МТБ-400

Преимущества

Использование

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

Лишние

event

startup

extension

product

common