On 14 May, 14:36, "Schemer" <nowh...@man.com> wrote:
> Hello,
> A query that worked yesterday (against the mySQL db behind my web site)
> fails today with this error:
> "Can\'t use players: 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"
>
> How can I fix this? What would be the best way to simplify this query?
> Thanks for any suggestions.
Errm, why are you asking us when you just posted the answer?