SELECT a.regio_id, a.regio_nev 
	FROM regio a, arajanlat b 
	WHERE 
	(b.orszag_id = '80') AND 
	(a.regio_id = b.regio_id) 
 AND (((b.iroda_id = '148')) OR ((b.iroda_id = '143')) AND ((b.orszag_id = '10')) OR ((b.iroda_id = '15')) AND ((b.orszag_id = '81')) OR ((b.iroda_id = '15')) AND ((b.orszag_id = '10')) OR ((b.iroda_id = '15')) AND ((b.orszag_id = '112')) OR ((b.iroda_id = '15')) AND ((b.orszag_id = '84')) OR  OR ((b.iroda_id = '15')) AND ((b.orszag_id = '6')) OR ((b.iroda_id = '15')) AND ((b.orszag_id = '13')) OR ((b.iroda_id = '15')) AND ((b.orszag_id = '86')) OR ((b.iroda_id = '15')) AND ((b.orszag_id = '15')) OR ((b.iroda_id = '9')) AND ((b.orszag_id = '9')) OR ((b.iroda_id = '9')) AND ((b.orszag_id = '11')) OR ((b.iroda_id = '9')) AND ((b.orszag_id = '75')) OR ((b.iroda_id = '81')) AND ((b.orszag_id = '186')) OR ((b.iroda_id = '31')) OR ((b.iroda_id = '202')) AND ((b.orszag_id = '10')) OR ((b.iroda_id = '202')) AND ((b.orszag_id = '7')) OR ((b.iroda_id = '171')) AND ((b.orszag_id = '15')) OR ((b.iroda_id = '171')) AND ((b.orszag_id = '10')) OR ((b.iroda_id = '233')) AND ((b.orszag_id = '10')) OR ((b.iroda_id = '67')) AND ((b.orszag_id = '186')) OR ((b.iroda_id = '22')) OR ((b.iroda_id = '38')) OR ((b.iroda_id = '48')) AND ((b.orszag_id = '10')) OR ((b.iroda_id = '224')) AND ((b.orszag_id = '8')) OR (b.iroda_id = '118'))GROUP BY a.regio_id ORDER BY a.regio_nev / You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR ((b.iroda_id = '15')) AND ((b.orszag_id = '6')) OR ((b.iroda_id = '15')) AND ' at line 6