/* atvevoajanlat_551_500838 */
			SELECT
				 /*teljesAr*/
				t.ajanlat_id,
				t.prior,
				t.ajanlat_cim,
				t.ajanlat_alcim,
				t.ajanlat_szallasnev,
				t.hajo_id,
				t.hajotarsasag_id,
				t.tui_kategoria,
				t.tui_marka,
				t.ajanlat_leiras,
				t.ajanlat_lastupdate,
				t.orszag_id,
				t.regio_id,
				t.siregio_id,
				t.varos_id,
				t.iroda_id,
				t.utazasmod_id,
				t.prtipus_id,
				t.ellatas_id,
				t.idopontid,
				t.galeria_id,
				t.ellatas_nev,
				t.szallaskat_nev,
				t.utazasmod_nev,
				a.regi_ar,
				a.akcio_szazalek,
				a.ardecimal,
				a.arak_osszesitett,
				a.eurosar,
				a.megjegyzes,
				IF (a.eurosar = 1, ROUND(IF ((SELECT euroarfolyam FROM irodak WHERE iroda_id = t.iroda_id) > 0, (SELECT euroarfolyam FROM irodak WHERE iroda_id = t.iroda_id), 354.52 /*euroarfolyam*/) * a.ardecimal), a.ardecimal) AS euro_forint_iroda,
				ido.idopont_id,
				IF(ido.idopont_szezonalis = 1 AND ido.idopont_datum1 <= '2026-05-29' /*datumXminusz_std*/, '2026-05-30' /*idopont1nap*/, ido.idopont_datum1) AS idopont_datum1,
				ido.idopont_datum2,
				ido.idopont_ellatas,
				ido.idopont_idotartam,
				ido.idopont_idotartam_nap,
				ido.idopont_szezonalis,
				ido.idopont_elofoglalas,
				ido.idopont_akcios,
				ido.idopont_tipus,
				IF(
					`ido`.`idopont_id` IS NULL,
					1,
					0
				) AS arnelkuli,
				a.elofoglalas_datum11,
				a.elofoglalas_datum12,
				a.elofoglalas_osszeg1,
				a.elofoglalas_tipus1,
				a.elofoglalas_datum21,
				a.elofoglalas_datum22,
				a.elofoglalas_osszeg2,
				a.elofoglalas_tipus2,
				a.elofoglalas_datum31,
				a.elofoglalas_datum32,
				a.elofoglalas_osszeg3,
				a.elofoglalas_tipus3,
				(
					CASE t.iroda_id
					WHEN '551' /*irodaid*/ THEN 1  /*casestr*/
					ELSE 2 /*casekiad*/
					END
				) AS deforderfield
				FROM
					(
						SELECT
							a.ajanlat_id,
							a.prior,
							a.ajanlat_cim,
							a.ajanlat_alcim,
							a.ajanlat_szallasnev,
							h.hajo_id,
							h.hajotarsasag_id,
							a.tui_kategoria,
							a.tui_marka,
							a.ajanlat_leiras,
							a.ajanlat_lastupdate,
							b.orszag_id,
							b.regio_id,
							b.siregio_id,
							b.varos_id,
							b.iroda_id,
							b.utazasmod_id,
							b.prtipus_id,
							b.ellatas_id,
							(
								SELECT
									x.idopont_id
								FROM
									idopont x
									LEFT JOIN arak y ON x.idopont_id = y.idopont_id
								WHERE
									1 = 1
									
		AND x.idopont_status = 1
		AND (
			(x.idopont_szezonalis = 1 AND x.idopont_datum1 <= '2029-06-29'/*datumMinRug*/ AND `x`.`idopont_datum2` >= '2026-05-30'/*datumMinRugPlus*/)
			OR 
			(x.idopont_szezonalis = 0 AND x.idopont_datum1 >= '2026-05-29'  AND x.idopont_datum1 <= '2029-06-29'/*datumXpstr22*/) 
		) 
		AND (
			(x.idopont_arlejar > '0000-00-00' AND x.idopont_arlejar >= '2026-05-30' /*holnap*/)
			OR 
			(x.idopont_arlejar = '0000-00-00')
		) /*datumFeltetel*/
									AND x.ajanlat_id = a.ajanlat_id
									 /*idopontSzobaSzuro*/
									 /*lmq*/
									 AND (
				(x.idopont_ellatas IS NOT NULL AND x.idopont_ellatas IN(8,19)) OR
				(x.idopont_ellatas IS NULL AND b.ellatas_id IN(8,19)) OR
				(x.idopont_ellatas IN(8,19) OR b.ellatas_id IN(8,19))
			)
		 /*qqi*/
									 /*custom3*/
								GROUP BY
									x.idopont_id
								ORDER BY
									y.ardecimal ASC, x.idopont_datum1 ASC, x.idopont_tipuskod DESC /*idopont_orderby*/
								LIMIT 0, 1
							) AS idopontid,
							a.galeria_id,
							l.ellatas_nev,
							m.szallaskat_nev,
							n.utazasmod_nev,
							c.orszag_nev
						FROM
							ajanlat a
							LEFT JOIN ajanlat_korutazas ku ON (a.ajanlat_id = ku.ajanlat_id)
							INNER JOIN arajanlat b ON a.ajanlat_id = b.ajanlat_id
							LEFT JOIN orszag c ON (b.orszag_id = c.orszag_id)
							LEFT JOIN hajo h ON (b.hajo_id = h.hajo_id)
							INNER JOIN irodak o ON b.iroda_id = o.iroda_id
							LEFT JOIN ellatas l ON b.ellatas_id = l.ellatas_id
                    		LEFT JOIN szallaskat m ON b.szallaskat_id = m.szallaskat_id
                    		LEFT JOIN utazasmod n ON b.utazasmod_id = n.utazasmod_id
						WHERE
							a.ajanlat_status = 1
							 AND (a.ajanlat_megosztas = 1 OR b.iroda_id = 551) /*irodaquery*/
							 AND b.iroda_id IN(260) AND b.szallaskat_id IN(2,1) /*sq*/
							 AND (b.iroda_id NOT IN(279,389,317,509,28,400,544,545,285,150,12,201,536,259,383,250,274,4,100,333,407,534,540,67,229,391,390,548,486,516,521,230,542,268,453,537,363,469,513,305,24,495,222,546)) /*_SESSION['query_filter']*/
							 /*irodaAtvetelKizarva_filter*/
							 /*litestr*/
							 /*custom2*/
							 /*ajanlat_not*/
							 /*egyediirodaquery*/
						GROUP BY
							a.ajanlat_id /*groupby2*/
					) as t
				LEFT JOIN arak as a ON (a.idopont_id = t.idopontid)
				LEFT JOIN idopont as ido ON (ido.idopont_id = t.idopontid)
			WHERE
				1 = 1
				 AND a.ardecimal IS NOT NULL /*ardecimalNotNull*/
				 AND (
			(ido.idopont_ellatas IS NOT NULL AND ido.idopont_ellatas IN(8,19)) OR
			(ido.idopont_ellatas IS NULL AND t.ellatas_id IN(8,19)) OR
			(ido.idopont_ellatas IN(8,19) OR t.ellatas_id IN(8,19))
		) /*arsql*/
				 /*custom1*/
			ORDER BY
				`arnelkuli` ASC,
				IF (a.eurosar = 1, euro_forint_iroda, a.ardecimal) ASC  /*sord2*/
			LIMIT 0 /*params['pge']*/, 200 /*params['ajanlat_mennyiseg']*/
		 / Got error 28 from storage engine