SELECT, MAX_JOIN_SIZE problem

[Actorial]

I had this php page running fine, and all of a sudden after months of good service, I get this mysql error, maybe you can help?

Error, query failed. 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

Here's the query:

SELECT clubs.country, count(members.club_name) as post_count from clubs left join members on members.club_name=clubs.club_name AND members.club_state=clubs.state AND members.club_country=clubs.country AND members.is_confirmed=1 group by clubs.country order by clubs.country

Any ideas?