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(31592, 31805, 31806, 31807, 31809, 31810, 31812, 31813, 31814, 31815, 31817, 31818, 31819, 31820, 31823, 31824, 31826, 31827, 31832, 31833, 31835, 33169, 33170, 33174, 33179, 34540, 54066, 54070, 54071, 54072, 57219, 54067, 54068) 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*/