Exception: Query error 42S02: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'klykva.klykva_item_mods' doesn't exist. Query: SELECT
`klykva_items`.`id`, `klykva_items`.`klykva_group_id`, `klykva_items`.`klykva_producer_id`, `klykva_items`.`weight`, `klykva_items`.`length`, `klykva_items`.`width`, `klykva_items`.`height`,
CEILING(
IF(
(SELECT SUM(klykva_warehouse_items.count) FROM klykva_warehouse_items WHERE klykva_warehouse_items.klykva_item_id = `klykva_items`.id),
(case
when `klykva_items`.`price` * 1 * 1 < 50
then `klykva_items`.`price` * 1 * 2.80
when `klykva_items`.`price` * 1 * 1 < 100
then `klykva_items`.`price` * 1 * 2.30
when `klykva_items`.`price` * 1 * 1 < 200
then `klykva_items`.`price` * 1 * 2.10
else
`klykva_items`.`price` + ( `klykva_items`.`price` * `klykva_group_fixprices`.`percent` / 100) + `klykva_group_fixprices`.`price`
end),
IF(
(SELECT klykva_fixprices.price FROM klykva_fixprices
WHERE klykva_fixprices.klykva_item_id = `klykva_items`.id AND klykva_fixprices.klykva_region_id = 9),
(SELECT klykva_fixprices.price FROM klykva_fixprices
WHERE klykva_fixprices.klykva_item_id = `klykva_items`.id AND klykva_fixprices.klykva_region_id = 9),
CASE
WHEN mods.price * mods.min_quantity < 50
THEN mods.price * 2.80
WHEN mods.price * mods.min_quantity < 100
THEN mods.price * 2.30
WHEN mods.price * mods.min_quantity < 200
THEN mods.price * 2.10
ELSE
GREATEST(
(SELECT
MAX(`klykva_item_mods`.`price_mrc`)
FROM
`klykva_item_mods`
WHERE `klykva_item_mods`.`klykva_item_id` = `klykva_items`.`id`
GROUP BY `klykva_item_mods`.`klykva_item_id`),
(SELECT
m.`price` + (m.`price` * `klykva_group_fixprices`.`percent` / 100) + `klykva_group_fixprices`.`price`
FROM
`klykva_item_mods` m
LEFT JOIN `klykva_sellers` s ON s.id=m.`klykva_seller_id`
WHERE m.`klykva_item_id` = `klykva_items`.`id` AND m.`active` = 1 AND m.`price`>0
ORDER BY m.`quantity_step`, m.`min_quantity`, (m.`price` + (m.`price` * COALESCE(LOG(4,m.`supply_period` + s.`day`),0)/3)), m.`price`, m.`quantity`
LIMIT 1)
)
END)
)
) AS `absolute_price`
FROM `klykva_items`
INNER JOIN `klykva_group_fixprices` ON `klykva_group_fixprices`.`klykva_group_id` = `klykva_items`.`klykva_group_id` AND `klykva_group_fixprices`.`klykva_region_id` = '9'
INNER JOIN `klykva_item_mods` AS `mods` ON `mods`.`klykva_item_id` = `klykva_items`.`id`
WHERE `klykva_items`.`klykva_id` = '1' AND ( `klykva_items`.`end_datetime` > '2024-05-17 01:39:01' OR `klykva_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `klykva_items`.`active` = 1 AND `klykva_items`.`klykva_producer_id` = '3252' AND `klykva_items`.`deleted` = 0 AND (SELECT COUNT(*) FROM klykva_item_mods m WHERE m.`klykva_item_id`=klykva_items.id AND (m.`active`=1 AND m.`deleted`=0 OR (klykva_items.price>0 and m.`klykva_seller_id` IN (36,110)))) > 0
GROUP BY `klykva_items`.`id`
modules/core/database/pdo.php:657 Core_Exception->__construct
modules/core/querybuilder/statement.php:78 Core_DataBase_Pdo->query
modules/asmp/klykva/controller/show.php:1007 Core_QueryBuilder_Statement->execute
modules/asmp/klykva/controller/show.php:548 ASMP_Klykva_Controller_Show->_preQueryBuilderInit
hostcmsfiles/lib/lib_96/lib_config_96.php:163 ASMP_Klykva_Controller_Show->procces
modules/core/command/controller/default.php:525 include
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:234 Core_Router_Route->execute