/* kereses_summa_117_ */ 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-04-29'/*datumMinRug*/ AND `x`.`idopont_datum2` >= '2024-03-30'/*datumMinRugPlus*/) OR (x.idopont_szezonalis = 0 AND x.idopont_datum1 >= '2024-03-29' AND x.idopont_datum1 <= '2025-04-29'/*datumXpstr22*/) ) AND ( (x.idopont_arlejar > '0000-00-00' AND x.idopont_arlejar >= '2024-03-30' /*holnap*/) OR (x.idopont_arlejar = '0000-00-00') ) /*datumFeltetel*/ /*lmq*/ AND (x.idopont_idotartam >= 7%2F10%2C0%2F6%2C11%2F99 OR x.idopont_minimum >= 1) /*qqi*/ /*ketszer*/ AND (a.ajanlat_megosztas = 1 OR b.iroda_id = 117) /*irodaquery*/ AND b.utazasmod_id IN(3%2C13%2C14) /*sq*/ AND (b.iroda_id IN(252,236,248,111,32,285,150,9,81,430,31,336,250,64,17,554,45,357,100,173,333,407,29,67,391,329,390,56,230,83,48,53,205,117,260,110,126,141,24,19,200)) /*_SESSION['query_filter']*/ /*irodaAtvetelKizarva_filter*/ /*litestr*/ /*custom2*/ /*custom4*/ /*egyediirodaquery*/ / Unknown column '2F10' in 'where clause'