{"0":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\" ) GROUP BY `e`.`entity_id` ORDER BY `price_index`.`min_price` asc, `cat_index' at line 8, query was: SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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`, `rating`.`percent`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e`\n INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=48\n INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'\n LEFT JOIN `rating_option_vote_aggregated` AS `rating` ON e.entity_id =rating.entity_pk_value\n LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))\n LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id\n LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id`\n INNER JOIN `search_tmp_68bd555fec5e62_87686134` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (rating.store_id = '1') AND ( rating.percent BETWEEN 21 AND 40'\" ) GROUP BY `e`.`entity_id` ORDER BY `price_index`.`min_price` asc, `cat_index`.`position` ASC, `e`.`entity_id` DESC, `e`.`entity_id` ASC\n LIMIT 12","1":"#1 Magento\\Framework\\DB\\Statement\\Pdo\\Mysql->_execute() called at [vendor\/magento\/zend-db\/library\/Zend\/Db\/Statement.php:313]\n#2 Zend_Db_Statement->execute() called at [vendor\/magento\/zend-db\/library\/Zend\/Db\/Adapter\/Abstract.php:480]\n#3 Zend_Db_Adapter_Abstract->query() called at [vendor\/magento\/zend-db\/library\/Zend\/Db\/Adapter\/Pdo\/Abstract.php:242]\n#4 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:641]\n#5 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->Magento\\Framework\\DB\\Adapter\\Pdo\\{closure}() called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:667]\n#6 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->performQuery() called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:641]\n#7 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->_query() called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:731]\n#8 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->query() called at [vendor\/magento\/zend-db\/library\/Zend\/Db\/Adapter\/Abstract.php:737]\n#9 Zend_Db_Adapter_Abstract->fetchAll() called at [vendor\/magento\/framework\/Data\/Collection\/Db\/FetchStrategy\/Query.php:21]\n#10 Magento\\Framework\\Data\\Collection\\Db\\FetchStrategy\\Query->fetchAll() called at [vendor\/magento\/framework\/Data\/Collection\/AbstractDb.php:1036]\n#11 Magento\\Framework\\Data\\Collection\\AbstractDb->_fetchAll() called at [vendor\/magento\/module-eav\/Model\/Entity\/Collection\/AbstractCollection.php:1159]\n#12 Magento\\Eav\\Model\\Entity\\Collection\\AbstractCollection->_loadEntities() called at [vendor\/magento\/module-eav\/Model\/Entity\/Collection\/AbstractCollection.php:955]\n#13 Magento\\Eav\\Model\\Entity\\Collection\\AbstractCollection->load() called at [vendor\/magento\/module-catalog\/Model\/ResourceModel\/Product\/Collection.php:835]\n#14 Magento\\Catalog\\Model\\ResourceModel\\Product\\Collection->load() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#15 WeltPixel\\LayeredNavigation\\Model\\ResourceModel\\Fulltext\\Collection\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#16 WeltPixel\\LayeredNavigation\\Model\\ResourceModel\\Fulltext\\Collection\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#17 WeltPixel\\LayeredNavigation\\Model\\ResourceModel\\Fulltext\\Collection\\Interceptor->___callPlugins() called at [generated\/code\/WeltPixel\/LayeredNavigation\/Model\/ResourceModel\/Fulltext\/Collection\/Interceptor.php:32]\n#18 WeltPixel\\LayeredNavigation\\Model\\ResourceModel\\Fulltext\\Collection\\Interceptor->load() called at [vendor\/magento\/module-catalog\/Block\/Product\/ListProduct.php:211]\n#19 Magento\\Catalog\\Block\\Product\\ListProduct->_beforeToHtml() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:1127]\n#20 Magento\\Framework\\View\\Element\\AbstractBlock->Magento\\Framework\\View\\Element\\{closure}() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:1132]\n#21 Magento\\Framework\\View\\Element\\AbstractBlock->_loadCache() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:676]\n#22 Magento\\Framework\\View\\Element\\AbstractBlock->toHtml() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#23 WeltPixel\\AjaxInfiniteScroll\\Block\\Product\\ListProduct\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#24 WeltPixel\\AjaxInfiniteScroll\\Block\\Product\\ListProduct\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#25 WeltPixel\\AjaxInfiniteScroll\\Block\\Product\\ListProduct\\Interceptor->___callPlugins() called at [generated\/code\/WeltPixel\/AjaxInfiniteScroll\/Block\/Product\/ListProduct\/Interceptor.php:59]\n#26 WeltPixel\\AjaxInfiniteScroll\\Block\\Product\\ListProduct\\Interceptor->toHtml() called at [app\/code\/WeltPixel\/LayeredNavigation\/Plugin\/Category\/View.php:89]\n#27 WeltPixel\\LayeredNavigation\\Plugin\\Category\\View->afterExecute() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:146]\n#28 Magento\\Catalog\\Controller\\Category\\View\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#29 Magento\\Catalog\\Controller\\Category\\View\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Catalog\/Controller\/Category\/View\/Interceptor.php:23]\n#30 Magento\\Catalog\\Controller\\Category\\View\\Interceptor->execute() called at [vendor\/magento\/framework\/App\/Action\/Action.php:111]\n#31 Magento\\Framework\\App\\Action\\Action->dispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#32 Magento\\Catalog\\Controller\\Category\\View\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#33 Magento\\Catalog\\Controller\\Category\\View\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [app\/code\/Anowave\/Ec\/Plugin\/App\/Action\/Context.php:148]\n#34 Anowave\\Ec\\Plugin\\App\\Action\\Context->aroundDispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#35 Magento\\Catalog\\Controller\\Category\\View\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#36 Magento\\Catalog\\Controller\\Category\\View\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Catalog\/Controller\/Category\/View\/Interceptor.php:32]\n#37 Magento\\Catalog\\Controller\\Category\\View\\Interceptor->dispatch() called at [vendor\/magento\/framework\/App\/FrontController.php:245]\n#38 Magento\\Framework\\App\\FrontController->getActionResponse() called at [vendor\/magento\/framework\/App\/FrontController.php:212]\n#39 Magento\\Framework\\App\\FrontController->processRequest() called at [vendor\/magento\/framework\/App\/FrontController.php:146]\n#40 Magento\\Framework\\App\\FrontController->dispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#41 Magento\\Framework\\App\\FrontController\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#42 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/module-store\/App\/FrontController\/Plugin\/RequestPreprocessor.php:99]\n#43 Magento\\Store\\App\\FrontController\\Plugin\\RequestPreprocessor->aroundDispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#44 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/module-page-cache\/Model\/App\/FrontController\/BuiltinPlugin.php:72]\n#45 Magento\\PageCache\\Model\\App\\FrontController\\BuiltinPlugin->aroundDispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#46 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#47 Magento\\Framework\\App\\FrontController\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Framework\/App\/FrontController\/Interceptor.php:23]\n#48 Magento\\Framework\\App\\FrontController\\Interceptor->dispatch() called at [vendor\/magento\/framework\/App\/Http.php:116]\n#49 Magento\\Framework\\App\\Http->launch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#50 Magento\\Framework\\App\\Http\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#51 Magento\\Framework\\App\\Http\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/module-application-performance-monitor\/Plugin\/ApplicationPerformanceMonitor.php:38]\n#52 Magento\\ApplicationPerformanceMonitor\\Plugin\\ApplicationPerformanceMonitor->aroundLaunch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#53 Magento\\Framework\\App\\Http\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#54 Magento\\Framework\\App\\Http\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Framework\/App\/Http\/Interceptor.php:23]\n#55 Magento\\Framework\\App\\Http\\Interceptor->launch() called at [vendor\/magento\/framework\/App\/Bootstrap.php:264]\n#56 Magento\\Framework\\App\\Bootstrap->run() called at [pub\/index.php:30]\n","url":"\/catalog\/category\/view\/s\/feather-flags\/id\/48\/?ajax=1&product_list_limit=12&rat=21-40'\"","script_name":"\/pub\/index.php","report_id":"1adc9cd956aa6c01df4fb456ab477764cf9d78f945c3f30aca72618a95e90461"}