|
|
MySQL said: '1104: 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'
SELECT DISTINCT (c.CountryNameS) , tc.CountryName from country c,translatecountry tc, t_tours as t where tc.language='en' and c.CountryNameS=tc.CountryNameS and t.CountryNameS=c.CountryNameS order by tc.CountryName | |
