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` FROM `mgdr_catalog_product_flat_1` AS `e` INNER JOIN `mgdr_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 `mgdr_cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (final_price < price) 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` FROM `mgdr_catalog_product_flat_1` AS `e` INNER JOIN `mgdr_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 `mgdr_cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (final_price < price) ORDER BY `e`.`name` asc
#1 Magento\Framework\DB\Statement\Pdo\Mysql->_execute(array()) called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303]
#2 Zend_Db_Statement->execute(array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]
#3 Zend_Db_Adapter_Abstract->query('SELECT 1 AS `sta...', array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#4 Zend_Db_Adapter_Pdo_Abstract->query('SELECT 1 AS `sta...', array()) called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:542]
#5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT 1 AS `sta...', array()) called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:617]
#6 Magento\Framework\DB\Adapter\Pdo\Mysql->query(&Magento\Framework\DB\Select#00000000441b28ba000000000c53371e#, array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737]
#7 Zend_Db_Adapter_Abstract->fetchAll(&Magento\Framework\DB\Select#00000000441b28ba000000000c53371e#, array()) called at [vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php:21]
#8 Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll(&Magento\Framework\DB\Select#00000000441b28ba000000000c53371e#, array()) called at [vendor/magento/framework/Data/Collection/AbstractDb.php:778]
#9 Magento\Framework\Data\Collection\AbstractDb->_fetchAll(&Magento\Framework\DB\Select#00000000441b28ba000000000c53371e#) called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:1126]
#10 Magento\Eav\Model\Entity\Collection\AbstractCollection->_loadEntities(false, false) called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1129]
#11 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->_loadEntities(false, false) called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:924]
#12 Magento\Eav\Model\Entity\Collection\AbstractCollection->load(false, false) called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:799]
#13 Magento\Catalog\Model\ResourceModel\Product\Collection->load(false, false) called at [vendor/magento/framework/Interception/Interceptor.php:58]
#14 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callParent('load', array(false, false)) called at [vendor/magento/framework/Interception/Interceptor.php:138]
#15 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#16 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callPlugins('load', array(), array(array('add_stock_inform...'))) called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:195]
#17 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->load() called at [vendor/magento/framework/Data/Collection.php:835]
#18 Magento\Framework\Data\Collection->getIterator() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1779]
#19 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getIterator() called at [vendor/magento/module-catalog/Block/Rss/Product/Special.php:130]
#20 Magento\Catalog\Block\Rss\Product\Special->getRssData() called at [vendor/magento/module-rss/Model/Rss.php:78]
#21 Magento\Rss\Model\Rss->getFeeds() called at [vendor/magento/module-rss/Model/Rss.php:109]
#22 Magento\Rss\Model\Rss->createRssXml() called at [vendor/magento/module-rss/Controller/Feed/Index.php:49]
#23 Magento\Rss\Controller\Feed\Index->execute() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#24 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent('execute', array()) called at [vendor/magento/framework/Interception/Interceptor.php:138]
#25 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#26 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins('execute', array(), array(array('pluginAfterActio...'))) called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:26]
#27 Magento\Rss\Controller\Feed\Index\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:108]
#28 Magento\Framework\App\Action\Action->dispatch(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:58]
#29 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent('dispatch', array(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#)) called at [vendor/magento/framework/Interception/Interceptor.php:138]
#30 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:153]
#31 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins('dispatch', array(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#), array(array('designLoader', 'customerNotifica...', 'catalog_app_acti...', 'tax-app-action-d...', 'weee-app-action-...', 'storeCheck', 'contextPlugin', 'customer-app-act...'))) called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:39]
#32 Magento\Rss\Controller\Feed\Index\Interceptor->dispatch(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/App/FrontController.php:159]
#33 Magento\Framework\App\FrontController->processRequest(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#, &Magento\Rss\Controller\Feed\Index\Interceptor#00000000441b2fc3000000000c53371e#) called at [vendor/magento/framework/App/FrontController.php:99]
#34 Magento\Framework\App\FrontController->dispatch(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:58]
#35 Magento\Framework\App\FrontController\Interceptor->___callParent('dispatch', array(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#)) called at [vendor/magento/framework/Interception/Interceptor.php:138]
#36 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:94]
#37 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch(&Magento\Framework\App\FrontController\Interceptor#00000000441b2d88000000000c53371e#, &Closure#00000000441b2d46000000000c53371e#, &Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:135]
#38 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:73]
#39 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch(&Magento\Framework\App\FrontController\Interceptor#00000000441b2d88000000000c53371e#, &Closure#00000000441b2d46000000000c53371e#, &Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:135]
#40 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/swissup/module-amp/Plugin/Framework/FrontController.php:48]
#41 Swissup\Amp\Plugin\Framework\FrontController->aroundDispatch(&Magento\Framework\App\FrontController\Interceptor#00000000441b2d88000000000c53371e#, &Closure#00000000441b2d46000000000c53371e#, &Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:135]
#42 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:153]
#43 Magento\Framework\App\FrontController\Interceptor->___callPlugins('dispatch', array(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#), NULL) called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:26]
#44 Magento\Framework\App\FrontController\Interceptor->dispatch(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/App/Http.php:136]
#45 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:24]
#46 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:258]
#47 Magento\Framework\App\Bootstrap->run(&Magento\Framework\App\Http\Interceptor#00000000441b2c0d000000000c53371e#) called at [index.php:39]
Exception #1 (PDOException): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'price' in where clause is ambiguous
#1 Zend_Db_Statement_Pdo->_execute(array()) called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:93]
#2 Magento\Framework\DB\Statement\Pdo\Mysql->_execute(array()) called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303]
#3 Zend_Db_Statement->execute(array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]
#4 Zend_Db_Adapter_Abstract->query('SELECT 1 AS `sta...', array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#5 Zend_Db_Adapter_Pdo_Abstract->query('SELECT 1 AS `sta...', array()) called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:542]
#6 Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT 1 AS `sta...', array()) called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:617]
#7 Magento\Framework\DB\Adapter\Pdo\Mysql->query(&Magento\Framework\DB\Select#00000000441b28ba000000000c53371e#, array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737]
#8 Zend_Db_Adapter_Abstract->fetchAll(&Magento\Framework\DB\Select#00000000441b28ba000000000c53371e#, array()) called at [vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php:21]
#9 Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll(&Magento\Framework\DB\Select#00000000441b28ba000000000c53371e#, array()) called at [vendor/magento/framework/Data/Collection/AbstractDb.php:778]
#10 Magento\Framework\Data\Collection\AbstractDb->_fetchAll(&Magento\Framework\DB\Select#00000000441b28ba000000000c53371e#) called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:1126]
#11 Magento\Eav\Model\Entity\Collection\AbstractCollection->_loadEntities(false, false) called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1129]
#12 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->_loadEntities(false, false) called at [vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php:924]
#13 Magento\Eav\Model\Entity\Collection\AbstractCollection->load(false, false) called at [vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php:799]
#14 Magento\Catalog\Model\ResourceModel\Product\Collection->load(false, false) called at [vendor/magento/framework/Interception/Interceptor.php:58]
#15 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callParent('load', array(false, false)) called at [vendor/magento/framework/Interception/Interceptor.php:138]
#16 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#17 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callPlugins('load', array(), array(array('add_stock_inform...'))) called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:195]
#18 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->load() called at [vendor/magento/framework/Data/Collection.php:835]
#19 Magento\Framework\Data\Collection->getIterator() called at [generated/code/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php:1779]
#20 Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getIterator() called at [vendor/magento/module-catalog/Block/Rss/Product/Special.php:130]
#21 Magento\Catalog\Block\Rss\Product\Special->getRssData() called at [vendor/magento/module-rss/Model/Rss.php:78]
#22 Magento\Rss\Model\Rss->getFeeds() called at [vendor/magento/module-rss/Model/Rss.php:109]
#23 Magento\Rss\Model\Rss->createRssXml() called at [vendor/magento/module-rss/Controller/Feed/Index.php:49]
#24 Magento\Rss\Controller\Feed\Index->execute() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#25 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent('execute', array()) called at [vendor/magento/framework/Interception/Interceptor.php:138]
#26 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#27 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins('execute', array(), array(array('pluginAfterActio...'))) called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:26]
#28 Magento\Rss\Controller\Feed\Index\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:108]
#29 Magento\Framework\App\Action\Action->dispatch(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:58]
#30 Magento\Rss\Controller\Feed\Index\Interceptor->___callParent('dispatch', array(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#)) called at [vendor/magento/framework/Interception/Interceptor.php:138]
#31 Magento\Rss\Controller\Feed\Index\Interceptor->Magento\Framework\Interception\{closure}(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:153]
#32 Magento\Rss\Controller\Feed\Index\Interceptor->___callPlugins('dispatch', array(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#), array(array('designLoader', 'customerNotifica...', 'catalog_app_acti...', 'tax-app-action-d...', 'weee-app-action-...', 'storeCheck', 'contextPlugin', 'customer-app-act...'))) called at [generated/code/Magento/Rss/Controller/Feed/Index/Interceptor.php:39]
#33 Magento\Rss\Controller\Feed\Index\Interceptor->dispatch(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/App/FrontController.php:159]
#34 Magento\Framework\App\FrontController->processRequest(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#, &Magento\Rss\Controller\Feed\Index\Interceptor#00000000441b2fc3000000000c53371e#) called at [vendor/magento/framework/App/FrontController.php:99]
#35 Magento\Framework\App\FrontController->dispatch(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:58]
#36 Magento\Framework\App\FrontController\Interceptor->___callParent('dispatch', array(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#)) called at [vendor/magento/framework/Interception/Interceptor.php:138]
#37 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:94]
#38 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch(&Magento\Framework\App\FrontController\Interceptor#00000000441b2d88000000000c53371e#, &Closure#00000000441b2d46000000000c53371e#, &Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:135]
#39 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:73]
#40 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch(&Magento\Framework\App\FrontController\Interceptor#00000000441b2d88000000000c53371e#, &Closure#00000000441b2d46000000000c53371e#, &Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:135]
#41 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/swissup/module-amp/Plugin/Framework/FrontController.php:48]
#42 Swissup\Amp\Plugin\Framework\FrontController->aroundDispatch(&Magento\Framework\App\FrontController\Interceptor#00000000441b2d88000000000c53371e#, &Closure#00000000441b2d46000000000c53371e#, &Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:135]
#43 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/Interception/Interceptor.php:153]
#44 Magento\Framework\App\FrontController\Interceptor->___callPlugins('dispatch', array(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#), NULL) called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:26]
#45 Magento\Framework\App\FrontController\Interceptor->dispatch(&Magento\Framework\App\Request\Http#00000000441b2c4e000000000c53371e#) called at [vendor/magento/framework/App/Http.php:136]
#46 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:24]
#47 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:258]
#48 Magento\Framework\App\Bootstrap->run(&Magento\Framework\App\Http\Interceptor#00000000441b2c0d000000000c53371e#) called at [index.php:39]