SELECT
items.chain_id,
items.product_id,
items.products,
items.modifier,
items.modifier_type,
items.date_from,
items.date_to,
items.display_in_promotions,
items.status,
descr.name,
descr.description
FROM
cscart_buy_together AS items
LEFT JOIN cscart_products AS p ON p.product_id = items.product_id
LEFT JOIN cscart_buy_together_descriptions AS descr ON items.chain_id = descr.chain_id
AND descr.lang_code = 'en'
WHERE
items.product_id = 15054
AND items.status = 'A'
AND (
(
items.date_from <= 1727560800
AND items.date_to >= 1727560800
)
OR (
items.date_from = 0
AND items.date_to >= 1727560800
)
OR (
items.date_from <= 1727560800
AND items.date_to = 0
)
OR (
items.date_from = 0
AND items.date_to = 0
)
)