Fatal error: Uncaught exception 'Exception' with message '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 value_id, option_id, total FROM (SELECT p.manufacturer_id AS value_id, 'm' AS option_id, COUNT(p.manufacturer_id) AS total FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p2c.category_id = '20' AND p.product_id IN(SELECT oov2p1.product_id FROM oc_ocfilter_option_value_to_product oov2p1 INNER JOIN oc_ocfilter_option_value_to_product oov2p2 ON (oov2p1.product_id = oov2p2.product_id) INNER JOIN oc_ocfilter_option_value_to_product oov2p3 ON (oov2p1.product_id = oov2p3.product_id) WHERE oov2p1.option_id = '13' AND (oov2p1.value_id = '58') AND oov2p2.option_id = '30012' AND (oov2p2.value_id = '3179762159') AND oov2p3.option_id = '30016' AND (oov2p3.value_id = '1390500665')) GROUP BY p.manufacturer_id UNION ALL SELECT p.sto in /var/www/rvs/data/www/1jeans.ru/system/library/db/mysqli.php on line 45