INVALID SQL: 1104 : 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
SQL QUERY FAILURE:SELECT DISTINCT EFV.fieldid FROM xcart_extra_field_values AS EFV LEFT JOIN xcart_extra_fields AS EF ON EF.fieldid = EFV.fieldid LEFT JOIN xcart_products_categories AS PC ON PC.productid = EFV.productid INNER JOIN xcart_products AS P ON P.productid = PC.productid AND P.forsale = 'Y' LEFT JOIN xcart_categories AS C ON C.categoryid = PC.categoryid WHERE EF.active = 'Y' AND EFV.value <> '' AND C.lpos BETWEEN 1837 AND 1842
Comnet Cables

Comnet Cables

Cables

Connect with us

Join our community! Stay on top of all the latest technology, industry events, and consumer electronics content from around the web.

Sales & expert advice 1.888.660.2962

Live chat