![EDIBLE BEAUTY ON THE FLY - CORE 4 TRAVEL KIT]()
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 = 44164 OR drcc.id_category IN (18,35,47,48,49,50,51,370,376,377,381,383,386,439,442,444,445,446,448,473,482,533,542,560,561,563,564,565,566,568,569,571,572,573))
AND dr.date_from <= "2020-09-24 15:32:31" AND dr.date_to >= "2020-09-24 15:32:31"
English
Lietuvių kalba
Cookies configuration
