SELECT t.id, t.image_address, t.kod, t.keszlet, nl.name, nl.description, a.ar, t.egyseg, t.gyarto, t.allapot, t.uj FROM myshop_termek_to_kategoria as ttk INNER JOIN myshop_termek as t ON ttk.termek_id=t.id INNER JOIN myshop_nev_leiras as nl ON nl.termek_id = t.id INNER JOIN myshop_arak as a ON t.id = a.termek_id WHERE nl.language_id= 4 AND (ttk.termek_kategoria_id = 139 OR ttk.termek_kategoria_id = 140 OR ttk.termek_kategoria_id = 141 OR ttk.termek_kategoria_id = 146) AND status='igen' AND a.arforma_id = 1 GROUP BY t.id ORDER BY nl.name DESC LIMIT 0, 10
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
Fájl: /include/center/termekek.php sor: 141