Yes.Sure. That error comes from heidi sql, mysql query browser just gives me "can't execute query" as I said.
If it tells you something more ... if I go with limit 30000 in mysql query browser then it does it OK, but limit 40000 or no limit dies.
EDIT: mysqlcheck did not make any difference
EDIT1: if I change from left join to join, or change indexes, same thing, just on different record.
Last edited by BubikolRamios; 02-02-2011 at 09:11 PM..