The real hint here is: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 okayMySQL is trying to tell you that the resulting data set returned by the query is bigger than the maximum that you have set as being allowed. You can try changing your MySQL config (my.cnf) to increase this value, ie You can set SQL_BIG_SELECTS in my.cnf or at server startup.