SELECT node.nid AS nid, uc_products.model AS uc_products_model, uc_products.nid AS uc_products_nid, node.type AS node_type, node.vid AS node_vid, node_data_field_attr_1.field_attr_1_value AS node_data_field_attr_1_field_attr_1_value, node_data_field_attr_2.field_attr_2_value AS node_data_field_attr_2_field_attr_2_value, node_data_field_attr_3.field_attr_3_value AS node_data_field_attr_3_field_attr_3_value, node_data_field_attr_4.field_attr_4_value AS node_data_field_attr_4_field_attr_4_value, uc_products.sell_price AS uc_products_sell_price, node_data_field_attr_3.field_sale_value AS node_data_field_attr_3_field_sale_value, node_data_field_attr_3.field_new_product_value AS node_data_field_attr_3_field_new_product_value, node.status AS node_status, node_data_field_attr_3.field_hrn_price_value AS node_data_field_attr_3_field_hrn_price_value, node_data_field_attr_3.field_aval_value AS node_data_field_attr_3_field_aval_value, node_data_field_attr_3.field_present_value AS node_data_field_attr_3_field_present_value, node_data_field_attr_3.field_bncof_value AS node_data_field_attr_3_field_bncof_value, node_data_field_attr_3.field_act_end_value AS node_data_field_attr_3_field_act_end_value, node_data_field_attr_3.field_act_start_value AS node_data_field_attr_3_field_act_start_value, node_data_field_attr_3.field_obhod_value AS node_data_field_attr_3_field_obhod, node_data_field_attr_3.field_podkl_value AS node_data_field_attr_3_field_podkl, node_data_field_attr_3.field_producer_value AS node_data_field_attr_3_field_producer, node_data_field_attr_3.field_using_value AS node_data_field_attr_3_field_using, node_data_field_attr_3.field_act_discount_value AS node_data_field_attr_3_field_act_discount_value, node_data_field_f_pr.field_f_pr_value AS node_data_field_f_pr_field_f_pr_value, node_data_field_attr_3.field_f_esg_value AS node_data_field_f_esg_field_f_esg_value, node_data_field_attr_3.field_is_act_value AS node_data_field_attr_3_field_is_act_value, node_data_field_attr_3.field_f_ag_value AS node_data_field_f_ag_field_f_ag_value, node_data_field_attr_3.field_f_ig_value AS node_data_field_f_ig_field_f_ig_value, node_data_field_attr_3.field_f_bibp_value AS node_data_field_attr_3_field_f_bibp_value, node_data_field_attr_3.field_art_value AS node_data_field_attr_3_field_art_value, node_data_field_attr_3.field_f_stibp_value AS node_data_field_attr_3_field_f_stibp_value, node_data_field_f_vpo.field_f_vpo_value AS node_data_field_f_vpo_field_f_vpo_value, node_data_field_f_npo.field_f_npo_value AS node_data_field_f_npo_field_f_npo_value, node_data_field_f_tnv.field_f_tnv_value AS node_data_field_f_tnv_field_f_tnv_value, node_data_field_attr_3.field_f_ncpt_value AS node_data_field_attr_3_field_f_ncpt_value, node_data_field_aval.field_aval_value AS node_data_field_aval_field_aval_value, uc_products.ordering AS uc_products_ordering FROM node node LEFT JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = '99' LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid LEFT JOIN content_field_attr_1 node_data_field_attr_1 ON node.vid = node_data_field_attr_1.vid LEFT JOIN content_field_attr_2 node_data_field_attr_2 ON node.vid = node_data_field_attr_2.vid LEFT JOIN content_type_energo node_data_field_attr_3 ON node.vid = node_data_field_attr_3.vid LEFT JOIN content_field_attr_4 node_data_field_attr_4 ON node.vid = node_data_field_attr_4.vid LEFT JOIN content_field_f_pr node_data_field_f_pr ON node.vid = node_data_field_f_pr.vid LEFT JOIN content_field_f_vpo node_data_field_f_vpo ON node.vid = node_data_field_f_vpo.vid LEFT JOIN content_field_f_npo node_data_field_f_npo ON node.vid = node_data_field_f_npo.vid LEFT JOIN content_field_f_tnv node_data_field_f_tnv ON node.vid = node_data_field_f_tnv.vid LEFT JOIN content_type_energo node_data_field_aval ON node.vid = node_data_field_aval.vid WHERE (node.type in ('product', 'climat', 'energo', 'tech')) AND (node.status <> 0) AND (term_node_value_0.tid = '99') AND node_data_field_attr_4.field_attr_4_value = 'релейный тип' AND node_data_field_attr_3.field_producer_value LIKE 'СТАБИК%' AND node_data_field_f_pr.field_f_pr_value = 'ступенчатая' AND node_data_field_attr_3.field_obhod_value = 'да'
theme649