SELECT
cscart_promotions.*,
cscart_promotion_descriptions.name,
cscart_promotion_descriptions.detailed_description,
cscart_promotion_descriptions.short_description
FROM
cscart_promotions
LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id
AND cscart_promotion_descriptions.lang_code = 'en'
LEFT JOIN cscart_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_promotions.promotion_id
WHERE
1
AND IF(
from_date, from_date <= 1734946455,
1
)
AND IF(to_date, to_date >= 1734946455, 1)
AND status IN ('A', 'H')
AND cscart_promotions.zone = 'catalog'
AND (
storefronts_promotions.storefront_id = 1
OR storefronts_promotions.storefront_id IS NULL
)
ORDER BY
cscart_promotions.stop_other_rules desc,
cscart_promotions.priority asc