{"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=81\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_68dbda18d24fb1_57890631` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (rating.store_id = '1') AND ( rating.percent BETWEEN 81 AND 100' ) 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\/framework\/Data\/Collection.php:859]\n#19 Magento\\Framework\\Data\\Collection->count() called at [app\/code\/WeltPixel\/GA4\/view\/frontend\/templates\/category.phtml:10]\n#20 include() called at [vendor\/magento\/framework\/View\/TemplateEngine\/Php.php:67]\n#21 Magento\\Framework\\View\\TemplateEngine\\Php->render() called at [vendor\/magento\/framework\/View\/Element\/Template.php:263]\n#22 Magento\\Framework\\View\\Element\\Template->fetchView() called at [vendor\/magento\/framework\/View\/Element\/Template.php:293]\n#23 Magento\\Framework\\View\\Element\\Template->_toHtml() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:1128]\n#24 Magento\\Framework\\View\\Element\\AbstractBlock->Magento\\Framework\\View\\Element\\{closure}() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:1132]\n#25 Magento\\Framework\\View\\Element\\AbstractBlock->_loadCache() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:676]\n#26 Magento\\Framework\\View\\Element\\AbstractBlock->toHtml() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#27 WeltPixel\\GA4\\Block\\Category\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#28 WeltPixel\\GA4\\Block\\Category\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#29 WeltPixel\\GA4\\Block\\Category\\Interceptor->___callPlugins() called at [generated\/code\/WeltPixel\/GA4\/Block\/Category\/Interceptor.php:23]\n#30 WeltPixel\\GA4\\Block\\Category\\Interceptor->toHtml() called at [app\/code\/WeltPixel\/GA4\/Helper\/Data.php:604]\n#31 WeltPixel\\GA4\\Helper\\Data->addCategoryPageInformation() called at [app\/code\/WeltPixel\/GA4\/Helper\/Data.php:490]\n#32 WeltPixel\\GA4\\Helper\\Data->getDataLayerScript() called at [app\/code\/WeltPixel\/GA4\/Observer\/CoreLayoutRenderElementObserver.php:40]\n#33 WeltPixel\\GA4\\Observer\\CoreLayoutRenderElementObserver->execute() called at [vendor\/magento\/framework\/Event\/Invoker\/InvokerDefault.php:88]\n#34 Magento\\Framework\\Event\\Invoker\\InvokerDefault->_callObserverMethod() called at [vendor\/magento\/framework\/Event\/Invoker\/InvokerDefault.php:74]\n#35 Magento\\Framework\\Event\\Invoker\\InvokerDefault->dispatch() called at [vendor\/magento\/framework\/Event\/Manager.php:65]\n#36 Magento\\Framework\\Event\\Manager->dispatch() called at [generated\/code\/Magento\/Framework\/Event\/Manager\/Proxy.php:105]\n#37 Magento\\Framework\\Event\\Manager\\Proxy->dispatch() called at [vendor\/magento\/framework\/View\/Layout.php:516]\n#38 Magento\\Framework\\View\\Layout->renderElement() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:527]\n#39 Magento\\Framework\\View\\Element\\AbstractBlock->getChildHtml() called at [vendor\/magento\/module-theme\/view\/frontend\/templates\/html\/container.phtml:7]\n#40 include() called at [vendor\/magento\/framework\/View\/TemplateEngine\/Php.php:67]\n#41 Magento\\Framework\\View\\TemplateEngine\\Php->render() called at [vendor\/magento\/framework\/View\/Element\/Template.php:263]\n#42 Magento\\Framework\\View\\Element\\Template->fetchView() called at [vendor\/magento\/framework\/View\/Element\/Template.php:293]\n#43 Magento\\Framework\\View\\Element\\Template->_toHtml() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:1128]\n#44 Magento\\Framework\\View\\Element\\AbstractBlock->Magento\\Framework\\View\\Element\\{closure}() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:1132]\n#45 Magento\\Framework\\View\\Element\\AbstractBlock->_loadCache() called at [vendor\/magento\/framework\/View\/Element\/AbstractBlock.php:676]\n#46 Magento\\Framework\\View\\Element\\AbstractBlock->toHtml() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#47 Magento\\Framework\\View\\Element\\Template\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#48 Magento\\Framework\\View\\Element\\Template\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#49 Magento\\Framework\\View\\Element\\Template\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Framework\/View\/Element\/Template\/Interceptor.php:23]\n#50 Magento\\Framework\\View\\Element\\Template\\Interceptor->toHtml() called at [vendor\/magento\/framework\/View\/Result\/Page.php:277]\n#51 Magento\\Framework\\View\\Result\\Page->render() called at [vendor\/magento\/framework\/View\/Result\/Layout.php:171]\n#52 Magento\\Framework\\View\\Result\\Layout->renderResult() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#53 Magento\\Framework\\View\\Result\\Page\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#54 Magento\\Framework\\View\\Result\\Page\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#55 Magento\\Framework\\View\\Result\\Page\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Framework\/View\/Result\/Page\/Interceptor.php:41]\n#56 Magento\\Framework\\View\\Result\\Page\\Interceptor->renderResult() called at [vendor\/magento\/framework\/App\/Http.php:120]\n#57 Magento\\Framework\\App\\Http->launch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#58 Magento\\Framework\\App\\Http\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#59 Magento\\Framework\\App\\Http\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/module-application-performance-monitor\/Plugin\/ApplicationPerformanceMonitor.php:38]\n#60 Magento\\ApplicationPerformanceMonitor\\Plugin\\ApplicationPerformanceMonitor->aroundLaunch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#61 Magento\\Framework\\App\\Http\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#62 Magento\\Framework\\App\\Http\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Framework\/App\/Http\/Interceptor.php:23]\n#63 Magento\\Framework\\App\\Http\\Interceptor->launch() called at [vendor\/magento\/framework\/App\/Bootstrap.php:264]\n#64 Magento\\Framework\\App\\Bootstrap->run() called at [pub\/index.php:30]\n","url":"\/display-stands\/custom-gazebos?color=49%22%3D%2249%22%20OR%20UPDATEXML%281816%2CCONCAT%280x2e%2C0x71786a7871%2C%28SELECT%20%28ELT%281816%3D1816%2C1%29%29%29%2C0x7178717a71%29%2C5573%29%20AND%20%2249%22%3D%2249&rat=81-100%27","script_name":"\/pub\/index.php","report_id":"fdb764dc7df9aa54fda68533a9219cbbcec42257548be40fa4ee41e1a32903e8"}