/* atvevoajanlat_summa_175_177556 */ 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 <= '2023-06-21' /*datumMinRug*/ AND `x`.`idopont_datum2` >= '2022-05-22' /*datumMinRugPlus*/) OR (x.idopont_szezonalis = 0 AND x.idopont_datum1 >= '2022-05-22' /*datumXminusz*/ AND x.idopont_datum1 <= '2023-06-21' /*datumXpstr22*/) /*iroda502*/ ) AND ( (x.idopont_arlejar > '0000-00-00' AND x.idopont_arlejar >= '2022-05-21' /*arlejar*/) OR (x.idopont_arlejar = '0000-00-00') ) /*lmq*/ /*qqi*/ /*ketszer*/ AND (a.ajanlat_megosztas = 1 OR b.iroda_id = 175) /*irodaquery*/ AND (b.orszag_id IN(15) OR ku.orszag_id IN(15)) AND (b.varos_id IN(695,2689) OR ku.varos_id IN(695,2689)) AND b.iroda_id IN(,111,173,528,260) /*sq*/ AND (b.iroda_id NOT IN(333)) /*_SESSION['query_filter']*/ /*irodaAtvetelKizarva_filter*/ /*litestr*/ /*custom2*/ /*custom4*/ /*egyediirodaquery*/ / You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '111,173,528,260) /*sq*/ AND (b.iroda_id NOT IN(333)) /*_SESSION['query_fil' at line 32