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 = 'Y' LEFT JOIN xcart_categories AS C ON C.categoryid = PC.categoryid WHERE = 'Y' AND EFV.value <> '' AND C.lpos BETWEEN 2456 AND 2459
ICRealtime Mounting Solutions

ICRealtime Racks, Enclosures & Cooling Solutions

Racks, Enclosures & Cooling Solutions

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