SQL: SELECT si.itemid, si.type, si.uid, si.dateline, si.subject, si.username, sn.message FROM [Table]spaceitems si LEFT JOIN [Table]spacenews sn ON sn.itemid = si.itemid WHERE si.type IN ('news') AND si.itemid > 0 ORDER BY itemid limit 500
Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Errno.: 1104