My script states that the MAX_JOIN_SIZE setting in MySQL set to low. How do I increase it? Print

MySQL will refuse to execute select statements that process a very large number of rows. You should either adjust your select statement to make it more efficient, or set SQL_BIG_SELECTS=1 in the session before executing the large select statement. Use something like this to do that .. 

$db->sql_query("SET OPTION SQL_BIG_SELECTS=1");