Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'p'. 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`, `klykva_items`.`price` * `klykva_currencies`.`exchange_rate` AS `absolute_price`
FROM `klykva_items`
INNER JOIN `klykva_warehouse_items` ON `klykva_warehouse_items`.`klykva_item_id` = `klykva_items`.`id`
INNER JOIN `klykva_currencies` ON `klykva_currencies`.`id` = `klykva_items`.`klykva_currency_id`
INNER JOIN `property_value_ints` AS `p` ON `p`.`entity_id` = `klykva_items`.`id` AND `p`.`property_id` = '89519' AND `p`.`value` = (237694)
LEFT OUTER JOIN `klykva_item_properties` ON `klykva_items`.`klykva_id` = `klykva_item_properties`.`klykva_id`
LEFT OUTER JOIN `property_value_ints` ON `klykva_items`.`id` = `property_value_ints`.`entity_id` AND `klykva_item_properties`.`property_id` = property_value_ints.property_id
INNER JOIN `property_value_ints` AS `p` ON `p`.`entity_id` = `klykva_items`.`id` AND `p`.`property_id` = '89519' AND `p`.`value` = (237694)
WHERE `klykva_items`.`klykva_id` = 1 AND ( `klykva_items`.`end_datetime` > '2026-11-04 01:02:11' OR `klykva_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `klykva_items`.`price` > 0 AND `klykva_items`.`active` = 1 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 AND ( `klykva_item_properties`.`property_id` = 89519 AND `property_value_ints`.`value` = 237694 ) 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 AND `klykva_items`.`active` = 1 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`, `klykva_items`.`id`
HAVING SUM(`klykva_warehouse_items`.`count`) > 0
modules/core/database/pdo.php:673 Core_Exception->__construct
modules/core/querybuilder/statement.php:92 Core_DataBase_Pdo->query
modules/asmp/klykva/controller/show.php:1929 Core_QueryBuilder_Statement->execute
modules/asmp/klykva/controller/show.php:1604 ASMP_Klykva_Controller_Show->_preQueryBuilderInit
modules/asmp/klykva/controller/show.php:1397 ASMP_Klykva_Controller_Show->procces
templates/template28/template.htm:54 ASMP_Klykva_Controller_Show->getMinPrice
modules/template/model.php:107 include
modules/core/page.php:180 Template_Model->execute
templates/template25/template.htm:179 Core_Page->execute
modules/template/model.php:107 include
modules/core/page.php:180 Template_Model->execute
modules/core/command/controller/default.php:877 Core_Page->execute
modules/core/router/route.php:280 Core_Command_Controller_Default->showAction
modules/core/router/route.php:290 Core_Router_Route->{closure:Core_Router_Route::execute():278}
index.php:607 Core_Router_Route->execute