/* ajanlat_detail_126_468355 */
	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 = '468355' AND
	a.ajanlat_id = b.ajanlat_id AND
	b.iroda_id = o.iroda_id AND
	(a.ajanlat_megosztas = 1 OR b.iroda_id = 126) AND a.ajanlat_status = 1 AND (b.iroda_id NOT IN(475,279,248,28,400,32,285,539,31,259,383,336,274,501,476,333,407,534,280,229,391,329,548,486,516,542,268,471,453,224,469,138,513,305,531,512,495,244,222,546))
	GROUP BY a.ajanlat_id
 / Server shutdown in progress