![Maisto papildas KALCIS, MAGNIS, CINKAS „Calcium Magnesium & Zinc“, milteliai, 100g]()
SELECT dra.id_quantity_discount_rule
FROM `nwcrsh0_quantity_discount_rule_action` dra
LEFT JOIN nwcrsh0_quantity_discount_rule dr ON dr.id_quantity_discount_rule = dra.id_quantity_discount_rule
LEFT JOIN nwcrsh0_quantity_discount_rule_condition_product drcp ON drcp.id_quantity_discount_rule = dra.id_quantity_discount_rule
LEFT JOIN nwcrsh0_quantity_discount_rule_condition_category drcc ON drcc.id_quantity_discount_rule = dra.id_quantity_discount_rule
WHERE dra.id_type = 8 AND dra.reduction_amount = 0.01 AND dr.active = 1 AND (drcp.id_product = 882 OR drcc.id_category IN (17,18,69,77,78,84,85,86,88,90,93,332,475,501,512,516,523,535,537,557,558,559,588,593,594,595,597,601,606,609,610,611,613,614,615,617))
AND dr.date_from <= "2020-08-14 07:30:27" AND dr.date_to >= "2020-08-14 07:30:27"
English
Lietuvių kalba
Slapukų nustatymai
