The SELECT would examine more than MAX_JOIN_SIZE rows
 

Hey everybody,
I get every hour this error mail:
Quote:
Invalid SQL:

SELECT pmtext.pmtextid
FROM pmtext AS pmtext
LEFT JOIN pm AS pm USING(pmtextid)
WHERE pm.pmid IS NULL;

MySQL-Fehler : 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
Fehler-Nr. : 1104
Fehler-Zeit : Monday, 21.07.2009 @ 12:21:32
The size of max_join_size on the server:
Quote:
max_join_size 201326592
It is a hosted package and I cannot increase the size.

Are there any alternatives? What can I do?

Thanks for your help. :)