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;