SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind`,welding.`generators_welding_current`,welding.`generators_welding_electrode_diameter`,welding.`generators_welding_current_type`,stabilizers.`stabilizers_phases`,stabilizers.`stabilizers_input_operating_voltage_from`,stabilizers.`stabilizers_input_operating_voltage_to`,stabilizers.`stabilizers_input_rated_voltage_from`,stabilizers.`stabilizers_input_rated_voltage_to`,stabilizers.`stabilizers_output_voltage`,stabilizers.`stabilizers_accuracy`,stabilizers.`stabilizers_descr`,stabilizers.`stabilizers_country`,stabilizers.`stabilizers_stabilizer`,gallery.`gallery_good`,gallery.`gallery_producer`,gallery.`gallery_good_name`,gallery.`gallery_good_power`,gallery.`gallery_address`,gallery.`gallery_short_address`,gallery.`gallery_works`,gallery.`gallery_description`,gallery.`gallery_addition`,gallery.`gallery_fuel`,gallery.`gallery_images`,gallery.`gallery_main_page`,articles.`articles_text`,articles.`articles_ids_popular_goods`,articles.`articles_ids_another`,articles.`articles_popular_goods_h2`,articles.`articles_main_page`,articles.`articles_article`,articles.`articles_type`,articles.`articles_name`,articles.`articles_short_descr`,articles.`rss_content`,articles.`rss_content_2`,articles.`rss_image`,articles.`show_page_to_rss`,sale.`sale_power`,sale.`sale_short_description`,sale.`sale_description`,sale.`sale_file`,rent.`rent_power_kw`,rent.`rent_power_kva`,rent.`rent_price_hour`,rent.`rent_price_day`,rent.`rent_price_month`,rent.`rent_good_id`,rent.`rent_name_prefix`,avtomatika.`avtomatika_modem`,avtomatika.`avtomatika_flag`,avtomatika.`avtomatika_bupass`,avtomatika.`avtomatika_sharger`,avtomatika.`avtomatika_sontactors`,avtomatika.`avtomatika_max_power1`,avtomatika.`avtomatika_max_power3`,avtomatika.`avtomatika_voltage`,avtomatika.`avtomatika_rated_current`,avtomatika.`avtomatika_particular_qualities`,avtomatika.`avtomatika_photoes`,avtomatika.`avtomatika_capabilities` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id LEFT JOIN `tbl_welding_ecommerce_fields` as welding ON welding.good_id = g.id LEFT JOIN `tbl_stabilizers_ecommerce_fields` as stabilizers ON stabilizers.good_id = g.id LEFT JOIN `tbl_gallery_ecommerce_fields` as gallery ON gallery.good_id = g.id LEFT JOIN `tbl_articles_ecommerce_fields` as articles ON articles.good_id = g.id LEFT JOIN `tbl_sale_ecommerce_fields` as sale ON sale.good_id = g.id LEFT JOIN `tbl_rent_ecommerce_fields` as rent ON rent.good_id = g.id LEFT JOIN `tbl_avtomatika_ecommerce_fields` as avtomatika ON avtomatika.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (46045) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY g.id
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (46045) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub, if ('asc'='asc',999999999999999999,-1)) ) asc, (IF (`generators_power230_kvt` is not null and `generators_power230_kvt`>0, `generators_power230_kvt`,`generators_power400_kvt`)) asc
Купить дизельный генератор ТСС АД-100С-Т400-1РПМ2 (Engga) EL в капоте мощностью 100 кВт 400 В 43399 ЯМЗ 200 л 238М2-45 | Top-Gen
Дизельный генератор ТСС АД-100С-Т400-1РПМ2 (Engga) в капоте
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (46045) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub, if ('asc'='asc',999999999999999999,-1)) ) asc, (IF (`generators_power230_kvt` is not null and `generators_power230_kvt`>0, `generators_power230_kvt`,`generators_power400_kvt`)) asc
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id
WHERE ( `id` in (46045) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub, if ('asc'='asc',999999999999999999,-1)) ) asc, (IF (`generators_power230_kvt` is not null and `generators_power230_kvt`>0, `generators_power230_kvt`,`generators_power400_kvt`)) asc
Дизельный генератор ТСС АД-100С-Т400-1РПМ2 (Engga) в капоте
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND main_good_id = '169725' OR sync_id = '169725' AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub, if ('asc'='asc',999999999999999999,-1)) ) asc, (IF (`generators_power230_kvt` is not null and `generators_power230_kvt`>0, `generators_power230_kvt`,`generators_power400_kvt`)) asc
Запуск:
электростарт
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (46145) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub, if ('asc'='asc',999999999999999999,-1)) ) asc, (IF (`generators_power230_kvt` is not null and `generators_power230_kvt`>0, `generators_power230_kvt`,`generators_power400_kvt`)) asc
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (46007) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub, if ('asc'='asc',999999999999999999,-1)) ) asc, (IF (`generators_power230_kvt` is not null and `generators_power230_kvt`>0, `generators_power230_kvt`,`generators_power400_kvt`)) asc
открытое
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (46207) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub, if ('asc'='asc',999999999999999999,-1)) ) asc, (IF (`generators_power230_kvt` is not null and `generators_power230_kvt`>0, `generators_power230_kvt`,`generators_power400_kvt`)) asc
на раме
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (82450) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub, if ('asc'='asc',999999999999999999,-1)) ) asc, (IF (`generators_power230_kvt` is not null and `generators_power230_kvt`>0, `generators_power230_kvt`,`generators_power400_kvt`)) asc
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind`,welding.`generators_welding_current`,welding.`generators_welding_electrode_diameter`,welding.`generators_welding_current_type`,stabilizers.`stabilizers_phases`,stabilizers.`stabilizers_input_operating_voltage_from`,stabilizers.`stabilizers_input_operating_voltage_to`,stabilizers.`stabilizers_input_rated_voltage_from`,stabilizers.`stabilizers_input_rated_voltage_to`,stabilizers.`stabilizers_output_voltage`,stabilizers.`stabilizers_accuracy`,stabilizers.`stabilizers_descr`,stabilizers.`stabilizers_country`,stabilizers.`stabilizers_stabilizer`,avtomatika.`avtomatika_modem`,avtomatika.`avtomatika_flag`,avtomatika.`avtomatika_bupass`,avtomatika.`avtomatika_sharger`,avtomatika.`avtomatika_sontactors`,avtomatika.`avtomatika_max_power1`,avtomatika.`avtomatika_max_power3`,avtomatika.`avtomatika_voltage`,avtomatika.`avtomatika_rated_current`,avtomatika.`avtomatika_particular_qualities`,avtomatika.`avtomatika_photoes`,avtomatika.`avtomatika_capabilities` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id LEFT JOIN `tbl_welding_ecommerce_fields` as welding ON welding.good_id = g.id LEFT JOIN `tbl_stabilizers_ecommerce_fields` as stabilizers ON stabilizers.good_id = g.id LEFT JOIN `tbl_avtomatika_ecommerce_fields` as avtomatika ON avtomatika.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND general_producer = 'ТСС (Россия)' AND generators_construction <> 'в контейнере' AND general_model ='АД-100С-Т400-1РПМ2 (Engga)' or generators_start_auto <> '' AND general_model = 'АД-100С-Т400-1РПМ2 (Engga)' AND rent_good=0 AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub,if ('asc'='asc',999999999999999999,-1))) asc LIMIT 3
Доставка
Самовывоз со склада в Москве завтра, бесплатно
ПВЗ Деловые линии, СДЭК, ПЭК послезавтра, по тарифам ТК
Курьерская доставка по Москве и области послезавтра, бесплатно
Преимущества компании
Официальный дилер ТСС (Россия)
Быстрая доставка по всей России
Индивидуальные СКИДКИ 5-20%
Гарантия 24 месяца
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND (main_good_id = 169725 or g.sync_id = 169725) AND g.id<>46045 AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub, if ('asc'='asc',999999999999999999,-1)) ) asc, (IF (`generators_power230_kvt` is not null and `generators_power230_kvt`>0, `generators_power230_kvt`,`generators_power400_kvt`)) asc
Технические характеристики дизельного ТСС АД-100С-Т400-1РПМ2 (Engga) в капоте
Основные характеристики
Модель
АД-100С-Т400-1РПМ2 (Engga)
Основная мощность ?
125кВа/ 100 кВт
Резервная мощность ?
110 кВт
/ 138 кВА
Напряжение ?
400 В
Коэффициент мощности (cos φ) ?
0.8
Количество фаз ?
3
Частота ?
50 Гц
Запуск ?
электростарт
Исполнение ?
в капоте
Производитель (Страна)
ТСС (Россия)
Номинальный ток
181
Двигатель
Марка
ЯМЗ (Россия)
Модель
238М2-45
Тип
дизельный, 4-х тактный
Количество цилиндров
8
Рабочий объем
14.86
Охлаждение ?
жидкостное
Объем охлаждающей жидкости ?
40
Регулятор оборотов ?
механический
Объем масла в двигателе ?
22
Рекомендуемый тип масла
SAE 15W40/10W30
Топливная система
Вид топлива
дизель
Расход топлива при 100% нагрузке ?
31.4 л/ч
Расход топлива при 75% нагрузке ?
24.1 л/ч
Расход топлива 50% нагрузке ?
16.8 л/ч
Емкость топливного бака ?
200 л
Генератор
Марка
Engga (Великобритания)
Модель
EG225-100N
Тип генератора ?
синхронный, бесщеточный
Класс защиты ?
IP21
Класс изоляции ?
H
Габаритные размеры и вес
Длина
2700 мм
Ширина
1140 мм
Высота
2152 мм
Вес
2345 кг.
Гарантия
Гарантия
24 месяца
Компания-производитель оставляет за собой право изменять технические характеристики моделей без предварительного уведомления, оборудование на фото может отличаться от оригинала
Преимущества генератора дизельного ТСС АД-100С-Т400-1РПМ2 (Engga) в капоте
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind`,welding.`generators_welding_current`,welding.`generators_welding_electrode_diameter`,welding.`generators_welding_current_type`,stabilizers.`stabilizers_phases`,stabilizers.`stabilizers_input_operating_voltage_from`,stabilizers.`stabilizers_input_operating_voltage_to`,stabilizers.`stabilizers_input_rated_voltage_from`,stabilizers.`stabilizers_input_rated_voltage_to`,stabilizers.`stabilizers_output_voltage`,stabilizers.`stabilizers_accuracy`,stabilizers.`stabilizers_descr`,stabilizers.`stabilizers_country`,stabilizers.`stabilizers_stabilizer`,avtomatika.`avtomatika_modem`,avtomatika.`avtomatika_flag`,avtomatika.`avtomatika_bupass`,avtomatika.`avtomatika_sharger`,avtomatika.`avtomatika_sontactors`,avtomatika.`avtomatika_max_power1`,avtomatika.`avtomatika_max_power3`,avtomatika.`avtomatika_voltage`,avtomatika.`avtomatika_rated_current`,avtomatika.`avtomatika_particular_qualities`,avtomatika.`avtomatika_photoes`,avtomatika.`avtomatika_capabilities` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id LEFT JOIN `tbl_welding_ecommerce_fields` as welding ON welding.good_id = g.id LEFT JOIN `tbl_stabilizers_ecommerce_fields` as stabilizers ON stabilizers.good_id = g.id LEFT JOIN `tbl_avtomatika_ecommerce_fields` as avtomatika ON avtomatika.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (32268,38590) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub,if ('asc'='asc',999999999999999999,-1))) asc LIMIT 3
Дизельный генератор Mitsudiesel АД-100С-Т400-2РПМ29 с АВР
Дизельный генератор ТСС АД-100С-Т400-2РПМ9 с АВР
В наличии
Нашли дешевле?
Купить
Товар в корзине
Запросить КП Купить со скидкой**Индивидуальные скидки 5-20%
SELECT SQL_CALC_FOUND_ROWS g.* ,general.`general_producer`,general.`general_weight`,general.`general_sizes`,general.`general_guarantee`,general.`general_model`,general.`general_power_kva`,general.`general_power_kwt`,general.`general_name_on_main`,general.`general_technical_characteristics_title`,general.`general_similar_goods_title`,general.`desc_after_table`,general.`description_times`,general.`col_motochas`,general.`general_files`,general.`general_availability`,general.`artikul`,general.`dilive_from`,generators.`generators_fueltype`,generators.`generators_starting`,generators.`generators_phases`,generators.`generators_power230_kva`,generators.`generators_power400_kva`,generators.`generators_power230_kvt`,generators.`generators_power400_kvt`,generators.`generators_reserve_power_kvt`,generators.`generators_reserve_power_kva`,generators.`generators_fuelconsumption`,generators.`generators_fueltank`,generators.`generators_construction`,generators.`generators_power_range`,generators.`generators_coefficient`,generators.`generators_voltage`,generators.`generators_frequency`,generators.`generators_engine_type`,generators.`generators_engine_speed`,generators.`generators_engine_cooling`,generators.`generators_engine_oil_volume`,generators.`generators_engine_coolant_volume`,generators.`generators_type`,generators.`generators_protection_class`,generators.`generators_engine`,generators.`generators_generator_name`,generators.`generators_noise`,generators.`generators_noise_level`,generators.`generators_price_old`,generators.`generators_price_es`,generators.`generators_price_es_old`,generators.`generators_price_a`,generators.`generators_price_a_old`,generators.`generators_price_avr`,generators.`generators_start_auto`,generators.`generators_start_electro`,generators.`generators_start_arm`,generators.`generators_power_union`,generators.`generators_flag_invertor`,generators.`generators_image`,generators.`num_cyl`,generators.`generators_regulator`,generators.`rec_oil_type`,generators.`generators_fuelconsumption70`,generators.`generators_insulation_class`,generators.`generators_stability_voltage`,generators.`generators_bu_operating`,generators.`generators_sdmo_number`,generators.`series`,generators.`has_rent`,generators.`generators_delivery`,generators.`generators_kind`,welding.`generators_welding_current`,welding.`generators_welding_electrode_diameter`,welding.`generators_welding_current_type`,stabilizers.`stabilizers_phases`,stabilizers.`stabilizers_input_operating_voltage_from`,stabilizers.`stabilizers_input_operating_voltage_to`,stabilizers.`stabilizers_input_rated_voltage_from`,stabilizers.`stabilizers_input_rated_voltage_to`,stabilizers.`stabilizers_output_voltage`,stabilizers.`stabilizers_accuracy`,stabilizers.`stabilizers_descr`,stabilizers.`stabilizers_country`,stabilizers.`stabilizers_stabilizer`,avtomatika.`avtomatika_modem`,avtomatika.`avtomatika_flag`,avtomatika.`avtomatika_bupass`,avtomatika.`avtomatika_sharger`,avtomatika.`avtomatika_sontactors`,avtomatika.`avtomatika_max_power1`,avtomatika.`avtomatika_max_power3`,avtomatika.`avtomatika_voltage`,avtomatika.`avtomatika_rated_current`,avtomatika.`avtomatika_particular_qualities`,avtomatika.`avtomatika_photoes`,avtomatika.`avtomatika_capabilities` , `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_general_ecommerce_fields` as general ON general.good_id = g.id LEFT JOIN `tbl_generators_ecommerce_fields` as generators ON generators.good_id = g.id LEFT JOIN `tbl_welding_ecommerce_fields` as welding ON welding.good_id = g.id LEFT JOIN `tbl_stabilizers_ecommerce_fields` as stabilizers ON stabilizers.good_id = g.id LEFT JOIN `tbl_avtomatika_ecommerce_fields` as avtomatika ON avtomatika.good_id = g.id WHERE (`status` = 'enable' AND `good_off`=0 AND general_producer = 'ТСС (Россия)' AND generators_construction <> 'в контейнере' AND general_model ='АД-100С-Т400-1РПМ2 (Engga)' or generators_start_auto <> '' AND general_model = 'АД-100С-Т400-1РПМ2 (Engga)' AND rent_good=0 AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) AND ((general_producer not like '%gmp%' or producer_engine not like '%Kubota%')) ORDER BY (if (price_rub>0, price_rub,if ('asc'='asc',999999999999999999,-1))) asc LIMIT 3Доставка