SELECT /* 663,317735 */ id AS product_uid_id, WEIGHT() AS weight, WEIGHT() AS product_int_weight, product_hld_holder, product_mbr_member, product_dec_value1, product_lnk_parent AS eqproduct_lnk_parent, product_chr_name, product_chr_article, product_int_quota, product_int_minimum, product_img_image, product_chr_folderchild, product_chr_folderparent, product_int_balance, product_int_balance AS gteproduct_int_balance1, product_set_field5 AS eqproduct_set_field5, product_set_group1, product_set_filtercolor AS eqproduct_set_color, product_set_size, product_set_filtermaterial AS eqproduct_set_material, product_set_flashvolume, product_set_print, product_set_color, product_set_brand AS eqproduct_set_brand, product_set_brand, /* JSON массив из цветов товара по групповому артикулу product_txt_json_colors,*/ class_item_textile, class_button_textile, product_int_percent, product_int_fullbalance1, product_int_fullfree1, product_int_balance1, product_int_balance2, product_int_balance3, product_int_free1, product_int_points, product_int_balance, product_int_edition, product_int_sumedition, product_int_ratio, product_enm_new, product_enm_top, product_enm_sale, product_enm_promo, product_enm_manually, product_enm_europe, /* Поля необходимые для вывода минимального заказа для товаров добавленных вручную product_int_delivery11, product_int_delivery12, */ product_lnk_factory AS eqproduct_lnk_factory, product_txt_text, product_txt_text2, product_dec_current, product_dec_old, product_dec_current_display, product_dec_old_display, /* Актуальная цена */ product_dec_price, product_dec_price AS product_dec_price1, /* Сортировка по цене(по запросу убираем ВСЕГДА в конец списка) */ IF(product_dec_price = 0, 1, 0) AS price, product_chr_article22, product_chr_article23, product_chr_article24, product_chr_article25, product_chr_article26 FROM gmh_product_index WHERE MATCH('portobello trend star') AND weight > 500 GROUP BY product_set_group1, product_set_flashvolume ORDER BY price ASC, weight DESC, product_dec_price1 ASC LIMIT 0, 50 OPTION max_matches = 3000, field_weights = ( product_chr_box = 10000, product_chr_synonym = 10000, product_chr_name = 5000, product_chr_folderparent = 7500, product_chr_folderchild = 7500, product_set_brand=5000, product_set_group1=5000, product_chr_article=5000, product_chr_article1=5000, product_chr_article2=5000, product_chr_article3=5000, product_chr_article4=5000, product_chr_article5=5000, product_chr_article6=5000, product_chr_article7=5000, product_chr_article8=5000, product_chr_article9=5000, product_chr_article10=5000, product_chr_article11=5000, product_chr_article12=5000, product_chr_article13=5000, product_chr_article14=5000, product_chr_article15=5000, product_chr_article16=5000, product_chr_article17=5000, product_chr_article18=5000, product_chr_article19=5000, product_chr_article20=5000, product_chr_article21=5000, product_chr_article22=5000, product_chr_article23=5000, product_chr_article24=5000, product_chr_article25=5000, product_chr_article26=5000, product_chr_article27=5000, product_chr_article28=5000, product_set_filtercolor = 3500, product_set_filtermaterial = 3500, product_txt_text = 100 ) /* utf8 */ /* module_id:317735 date() integer() like() letter() _Items*/