| Подскажите что надо дописать в этот запрос, чтобы выводились товары после определенной даты? Код SELECT
product_sku,
product_name,
case
when product_price2 < product_price1*0.91 then product_price1*0.93
when product_price2 >= product_price1*0.91 and product_price2 < product_price1*0.93 then product_price2-50
when product_price2 >= product_price1*0.93 and product_price2 < product_price1*0.94 then product_price2*0.99
when product_price2 >= product_price1*0.94 and product_price2 < product_price1*0.96 then product_price2*0.98
when product_price2 >= product_price1*0.96 and product_price2 < product_price1*0.98 then product_price2*0.97
when product_price2 >= product_price1*0.98 and product_price2 < product_price1*0.99 then product_price2*0.96
when product_price2 >= product_price1*0.99 and product_price2 < product_price1*1.05 then product_price2*0.95
when product_price2 >= product_price1*1.05 and product_price2 < product_price1*1.10 then product_price2*0.93
end as product_pricesell,
product_price1,
product_price2 as Кортинг,
product_price3 as Kuppersperg,
product_price15 as Blanco,
product_price4 as Bosch,
product_price9 as Aeg,
product_price10 as Zanussi,
product_price11 as Gorenje,
product_price14 as Smeg,
product_price21 as JetAir,
product_price22 as Franke,
product_price23 as Kuppersberg1,
product_price25 as Zigmund,
product_price29 as Elica,
product_price31 as Liebherr,
product_price32 as Lava,
product_price8 as Krona
FROM
(
SELECT
G_SID as "product_sku",
G_NAME as "product_name",
price as "product_price1",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 8 AND SG_PRESENT=1) as "product_price2",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 38 AND SG_PRESENT=1) as "product_price3",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 28 AND SG_PRESENT=1) as "product_price15",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 4 AND SG_PRESENT=1) as "product_price4",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 57 AND SG_PRESENT=1) as "product_price9",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 10 AND SG_PRESENT=1) as "product_price10",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 11 AND SG_PRESENT=1) as "product_price11",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 17 AND SG_PRESENT=1) as "product_price14",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 29 AND SG_PRESENT=1) as "product_price21",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 30 AND SG_PRESENT=1) as "product_price22",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 31 AND SG_PRESENT=1) as "product_price23",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 32 AND SG_PRESENT=1) as "product_price25",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 34 AND SG_PRESENT=1) as "product_price29",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 48 AND SG_PRESENT=1) as "product_price31",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 37 AND SG_PRESENT=1) as "product_price32",
(SELECT TOP 1 SG_PRICE FROM TBL_SUPPLIERS_GOODS WHERE SG_G_ID = G_ID AND SG_S_ID = 7 AND SG_PRESENT=1) as "product_price8"
FROM TBL_GOODS
WHERE G_ACTIVE = 1
AND G_PRESENT = 1
) t
|
