Execute following query before your big select query...
SET OPTION SQL_BIG_SELECTS = 1; or SET SQL_BIG_SELECTS = 1;
Was this article helpful?
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;