Характеристики:
- Кол-во скоростей: 3
- Материал: хромированная сталь
- Максимальная звезда: 48 Т
- Кол-во скоростей: 3
SELECT SQL_CALC_FOUND_ROWS 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, COALESCE(product_img_image, NULL, '/i/no_product_photo.png') AS product_img_image, ROUND(product_dec_price1, 0) AS product_dec_price1, product_enm_new, product_enm_top, (CASE WHEN product_dec_price2 > product_dec_price1 THEN 'YES' ELSE 'NO' END) AS product_enm_sale, compare.basket_uid_id AS compare_uid_id FROM account_product INNER JOIN reestr_history AS history ON history_uid = product_uid_id AND history_account = 736 AND history_holder = 9241 AND history_module = 331085 AND history_session = 583601118 AND product_uid_id <> 182448 # Сравнение 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_enm_action = 'YES' /*custom-parent*/ GROUP BY product_uid_id ORDER BY product_uid_id ASC LIMIT 10 OFFSET 0 /* module_id:331086 date() integer() like() letter() _Items*/