/* ajanlat_detail_idopontok_280_712435 */
		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), 354.52) * b.ardecimal), b.ardecimal) AS euro_forint_iroda,
            b.arak_osszesitett AS ar_alap01,
            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), 354.52) * b.arak_osszesitett), b.arak_osszesitett) AS euro_forint_iroda,
            b.arak_osszesitett AS ardecimal
        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 = '712435' 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.arak_osszesitett / Got error -1 from storage engine