Datenbank Problem

[Tr3bi84]

Hallo,

ich habe Probleme mit der Datenbank.

Meine Php-Version: PHP Version 5.2.1

Die aktuell laufende MySQL Version ist: 4.1.15-Debian_0.dotdeb.1-log

PHP-Info: http://www.trebi.de/phpinfo.php

Fehlermeldung:

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 p.products_id, p.products_image, pd.products_name, pd.products_short_description, pd.products_description, p2c.categories_id from kz_products p left join kz_products_description pd on p.products_id = pd.products_id, kz_products_to_categories p2c left join kz_products_to_stores p2s on p2c.products_id = p2s.products_id where p.products_id = p2c.products_id and p.products_status = '1' and pd.language_id = '2' and p2c.categories_id in (686,670,679) and p2s.stores_id = 12 order by pd.products_viewed DESC, pd.products_name limit 3

[XT SQL Error]

Über Hilfe wäre ich sehr dankbar!

Liebe Grüße

Tr3bi84