SELECT a.*, c.orszag_nev, d.regio_nev, e.varos_nev
	FROM ajanlat a, arajanlat b
	LEFT JOIN orszag c ON (b.orszag_id = c.orszag_id)
	LEFT JOIN regio d ON (b.regio_id = d.regio_id)
	LEFT JOIN varos e ON (b.varos_id = e.varos_id), irodak o
	WHERE
	a.ajanlat_id = b.ajanlat_id AND
	b.iroda_id = o.iroda_id  AND
	a.ajanlat_id = '468283' AND
	a.ajanlat_status = 1 AND
	(a.ajanlat_megosztas = 1 OR b.iroda_id = '522')  AND (b.iroda_id NOT IN(333,53,200))
	GROUP BY a.ajanlat_id
 / Server shutdown in progress