/* ajanlat_detail_idopontok_388_815898 */
		SELECT
            a.*,
            b.*,
			varos.varos_nev,
            IF (b.eurosar = 1, ROUND(IF ((SELECT euroarfolyam FROM irodak WHERE iroda_id = a.iroda_id) > 0, (SELECT euroarfolyam FROM irodak WHERE iroda_id = a.iroda_id), 400.00) * b.ardecimal), b.ardecimal) AS euro_forint_iroda
        FROM
            idopont a
			JOIN arak b ON a.idopont_id = b.idopont_id
			LEFT JOIN varos ON varos.varos_id = a.idopont_repterkod
		WHERE
            a.ajanlat_id = '815898' AND
            a.idopont_id = b.idopont_id AND
            a.idopont_status = 1 AND
            (
                (a.idopont_szezonalis = 1  AND a.idopont_datum2 >= '2026-05-29') OR
                (a.idopont_szezonalis = 0 AND a.idopont_datum1 >= '2026-05-29' )
            ) AND (
                (a.idopont_arlejar > '0000-00-00' AND a.idopont_arlejar >= '2026-05-29') OR
                (a.idopont_arlejar = '0000-00-00')
            ) 
		ORDER BY
            a.idopont_datum1, 
            b.ardecimal / Got error 28 from storage engine