SELECT SQL_CALC_FOUND_ROWS /* 736,325617 */ product_uid_id, product_cnt_account, product_hld_holder, product_mbr_member, product_chr_link, REPLACE (product_chr_name, 'В-д', 'Велосипед') AS product_chr_name, product_chr_article, product_set_brand, ROUND(product_dec_price1, 0) AS product_main_price, ROUND(product_dec_price1, 0) AS product_dec_price1, product_txt_text, product_txt_text2, product_set_group2, product_lnk_factory, product_enm_exists, product_dec_price1 AS product_dec_current, COALESCE(product_img_image, NULL, '/i/no_product_photo.png') AS product_img_image, (CASE WHEN product_enm_action <> 'YES' THEN 'Нет в наличии' WHEN product_enm_exists <> 'YES' THEN 'Под заказ' ELSE 'В наличии' END) AS product_chr_exists, product_enm_new, product_enm_top, (CASE WHEN product_dec_price2 > product_dec_price1 THEN 'YES' ELSE 'NO' END) AS product_enm_sale, factory.list_chr_link AS brand_chr_link, compare.basket_uid_id AS compare_uid_id, #Характеристики factory.list_chr_name AS factory_chr_name, product_int_balance2, product_set_field1, product_set_field2, product_set_field3, product_set_field4, product_set_field5, product_set_field6, product_set_field7, product_set_field8, product_set_field9, product_set_field10, product_set_material, product_set_stock1, product_set_stock2, product_chr_box, product_set_print, product_chr_article1c, product_chr_article3d, product_set_collection, product_set_season, product_set_field11, product_set_size, product_set_color, product_set_field12, product_set_holiday, product_set_weight, /*формируем дескрипшн*/ CONCAT (REPLACE (product_chr_name, 'В-д', 'Велосипед'),' в продаже. Цена ', ROUND(product_dec_price1, 0), ' руб. Бренд ', factory.list_chr_name, '. Доставка по Москве и РФ.') AS product_txt_descr, /*формируем кейвордс*/ CONCAT (REPLACE (product_chr_name, 'В-д', 'Велосипед'),', ',LOWER( REPLACE (product_chr_name, 'В-д', 'Велосипед')), ' купить') AS product_txt_keywords, CONCAT (REPLACE (product_chr_name, 'В-д', 'Велосипед'),' купить в Москве') AS product_chr_title FROM account_product FORCE INDEX (account_holder_member_link) LEFT JOIN account_list AS factory ON factory.list_uid_id = product_lnk_factory # Сравнение LEFT JOIN account_basket AS compare ON basket_cnt_account = 736 AND basket_hld_holder = product_hld_holder AND basket_lnk_link = product_uid_id AND basket_mbr_member = 0 AND basket_tbl_table = 'account_product' AND basket_fnc_function = 100 AND basket_int_flag = 1 WHERE product_cnt_account = 736 AND product_hld_holder IN(9241) AND product_mbr_member IN(31643) AND product_enm_action = 'YES' GROUP BY product_uid_id ORDER BY product_uid_id ASC LIMIT 16 OFFSET 0 /* module_id:325617 date() integer() like() letter() _Items*/