Execute big select query in mysql

Execute following query before your big select query...

SET OPTION SQL_BIG_SELECTS = 1;
or
SET SQL_BIG_SELECTS = 1;