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;
Share on Google+Share on FacebookTweet about this on TwitterEmail this to someone