jfmontanaro
commented
1 year ago (Breaking this into a separate comment because Github didn't like the formatting)
Formatted, that query looks like this:
INSERT INTO `search_tmp_636d2a67d93412_19743921` (`entity_id`, `score`)
SELECT `main_select`.`entity_id`, SUM(score) AS `relevance`
FROM (
SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0) + (0)) * 1) AS `score`
FROM
`catalog_product_index_eav` AS `search_index`
INNER JOIN `cataloginventory_stock_status` AS `stock_index`
ON stock_index.product_id = search_index.entity_id
AND `stock_index`.`website_id` = 0
AND `stock_index`.`stock_id` = 1
INNER JOIN `catalog_category_product_index_store1` AS `category_ids_index`
ON search_index.entity_id = category_ids_index.product_id
AND category_ids_index.store_id = '1'
WHERE
(search_index.store_id = '1')
AND (
`search_index`.`attribute_id` = 99
AND `search_index`.`value` in ('2', '4')
AND `search_index`.`store_id` = '1'
)
AND (category_ids_index.category_id in ('10'))
AND (`_id_filter`.`_id` NOT IN ('182', '183', '184'))
) AS `main_select`
GROUP BY `entity_id`
ORDER BY
`relevance` DESC,
`entity_id` DESC
LIMIT 10000What's weird to me is that I can't quite figure out what _id_filter.id is referring to. Maybe I'm just misunderstanding the query, but shouldn't that refer to a table or table alias that's referenced somewhere else in the query?
roma84
Hi,
I'm getting the following error after installing this extension in Magento 2.4.5-p1 when I try to hit a category or search results page:
Full stack trace: