SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,generatory.`povernor_engine`,generatory.`work_volume`,generatory.`pewers_kva`,generatory.`na_rame_check`,generatory.`rasxod_75`,generatory.`rasxod_100`,generatory.`powers`,generatory.`rezerv`,generatory.`generatory_vyx_voltage`,generatory.`generatory_voltage_3`,generatory.`generatory_voltage_1`,generatory.`generatory_eng_noise`,generatory.`generatory_eng_pusk`,generatory.`generatory_eng_avtonom_work`,generatory.`generatory_eng_cooling`,generatory.`generatory_eng_speed`,generatory.`cooling_system`,generatory.`generatory_weight`,generatory.`generatory_gpt_type`,generatory.`generatory_ac_frequency`,generatory.`type_hands`,generatory.`generatory_gasoline`,generatory.`brand`,generatory.`model`,generatory.`country`,generatory.`brand_engine`,generatory.`model_engine`,generatory.`country_engine`,generatory.`generatory_gpt_model`,generatory.`number_cylinders`,generatory.`voltage_stability`,generatory.`welding_function`,generatory.`generatory_fuel`,generatory.`volume_oil`,generatory.`gen_hit_name`,generatory.`generatory_fuel_tank_volume`,generatory.`kogyx_check`,generatory.`open_check`,generatory.`shassi_check`,generatory.`generatory_size`,generatory.`img_shassi`,generatory.`generatory_name_producer`,generatory.`brand_rus`,generatory.`model_dop_info`,generatory.`rezerv_kva`,generatory.`es_check`,generatory.`a_check`,generatory.`generatory_muffler`,generatory.`generatory_overload_protection`,generatory.`generatory_number_of_ticks`,generatory.`controller_brend`,generatory.`controller_model`,generatory.`garantiya_dv`,generatory.`generators_alternator_brand`,generatory.`generators_alternator_brand_2`,generatory.`generators_alternator_model_2`,generatory.`generators_size_case`,generatory.`generators_size_chassis`,generatory.`generators_weight_case`,generatory.`generators_weight_chassis`,generatory.`files`,generatory.`files_titles`,generatory.`generatory_file_descr`,generatory.`generatory_file_decl`,generatory.`nominal_tok`,generatory.`garantiya_gn`,generatory.`generators_alternator_brand_3`,generatory.`generators_alternator_country`,generatory.`generators_alternator_country_2`,generatory.`generators_alternator_country_3`,generatory.`generators_alternator_model`,generatory.`generators_alternator_model_3`,generatory.`generators_priceold_case`,generatory.`generators_priceold_open`,generatory.`generators_dc_output`,generatory.`generators_auto_shutter`,generatory.`generators_voltage_regulator`,generatory.`generators_autonomy`,generatory.`addition_data_js`,generatory.`cont_check`,generatory.`generators_power_kva`,generatory.`generators_fuel`,catalog.`h2`,catalog.`close_power`,catalog.`catalog_garanty`,catalog.`general_features`,catalog.`general_applications`,catalog.`general_etc`,catalog.`catalog_short_descr`,catalog.`short_description_autofill`,catalog.`brothers_block_autofill`,catalog.`show_in_yml` , `tbl_currencies`.price_rub_fields, `tbl_currencies`.price_rub, `tbl_currencies`.price_old_rub
FROM `tbl_ecommerce_goods` g
LEFT JOIN `tbl_currencies` ON (`tbl_currencies`.good_id=g.`id`)
LEFT JOIN `tbl_generatory_ecommerce_fields` as generatory ON generatory.good_id = g.id LEFT JOIN `tbl_catalog_ecommerce_fields` as catalog ON catalog.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (16631) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) and ( 1=1 ) ORDER BY g.id
Дизельный генератор ССМ АД-75С-Т400-1РКМ2 купить в Красногорске
Дизельный генератор ССМ АД-75С-Т400-1РПМ2 в шумозащитном кожухе
в Красногорске
SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* , `tbl_currencies`.price_rub_fields, `tbl_currencies`.price_rub, `tbl_currencies`.price_old_rub
FROM `tbl_ecommerce_goods` g
LEFT JOIN `tbl_currencies` ON (`tbl_currencies`.good_id=g.`id`)
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (16631) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) and ( 1=1 ) ORDER BY price_rub Технические характеристикиМодификацииПреимуществаДоставкаМонтаж под ключ
SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* , `tbl_currencies`.price_rub_fields, `tbl_currencies`.price_rub, `tbl_currencies`.price_old_rub
FROM `tbl_ecommerce_goods` g
LEFT JOIN `tbl_currencies` ON (`tbl_currencies`.good_id=g.`id`)
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (16631) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) and ( 1=1 ) ORDER BY price_rub
Технические характеристики
Технические характеристики
* – при коэффициенте мощности 0,8
Мощность основная
75 кВт* | 93.75 кВА
Мощность резервная
82 кВт
Выходное напряжение
230/400 В
Объем топливного бака
200 л
Габариты
2510x1170x1900
Вес
2090 кг
Двигатель
Бренд
ЯМЗ
Модель
236М2-48
Регулятор оборотов
механический
Рабочий объем
11.15 л
Количество цилиндров
6
Охлаждение двигателя
жидкостная
Объем масляной системы
19 л
Емкость системы охлаждения
36 л
Генератор переменного тока
Тип генератора
Синхронный
Модель
Pro 22S D/4
Модификации ССМ АД-75С-Т400-1РКМ2
Модель
Автозапуск
Цена
SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,generatory.`povernor_engine`,generatory.`work_volume`,generatory.`pewers_kva`,generatory.`na_rame_check`,generatory.`rasxod_75`,generatory.`rasxod_100`,generatory.`powers`,generatory.`rezerv`,generatory.`generatory_vyx_voltage`,generatory.`generatory_voltage_3`,generatory.`generatory_voltage_1`,generatory.`generatory_eng_noise`,generatory.`generatory_eng_pusk`,generatory.`generatory_eng_avtonom_work`,generatory.`generatory_eng_cooling`,generatory.`generatory_eng_speed`,generatory.`cooling_system`,generatory.`generatory_weight`,generatory.`generatory_gpt_type`,generatory.`generatory_ac_frequency`,generatory.`type_hands`,generatory.`generatory_gasoline`,generatory.`brand`,generatory.`model`,generatory.`country`,generatory.`brand_engine`,generatory.`model_engine`,generatory.`country_engine`,generatory.`generatory_gpt_model`,generatory.`number_cylinders`,generatory.`voltage_stability`,generatory.`welding_function`,generatory.`generatory_fuel`,generatory.`volume_oil`,generatory.`gen_hit_name`,generatory.`generatory_fuel_tank_volume`,generatory.`kogyx_check`,generatory.`open_check`,generatory.`shassi_check`,generatory.`generatory_size`,generatory.`img_shassi`,generatory.`generatory_name_producer`,generatory.`brand_rus`,generatory.`model_dop_info`,generatory.`rezerv_kva`,generatory.`es_check`,generatory.`a_check`,generatory.`generatory_muffler`,generatory.`generatory_overload_protection`,generatory.`generatory_number_of_ticks`,generatory.`controller_brend`,generatory.`controller_model`,generatory.`garantiya_dv`,generatory.`generators_alternator_brand`,generatory.`generators_alternator_brand_2`,generatory.`generators_alternator_model_2`,generatory.`generators_size_case`,generatory.`generators_size_chassis`,generatory.`generators_weight_case`,generatory.`generators_weight_chassis`,generatory.`files`,generatory.`files_titles`,generatory.`generatory_file_descr`,generatory.`generatory_file_decl`,generatory.`nominal_tok`,generatory.`garantiya_gn`,generatory.`generators_alternator_brand_3`,generatory.`generators_alternator_country`,generatory.`generators_alternator_country_2`,generatory.`generators_alternator_country_3`,generatory.`generators_alternator_model`,generatory.`generators_alternator_model_3`,generatory.`generators_priceold_case`,generatory.`generators_priceold_open`,generatory.`generators_dc_output`,generatory.`generators_auto_shutter`,generatory.`generators_voltage_regulator`,generatory.`generators_autonomy`,generatory.`addition_data_js`,generatory.`cont_check`,generatory.`generators_power_kva`,generatory.`generators_fuel`,catalog.`h2`,catalog.`close_power`,catalog.`catalog_garanty`,catalog.`general_features`,catalog.`general_applications`,catalog.`general_etc`,catalog.`catalog_short_descr`,catalog.`short_description_autofill`,catalog.`brothers_block_autofill`,catalog.`show_in_yml` , `tbl_currencies`.price_rub_fields, `tbl_currencies`.price_rub, `tbl_currencies`.price_old_rub
FROM `tbl_ecommerce_goods` g
LEFT JOIN `tbl_currencies` ON (`tbl_currencies`.good_id=g.`id`)
LEFT JOIN `tbl_generatory_ecommerce_fields` as generatory ON generatory.good_id = g.id LEFT JOIN `tbl_catalog_ecommerce_fields` as catalog ON catalog.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (16631) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) and ( 1=1 ) ORDER BY g.id
Базовая модель ССМ АД-75С-Т400-1РПМ2 в шумозащитном кожухе
Бесплатная доставка в Красногорск и Красногорский район собственной курьерской службой в день заказа
Доставка крупногабаритного груза манипулятором
Доставка по России и странам СНГ с помощью транспортных компаний-партнеров
Оставьте заявку, и наши менеджеры помогут подобрать оптимальный вариант!
SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,portfolio.`oborudovanie`,portfolio.`powers_obj`,portfolio.`work_obj`,portfolio.`client_name`,portfolio.`adress_obj`,portfolio.`short_desc`,portfolio.`foto1`,portfolio.`foto2`,portfolio.`foto3`,portfolio.`realize_project`,portfolio.`otzyv_object`,portfolio.`oborudovanie_short`,portfolio.`power_short`,portfolio.`work_short`,portfolio.`object_categories`,portfolio.`producer`,portfolio.`pictures`,portfolio.`logo_img`,portfolio.`portfolio_producer`,portfolio.`portfolio_power`,portfolio.`akb_flag`,portfolio.`object`,portfolio.`otrasl`,portfolio.`portfolio_date`,portfolio.`foto4`,portfolio.`foto5`,portfolio.`foto6`,portfolio.`foto7` , `tbl_currencies`.price_rub_fields, `tbl_currencies`.price_rub, `tbl_currencies`.price_old_rub
FROM `tbl_ecommerce_goods` g
LEFT JOIN `tbl_currencies` ON (`tbl_currencies`.good_id=g.`id`)
LEFT JOIN `tbl_portfolio_ecommerce_fields` as portfolio ON portfolio.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (33,35,12851) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) and ( 1=1 ) ORDER BY id LIMIT 3