Exception: Query error 1525: Incorrect DATETIME value: '0000-00-00 00:00:00'. Query: SELECT
MIN(t.absolute_price) AS `min`, MAX(t.absolute_price) AS `max`
FROM (SELECT
IF (`shop_items`.`shop_currency_id` = '3', IF (shop_discounts.percent, price * (100 - shop_discounts.percent) * 23.639664 / 100, shop_items.price * 23.639664), IF (`shop_items`.`shop_currency_id` = '2', IF (shop_discounts.percent, price * (100 - shop_discounts.percent) * 36.889479 / 100, shop_items.price * 36.889479), IF (`shop_items`.`shop_currency_id` = '1', IF (shop_discounts.percent, price * (100 - shop_discounts.percent) * 1 / 100, shop_items.price * 1), price))) AS `absolute_price`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_discounts` ON `shop_items`.`id` = `shop_item_discounts`.`shop_item_id`
LEFT OUTER JOIN `shop_discounts` ON `shop_item_discounts`.`shop_discount_id` = `shop_discounts`.`id` AND ( `shop_discounts`.`end_datetime` >= '2026-04-24 16:09:13' OR `shop_discounts`.`end_datetime` = '0000-00-00 00:00:00' AND `shop_discounts`.`start_datetime` <= '2026-04-24 16:09:13' )
WHERE `shop_items`.`shop_id` = '1' AND `shop_items`.`shop_group_id` IN ('601', '618')
GROUP BY `shop_items`.`id`) AS `t`
35 modules/core/exception.php
654 modules/core/database/mysql.php
60 modules/core/querybuilder/statement.php
539 hostcmsfiles/lib/lib_43/lib_43.php
271 modules/lib/model.php
137 modules/core/page.php
211 templates/template11/template.htm
86 modules/template/model.php
137 modules/core/page.php
145 templates/template1/template.htm
86 modules/template/model.php
137 modules/core/page.php
378 modules/core/command/controller/default.php
190 modules/core/router/route.php
217 index.php