{"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 `search_result`.`score` desc\n LIMIT 12' at line 8, query was: SELECT `e`.*, `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`, `cat_index`.`position` AS `cat_index_position`, `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_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 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(3, 4) AND cat_index.category_id=2\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_68bca0665743e7_91802803` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (rating.store_id = '1') AND ( rating.percent BETWEEN 0 AND 20'\" ) GROUP BY `e`.`entity_id` ORDER BY `search_result`.`score` desc\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\/framework\/Data\/Collection.php:847]\n#19 Magento\\Framework\\Data\\Collection->getIterator() called at [app\/code\/Anowave\/Ec\/Block\/Result.php:118]\n#20 Anowave\\Ec\\Block\\Result->afterGetProductListHtml() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:146]\n#21 Magento\\CatalogSearch\\Block\\Result\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#22 Magento\\CatalogSearch\\Block\\Result\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/CatalogSearch\/Block\/Result\/Interceptor.php:23]\n#23 Magento\\CatalogSearch\\Block\\Result\\Interceptor->getProductListHtml() called at [vendor\/magento\/module-catalog-search\/view\/frontend\/templates\/result.phtml:13]\n#24 include() called at [vendor\/magento\/framework\/View\/TemplateEngine\/Php.php:67]\n#25 Magento\\Framework\\View\\TemplateEngine\\Php->render() called at [vendor\/magento\/framework\/View\/Element\/Template.php:263]\n#26 Magento\\Framework\\View\\Element\\Template->fetchView() called at [vendor\/magento\/framework\/View\/Element\/Template.php:293]\n#27 Magento\\Framework\\View\\Element\\Template->_toHtml() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:1128]\n#28 Magento\\Framework\\View\\Element\\AbstractBlock->Magento\\Framework\\View\\Element\\{closure}() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:1132]\n#29 Magento\\Framework\\View\\Element\\AbstractBlock->_loadCache() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:676]\n#30 Magento\\Framework\\View\\Element\\AbstractBlock->toHtml() called at [app\/code\/WeltPixel\/LayeredNavigation\/Plugin\/CatalogSearch\/ResultView.php:140]\n#31 WeltPixel\\LayeredNavigation\\Plugin\\CatalogSearch\\ResultView->aroundExecute() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#32 Magento\\CatalogSearch\\Controller\\Result\\Index\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#33 Magento\\CatalogSearch\\Controller\\Result\\Index\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/CatalogSearch\/Controller\/Result\/Index\/Interceptor.php:23]\n#34 Magento\\CatalogSearch\\Controller\\Result\\Index\\Interceptor->execute() called at [vendor\/magento\/framework\/App\/Action\/Action.php:111]\n#35 Magento\\Framework\\App\\Action\\Action->dispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#36 Magento\\CatalogSearch\\Controller\\Result\\Index\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#37 Magento\\CatalogSearch\\Controller\\Result\\Index\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [app\/code\/Anowave\/Ec\/Plugin\/App\/Action\/Context.php:148]\n#38 Anowave\\Ec\\Plugin\\App\\Action\\Context->aroundDispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#39 Magento\\CatalogSearch\\Controller\\Result\\Index\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#40 Magento\\CatalogSearch\\Controller\\Result\\Index\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/CatalogSearch\/Controller\/Result\/Index\/Interceptor.php:32]\n#41 Magento\\CatalogSearch\\Controller\\Result\\Index\\Interceptor->dispatch() called at [vendor\/magento\/framework\/App\/FrontController.php:245]\n#42 Magento\\Framework\\App\\FrontController->getActionResponse() called at [vendor\/magento\/framework\/App\/FrontController.php:212]\n#43 Magento\\Framework\\App\\FrontController->processRequest() called at [vendor\/magento\/framework\/App\/FrontController.php:146]\n#44 Magento\\Framework\\App\\FrontController->dispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#45 Magento\\Framework\\App\\FrontController\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#46 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/module-store\/App\/FrontController\/Plugin\/RequestPreprocessor.php:99]\n#47 Magento\\Store\\App\\FrontController\\Plugin\\RequestPreprocessor->aroundDispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#48 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/module-page-cache\/Model\/App\/FrontController\/BuiltinPlugin.php:72]\n#49 Magento\\PageCache\\Model\\App\\FrontController\\BuiltinPlugin->aroundDispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#50 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#51 Magento\\Framework\\App\\FrontController\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Framework\/App\/FrontController\/Interceptor.php:23]\n#52 Magento\\Framework\\App\\FrontController\\Interceptor->dispatch() called at [vendor\/magento\/framework\/App\/Http.php:116]\n#53 Magento\\Framework\\App\\Http->launch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#54 Magento\\Framework\\App\\Http\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#55 Magento\\Framework\\App\\Http\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/module-application-performance-monitor\/Plugin\/ApplicationPerformanceMonitor.php:38]\n#56 Magento\\ApplicationPerformanceMonitor\\Plugin\\ApplicationPerformanceMonitor->aroundLaunch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#57 Magento\\Framework\\App\\Http\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#58 Magento\\Framework\\App\\Http\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Framework\/App\/Http\/Interceptor.php:23]\n#59 Magento\\Framework\\App\\Http\\Interceptor->launch() called at [vendor\/magento\/framework\/App\/Bootstrap.php:264]\n#60 Magento\\Framework\\App\\Bootstrap->run() called at [pub\/index.php:30]\n","url":"\/catalogsearch\/result\/index\/?ajax=1&q=the&rat=0-20'\"","script_name":"\/pub\/index.php","report_id":"e6aac11f03ce27faca9f03db3a929d1ad982b1b8f64de926678f96b4f6b02547"}