/* kereses_summa_511_ */
			SELECT
				COUNT(DISTINCT a.ajanlat_id /*groupby1*/) AS summa
			FROM
				ajanlat a
				LEFT JOIN ajanlat_korutazas ku ON (a.ajanlat_id = ku.ajanlat_id),
				arajanlat b
				LEFT JOIN orszag c ON (b.orszag_id = c.orszag_id)
				LEFT JOIN hajo h ON (b.hajo_id = h.hajo_id),
				irodak o,
				idopont x,
				arak k
			WHERE
				a.ajanlat_id = b.ajanlat_id
				AND a.ajanlat_id = x.ajanlat_id
				AND x.idopont_id = k.idopont_id
				AND b.iroda_id = o.iroda_id
				AND a.ajanlat_status = 1
				
            AND x.idopont_status = 1
            AND(
                (x.idopont_szezonalis = 1 AND x.idopont_datum1 <= '2025-05-20'/*datumMinRug*/ AND `x`.`idopont_datum2` >= '2024-04-21'/*datumMinRugPlus*/)
                OR (x.idopont_szezonalis = 0 AND x.idopont_datum1 >= '2024-04-20'  AND x.idopont_datum1 <= '2025-05-20'/*datumXpstr22*/) 
            ) AND (
                (x.idopont_arlejar > '0000-00-00' AND x.idopont_arlejar >= '2024-04-21' /*holnap*/)
                OR (x.idopont_arlejar = '0000-00-00')
            )
         /*datumFeltetel*/
				 /*lmq*/
				 AND (
				(x.idopont_ellatas IS NOT NULL AND x.idopont_ellatas IN(8%2C19)) OR
				(x.idopont_ellatas IS NULL AND b.ellatas_id IN(8%2C19)) OR
				(x.idopont_ellatas IN(8%2C19) OR b.ellatas_id IN(8%2C19))
			)
		 /*qqi*/
				 AND (b.ellatas_id IN(8%2C19) OR x.idopont_ellatas IN(8%2C19)) /*ketszer*/
				 AND (a.ajanlat_megosztas = 1 OR b.iroda_id = 511) /*irodaquery*/
				 AND (b.orszag_id IN(10) OR ku.orszag_id IN(10)) AND b.utazasmod_id IN(1)AND ((b.prtipus_id LIKE '%/1/%'))  /*sq*/
				 AND (b.iroda_id  IN(252,236,248,389,28,111,143,32,285,233,343,150,9,81,430,31,250,17,4,501,554,45,357,173,407,29,484,229,56,486,516,230,528,83,48,452,53,363,224,205,138,513,260,110,126,482,141,24,511,479,19,244,222,200)) /*_SESSION['query_filter']*/
				 /*irodaAtvetelKizarva_filter*/
				  /*litestr*/
				 /*custom2*/
				 /*custom4*/
				 /*egyediirodaquery*/
		 / Unknown column '2C19' in 'where clause'