2 exception(s): Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'price' in where clause is ambiguous, query was: SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`name`, `e`.`short_description`, `e`.`description`, `e`.`price`, `e`.`thumbnail`, `e`.`special_price`, `e`.`special_to_date`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`sku_policy` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (final_price < price) AND (stock_status_index.stock_status = 1) ORDER BY `e`.`name` asc Exception #1 (PDOException): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'price' in where clause is ambiguous Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'price' in where clause is ambiguous, query was: SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`name`, `e`.`short_description`, `e`.`description`, `e`.`price`, `e`.`thumbnail`, `e`.`special_price`, `e`.`special_to_date`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`sku_policy` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (final_price < price) AND (stock_status_index.stock_status = 1) ORDER BY `e`.`name` asc
#1 Magento\Framework\DB\Statement\Pdo\Mysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303]
#2 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]
#3 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#4 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:546]
#5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:613]
#6 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:128]
#7 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737]
#8 Zend_Db_Adapter_Abstract->fetchAll() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:1558]
#9 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->fetchAll() called at [vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php:21]
#10 Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:782]
#11 Magento\Framework\Data\Collection\AbstractDb->_fetchAll() called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:1130]
#12 Magento\Eav\Model\Entity\Collection\AbstractCollection->_loadEntities() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1129]
#13 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->_loadEntities() called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:927]
#14 Magento\Eav\Model\Entity\Collection\AbstractCollection->load() called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:832]
#15 Magento\Catalog\Model\ResourceModel\Product\Collection->load() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#16 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#17 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#18 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callPlugins() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:195]
#19 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->load() called at [vendor/magento/framework/Data/Collection.php:838]
#20 Magento\Framework\Data\Collection->getIterator() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1779]
#21 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getIterator() called at [vendor/magento/module-catalog/Block/Rss/Product/Special.php:130]
#22 Magento\Catalog\Block\Rss\Product\Special->getRssData() called at [vendor/magento/module-rss/Model/Rss.php:78]
#23 Magento\Rss\Model\Rss->getFeeds() called at [vendor/magento/module-rss/Model/Rss.php:109]
#24 Magento\Rss\Model\Rss->createRssXml() called at [vendor/magento/module-rss/Controller/Feed/Index.php:49]
#25 Magento\Rss\Controller\Feed\Index->execute() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#26 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#27 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#28 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins() called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:26]
#29 Magento\Rss\Controller\Feed\Index\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:108]
#30 Magento\Framework\App\Action\Action->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#31 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#32 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#33 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins() called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:39]
#34 Magento\Rss\Controller\Feed\Index\Interceptor->dispatch() called at [vendor/magento/framework/App/FrontController.php:162]
#35 Magento\Framework\App\FrontController->processRequest() called at [vendor/magento/framework/App/FrontController.php:98]
#36 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#37 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#38 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:99]
#39 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#40 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [app/code/Amasty/InvisibleCaptcha/Plugin/Framework/App/FrontControllerInterface/ValidateCaptcha.php:118]
#41 Amasty\InvisibleCaptcha\Plugin\Framework\App\FrontControllerInterface\ValidateCaptcha->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#42 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:69]
#43 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#44 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#45 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#46 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->___callPlugins() called at [generated/code/Magento/PageCache/Model/App/FrontController/BuiltinPlugin/Interceptor.php:26]
#47 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#48 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#49 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:26]
#50 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:116]
#51 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:24]
#52 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:261]
#53 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:40]
Exception #1 (PDOException): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'price' in where clause is ambiguous
#1 Magento\Framework\DB\Statement\Pdo\Mysql->Magento\Framework\DB\Statement\Pdo\{closure}() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:107]
#2 Magento\Framework\DB\Statement\Pdo\Mysql->tryExecute() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:92]
#3 Magento\Framework\DB\Statement\Pdo\Mysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303]
#4 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]
#5 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#6 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:546]
#7 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:613]
#8 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:128]
#9 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737]
#10 Zend_Db_Adapter_Abstract->fetchAll() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:1558]
#11 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->fetchAll() called at [vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php:21]
#12 Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:782]
#13 Magento\Framework\Data\Collection\AbstractDb->_fetchAll() called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:1130]
#14 Magento\Eav\Model\Entity\Collection\AbstractCollection->_loadEntities() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1129]
#15 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->_loadEntities() called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:927]
#16 Magento\Eav\Model\Entity\Collection\AbstractCollection->load() called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:832]
#17 Magento\Catalog\Model\ResourceModel\Product\Collection->load() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#18 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#19 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#20 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callPlugins() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:195]
#21 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->load() called at [vendor/magento/framework/Data/Collection.php:838]
#22 Magento\Framework\Data\Collection->getIterator() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1779]
#23 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getIterator() called at [vendor/magento/module-catalog/Block/Rss/Product/Special.php:130]
#24 Magento\Catalog\Block\Rss\Product\Special->getRssData() called at [vendor/magento/module-rss/Model/Rss.php:78]
#25 Magento\Rss\Model\Rss->getFeeds() called at [vendor/magento/module-rss/Model/Rss.php:109]
#26 Magento\Rss\Model\Rss->createRssXml() called at [vendor/magento/module-rss/Controller/Feed/Index.php:49]
#27 Magento\Rss\Controller\Feed\Index->execute() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#28 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#29 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#30 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins() called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:26]
#31 Magento\Rss\Controller\Feed\Index\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:108]
#32 Magento\Framework\App\Action\Action->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#33 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#34 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#35 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins() called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:39]
#36 Magento\Rss\Controller\Feed\Index\Interceptor->dispatch() called at [vendor/magento/framework/App/FrontController.php:162]
#37 Magento\Framework\App\FrontController->processRequest() called at [vendor/magento/framework/App/FrontController.php:98]
#38 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#39 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#40 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:99]
#41 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#42 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [app/code/Amasty/InvisibleCaptcha/Plugin/Framework/App/FrontControllerInterface/ValidateCaptcha.php:118]
#43 Amasty\InvisibleCaptcha\Plugin\Framework\App\FrontControllerInterface\ValidateCaptcha->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#44 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:69]
#45 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#46 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#47 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#48 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->___callPlugins() called at [generated/code/Magento/PageCache/Model/App/FrontController/BuiltinPlugin/Interceptor.php:26]
#49 Magento\PageCache\Model\App\FrontController\BuiltinPlugin\Interceptor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#50 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#51 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:26]
#52 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:116]
#53 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:24]
#54 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:261]
#55 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:40]