/* ajanlat_detail_388_278365 */
	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 = '278365' AND
	a.ajanlat_id = b.ajanlat_id AND
	b.iroda_id = o.iroda_id AND
	(a.ajanlat_megosztas = 1 OR b.iroda_id = 388 OR b.iroda_id = 526) AND a.ajanlat_status = 1 AND (b.iroda_id NOT IN(279,248,317,539,336,274,333,521,230,471,469,138,458,531))
	GROUP BY a.ajanlat_id
 / MySQL server has gone away