SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,stabilizatory.`stab_power`,stabilizatory.`stab_producer`,stabilizatory.`stab_country`,stabilizatory.`stab_model`,stabilizatory.`stab_diapazon_voltage`,stabilizatory.`stab_tochnost_vyx_voltage`,stabilizatory.`stab_workvx_voltage`,stabilizatory.`stab_izmenenie_nagryzki`,stabilizatory.`stab_vyxod`,stabilizatory.`stab_kpd`,stabilizatory.`stab_gabarity`,stabilizatory.`stab_weight`,stabilizatory.`stab_temperature`,stabilizatory.`stab_tipe`,stabilizatory.`stab_description`,stabilizatory.`topology`,stabilizatory.`bypass`,stabilizatory.`shell`,stabilizatory.`temperature`,stabilizatory.`humidity`,stabilizatory.`noise_level`,stabilizatory.`stab_existence`,stabilizatory.`stab_producer_rus`,stabilizatory.`stab_protection`,stabilizatory.`stab_linput`,stabilizatory.`stab_loutput`,stabilizatory.`stabilizator_query`,stabilizatory.`is_stab`,stabilizatory.`nominal_stab_voltage_regulation_range`,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_stabilizatory_ecommerce_fields` as stabilizatory ON stabilizatory.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 (4994) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) and ( 1=1 ) ORDER BY g.id
Стабилизатор напряжения DELTA STK 330300 мощностью 300 кВт, напряжением 155 - 490 В в Ростове-на-Дону
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 (g.`good_off`=0 AND g.`id` in (43,82,83) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) and ( 1=1 ) ORDER BY id