[SCR_P]WyJcclxuICAgICQoZnVuY3Rpb24oKSB7XHJcbiAgICAgICAgdmFyIGZpbHRlciA9IG5ldyBRdWlja0ZpbHRlcnMoe1xyXG4gICAgICAgICAgICBmb3JtX3NlbGVjdG9yOiAnZm9ybVtuYW1lPVwiZmlsdHJvc1wiXScsXHJcbiAgICAgICAgICAgIGZpbHRlcmVkX2lucHV0czogW10sXHJcbiAgICAgICAgICAgIHRlY19maWx0ZXI6ICcnLFxyXG4gICAgICAgICAgICBwcmljZV9taW46ICcnLFxyXG4gICAgICAgICAgICBwcmljZV9tYXg6ICcnLFxyXG4gICAgICAgICAgICBvZmZlcl9taW46ICcnLFxyXG4gICAgICAgICAgICBvZmZlcl9tYXg6ICcnLFxyXG4gICAgICAgICAgICBkZWZhdWx0X3JlZGlyZWN0OiAnJyxcclxuICAgICAgICAgICAgbWFudWZhY3R1cmVyc19maWx0ZXI6ICcnLFxyXG4gICAgICAgICAgICBrZXl3b3JkczogJycsXHJcbiAgICAgICAgICAgIHN0b2NrX2ZpbHRlcjogJycsXHJcbiAgICAgICAgfSk7XHJcbiAgICB9KTtcclxuIiwiXHJcbiAgICAkKGZ1bmN0aW9uKCl7XHJcbiAgICAgICAgdmFyIGNjID0gICcwJztcclxuICAgICAgICB2YXIgY2F0ZWdvcmllc0ZpbHRlciA9ICQoZG9jdW1lbnQpLmZpbmQoJyNmaWx0ZXItY2F0ZWdvcmllcycpLmZpcnN0KCk7XHJcblxyXG4gICAgICAgIGlmKCFjYyl7IFxyXG4gICAgICAgICAgICBjYXRlZ29yaWVzRmlsdGVyLmZpbmQoJy5jYXRlZ29yeS1tZW51JykuZmlyc3QoKS5yZW1vdmVDbGFzcygnaW4nKTtcclxuICAgICAgICAgICAgY2F0ZWdvcmllc0ZpbHRlci5maW5kKCcubWFpbkZpbHRlciBpJykuZmlyc3QoKS5hZGRDbGFzcygnZmEtYW5nbGUtZG93bicpLnJlbW92ZUNsYXNzKCdmYS1hbmdsZS11cCcpO1xyXG4gICAgICAgIH1lbHNle1xyXG4gICAgICAgICAgICBjYXRlZ29yaWVzRmlsdGVyLmZpbmQoJy5jYXRlZ29yeS1tZW51JykuZmlyc3QoKS5hZGRDbGFzcygnaW4nKTtcclxuICAgICAgICAgICAgY2F0ZWdvcmllc0ZpbHRlci5maW5kKCcubWFpbkZpbHRlciBpJykuZmlyc3QoKS5hZGRDbGFzcygnZmEtYW5nbGUtdXAnKS5yZW1vdmVDbGFzcygnZmEtYW5nbGUtZG93bicpO1xyXG4gICAgICAgIH1cclxuXHJcbiAgICB9KTtcclxuIiwiXHJcbiAgICBcL1wvU2UgZGVmaW5lIGVsIHNpZ3VpZW50ZSBjXHUwMGYzZGlnbyBwYXJhIHF1ZSBjdWFuZG8gc2UgZXN0ZSBkZW50cm8gZGUgdW5hIGNhdGVnb3JcdTAwZWRhIHNlIGRlc3BsaWVnZSBsb3Mgc3VibWVudWVzIHF1ZSB0aWVuZW5cclxuICAgICQoZG9jdW1lbnQpLnJlYWR5KGZ1bmN0aW9uKCkge1xyXG4gICAgICB2YXIgYXJyQ3BhdGggPSBbXCI1NDBcIixcIjU0MVwiXTtcclxuICAgICAgJC5lYWNoKGFyckNwYXRoLCBmdW5jdGlvbiggaW5kZXgsIHZhbHVlICkge1xyXG4gICAgICAgICQoXCIjY2FyZXRfXCIrdmFsdWUpLnRyaWdnZXIoJ2NsaWNrJyk7XHJcbiAgICAgIH0pO1xyXG4gICAgfSk7Il0=[/SCR_P]
1146 -
SELECT md.discounts_id
FROM mods_discounts md
LEFT JOIN discounts_products dp ON md.discounts_id = dp.discounts_id AND dp.products_id = '4844'
-- descuento x categorÃa x cliente
-- descuento x categorÃa que aplica a todos los clientes
LEFT JOIN discounts_categories_customers dcc2 ON dcc2.discounts_id = md.discounts_id AND (dcc2.customers_id IS NULL OR dcc2.customers_id = 0)
LEFT JOIN products_to_categories p2c2 ON dcc2.categories_id = p2c2.categories_id AND p2c2.products_id = '4844'
-- descuento x fabricante x cliente
-- //DS 20250930 agregamos el caso de descuneto x fabricante que aplica a todos los clientes
LEFT JOIN discounts_manufacturers_customers dmc2 ON dmc2.discounts_id = md.discounts_id AND (dmc2.customers_id IS NULL OR dmc2.customers_id = 0)
LEFT JOIN products p2 ON dmc2.manufacturers_id = p2.manufacturers_id AND p2.products_id = '4844'
WHERE (dp.products_id = '4844' OR (md.all_customers = 1 AND p2c2.products_id = '4844') OR (md.all_customers = 1 AND p2.products_id = '4844'))
AND discounts_status = 1
AND discount_type = 1
AND (md.all_lists = 1 OR md.list_price_1 = 1)
AND (IF(md.initial_date IS NULL, '2000-12-31', md.initial_date) <= '2025-11-18 12:57:51')
AND (IF(md.expire_date IS NULL, '9999-12-31', md.expire_date) >= '2025-11-18 12:57:51')
AND ((md.all_customers = 1 AND (dcc2.customers_id IS NULL OR dcc2.customers_id = 0) AND (dmc2.customers_id IS NULL OR dmc2.customers_id = 0)))
GROUP BY md.discounts_id
ORDER BY md.orden ASC LIMIT 1
[TEP STOP]
