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 IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),min(t1.rnd),t1.product_id,name,text,t2.attribute_id FROM (SELECT RAND() as rnd,pa2.product_id,pr.price,cpr.price as cprice,count(pa2.attribute_id) as quan FROM oc_product_attribute pa1 INNER JOIN oc_product_attribute pa2 ON (pa1.attribute_id = pa2.attribute_id and pa1.text = pa2.text and pa1.language_id = pa2.language_id) INNER JOIN oc_product pr ON (pa2.product_id = pr.product_id and pr.status = 1) LEFT JOIN oc_product cpr ON (pa1.product_id = cpr.product_id) INNER JOIN oc_product_to_category cat_source on(pa1.product_id = cat_source.product_id) INNER JOIN oc_product_to_category cat on(pa2.product_id = cat.product_id AND cat.category_id = cat_source.category_id) WHERE 0 = 0 AND pa1.language_id = '1' GROUP BY cpr.product_id,pr.pr in /var/www/vanna/data/www/vanna-world.ru/system/library/db/mysqli.php on line 40