Похожие товары
47857
SELECT SQL_CALC_FOUND_ROWS
COALESCE(a.goods_ref_link, a.goods_uid_id) AS goods_uid_id,
a.goods_cnt_account,
a.goods_hld_holder,
a.goods_mbr_member,
a.goods_lng_language, /* языковая поддержка */
a.goods_ref_link, /* языковая поддержка */
a.goods_chr_link,
goods_chr_name,
goods_set_field1,
goods_set_field2,
goods_chr_field3,
goods_chr_field4,
goods_chr_field5,
goods_chr_field6,
goods_set_field7,
goods_chr_field8,
goods_chr_article,
goods_lnk_brand,
goods_img_640x480image,
goods_wth_image,
goods_hgt_image,
goods_tmb_120x160image,
goods_img_640x480image2,
goods_wth_image2,
goods_hgt_image2,
goods_txt_abstract,
goods_txt_text,
goods_txt_text2,
goods_int_price1,
goods_int_price2,
goods_int_price3,
goods_int_price4,
goods_int_price5,
goods_int_price6,
goods_int_price7,
goods_int_value,
goods_chk_size,
goods_chk_option,
goods_clr_color,
goods_enm_hot,
goods_enm_new,
goods_enm_sale,
goods_enm_hit,
goods_enm_spec,
goods_enm_exists,
goods_int_balance,
goods_txt_descr,
goods_txt_keywords,
goods_chr_title,
goods_ind_index,
goods_smp_create,
goods_smp_update,
(CASE
WHEN goods_int_balance > 0 AND goods_int_price1 > 0 AND goods_enm_exists = "YES"
THEN goods_int_balance
WHEN goods_int_value > 0 AND goods_int_price2 > 0 AND goods_enm_exists = "YES"
THEN goods_int_value
ELSE 0
END) AS Balance,
(CASE
WHEN goods_int_balance > 0 AND goods_int_price1 > 0 AND goods_enm_exists = "YES"
THEN goods_int_balance
WHEN goods_int_value > 0 AND goods_int_price2 > 0 AND goods_enm_exists = "YES"
THEN goods_int_value
ELSE 9999
END) AS MaxBalance,
#Цена за штуку
(
CASE
WHEN ROUND((goods_int_price3 * ( SELECT currency_usd FROM reestr_currency ) * (1 + goods_int_price5 * 0.01) ),2) <> '0.00'
THEN ROUND((goods_int_price3 * ( SELECT currency_usd FROM reestr_currency ) * (1 + goods_int_price5 * 0.01) ),2)
ELSE goods_int_price1
END
)
AS price_per_unit,
#Цена за метр
(
CASE
WHEN ROUND((goods_int_price4 * ( SELECT currency_usd FROM reestr_currency ) * (1 + goods_int_price5 * 0.01) ),2) <> '0.00'
THEN ROUND((goods_int_price4 * ( SELECT currency_usd FROM reestr_currency ) * (1 + goods_int_price5 * 0.01) ),2)
ELSE goods_int_price2
END
)
AS price_per_meter,
#Пристутсвует скидка
(
CASE
WHEN goods_int_price6 <> '0.00'
THEN 'newprice'
ELSE ''
END
)
AS newprice,
#Скидка по акции
GREATEST( data.data_int_value3, data.data_int_value6, data.data_int_value9 ) As Discount,
data.data_chr_name AS ActionName,
COUNT(data.data_chr_name) AS ActionCount,
data.data_chr_link AS ActionHref,
ROUND(data.data_int_value2) AS ActionMinCount,
#Цена за штуку по акции
ROUND((
CASE
WHEN ROUND((goods_int_price3 * ( SELECT currency_usd FROM reestr_currency ) * (1 + goods_int_price5 * 0.01) ),2) <> '0.00'
THEN ROUND((goods_int_price3 * ( SELECT currency_usd FROM reestr_currency ) * (1 + goods_int_price5 * 0.01) ),2)
ELSE goods_int_price1
END
) / 100 * (100 - GREATEST( data.data_int_value3, data.data_int_value6, data.data_int_value9 )))
AS price_per_unit_action,
#Цена за метр по акции
ROUND((
CASE
WHEN ROUND((goods_int_price4 * ( SELECT currency_usd FROM reestr_currency ) * (1 + goods_int_price5 * 0.01) ),2) <> '0.00'
THEN ROUND((goods_int_price4 * ( SELECT currency_usd FROM reestr_currency ) * (1 + goods_int_price5 * 0.01) ),2)
ELSE goods_int_price2
END
) / 100 * (100 - GREATEST( data.data_int_value3, data.data_int_value6, data.data_int_value9 )))
AS price_per_meter_action
FROM account_goods a
LEFT JOIN account_data data ON (data.data_chr_field2 = goods_uid_id
OR (data_chr_field1 RLIKE goods_mbr_member AND data_chr_field3 NOT RLIKE goods_uid_id))
AND data_cnt_account = 553
AND data_hld_holder = 7786
AND data_chk_attribute&get_panda_content_code('panda-stroy.ru')
WHERE a.goods_cnt_account=553
AND a.goods_hld_holder IN(7393)
AND a.goods_mbr_member IN(47857)
AND
goods_enm_hit = "NO" AND goods_uid_id <> 1311290
AND a.goods_lng_language IS NULL /* объединения нет, доп. язык тоже не выбран, берем основной (module:324734) */
GROUP BY goods_chr_name
ORDER BY goods_uid_id ASC
LIMIT 8 OFFSET 0 /* module_id:324734
date()
integer()
like()
letter() _Items*/
