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 = 65781577
AND product_uid_id <> 1934103
# Сравнение
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*/