Манет.Front SRAM X.0 Trigger (00.7015.040.020)

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 = 65823750
  AND product_uid_id <> 182349

# Сравнение 
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*/