Fatal error: Uncaught Exception: Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT oov2p.value_id, oov2p.option_id, COUNT(DISTINCT p.product_id) AS total FROM oc_ocfilter_option_value_to_product oov2p LEFT JOIN oc_product_to_category p2c ON (oov2p.product_id = p2c.product_id) LEFT JOIN oc_product p ON (oov2p.product_id = p.product_id) WHERE p.status = '1' AND oov2p.value_id > '0' AND p2c.category_id = '107' GROUP BY oov2p.option_id, oov2p.value_id in /home/users/g/glavelka/domains/storage/modification/system/library/db/mysqli.php:44
Stack trace:
#0 /home/users/g/glavelka/domains/newbu.ru/system/library/db.php(45): DB\MySQLi->query('SELECT oov2p.va...')
#1 /home/users/g/glavelka/domains/newbu.ru/catalog/model/extension/module/ocfilter.php(598): DB->query('SELECT oov2p.va...')
#2 /home/users/g/glavelka/domains/storage/modification/system/engine/loader.php(251): ModelExtensionModuleOCFilter- in /home/users/g/glavelka/domains/storage/modification/system/library/db/mysqli.php on line 44