[XT SQL Error] 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows

[Elmar57]

Hallo SQL-Spezialisten,

bei der globalen Suche und beim Aufruf mancher Artikel erhalte ich im XTC-Shop folgende Fehlermeldung. Der Shop hat ca. 47.000 Artikel. Wer kann das einem Nicht-SQL-Spezi erklären? Eine ausführliche und schrittweise Erklärung wäre sehr hilfreich. Schon einmal vielen Dank im Voraus!

-----------------------------------------------------------------------

1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

SELECT distinct p.products_id, p.products_price, p.products_model, p.products_quantity, p.products_shippingtime, p.products_fsk18, p.products_image, p.products_weight, p.products_tax_class_id, pd.products_name, pd.products_short_description, pd.products_description FROM products AS p LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) LEFT OUTER JOIN specials AS s ON (p.products_id = s.products_id) AND s.status = '1' WHERE p.products_status = '1' AND pd.language_id = '2' AND ( ( pd.products_keywords LIKE ('%lenovo%') OR pd.products_description LIKE ('%lenovo%') OR pd.products_short_description LIKE ('%lenovo%') OR pd.products_name LIKE ('%lenovo%') OR p.products_model LIKE ('%lenovo%') ) ) GROUP BY p.products_id ORDER BY p.products_id

[XT SQL Error]