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 3236 AND 3239
BZB Express - Solutions to Amplify Your World

NTI Fiber Optic Link Cables

Fiber Optic Link 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