SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,avr_generators.`avr_controller_type`,avr_generators.`avr_max_load_current`,avr_generators.`avr_max_power_gen`,avr_generators.`avr_type_engine`,avr_generators.`avr_generator`,avr_generators.`avr_external_net`,avr_generators.`avr_control_voltage`,avr_generators.`avr_control_mains_voltage`,avr_generators.`avr_connect_external_generator`,avr_generators.`avr_programmable_system`,avr_generators.`avr_prog_relay_outputs`,avr_generators.`avr_parameter_display_system`,avr_generators.`avr_remote_start_generator`,avr_generators.`avr_hour_meter_generator`,avr_generators.`avr_control_generator`,avr_generators.`avr_monitoring_pc`,avr_generators.`avr_automatic_control`,avr_generators.`avr_block_automatic`,avr_generators.`avr_have_blocking`,avr_generators.`avr_mode`,avr_generators.`avr_display_mode`,avr_generators.`avr_cross_section_power_cable`,avr_generators.`avr_cross_section_control_cable`,avr_generators.`avr_number_cores_control_cable`,avr_generators.`avr_type_shell`,avr_generators.`avr_ingress_potection`,avr_generators.`avr_internal_heating`,avr_generators.`avr_dimensions`,avr_generators.`nominal_current_of_the_power_module`,avr_generators.`brand_of_components`,avr_generators.`avr_execution`,avr_generators.`gsm_module`,avr_generators.`comm_module`,avr_generators.`warranty_period`,avr_generators.`avr_weight`,avr_generators.`avr_producer`,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`,catalog.`id_similar_food` , `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_avr_generators_ecommerce_fields` as avr_generators ON avr_generators.good_id = g.id LEFT JOIN `tbl_catalog_ecommerce_fields` as catalog ON catalog.good_id = g.id
WHERE (g.`good_off`=0 AND g.`id` in (31307) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) and ( 1=1 ) ORDER BY g.id
Блок автомата ввода резерва (АВР) General Power GPC-207-40-I в Дедовске