/* ajanlat_detail_47_427470 */
	SELECT a.*, b.iroda_id AS iid, b.orszag_id, c.orszag_nev, c.orszag_leiras, b.regio_id, d.regio_nev, d.regio_leiras, d.idojaras AS regio_idojaras, e.varos_nev, e.varos_leiras, e.idojaras AS varos_idojaras, e.gmap_coords
	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 = '427470' AND
	a.ajanlat_id = b.ajanlat_id AND
	b.iroda_id = o.iroda_id AND
	(a.ajanlat_megosztas = 1 OR b.iroda_id = 47) AND a.ajanlat_status = 1 AND (b.iroda_id NOT IN(509,150,539,259,383,476,329,268,511,546,458))
	GROUP BY a.ajanlat_id
 / MySQL server has gone away