SELECT kursid, datum, DATE_FORMAT(datum,"%d.%m.%Y") AS datumtext, anbieterid, titel, bezirkid FROM kurse, tblwebuser WHERE anbieterid=tblwebuser.ID AND tblwebuser.Warnungen<25 AND ( titel LIKE "%%" OR ref LIKE "%%" OR refdesc LIKE "%%" OR beschreibung LIKE "%%" OR zeit LIKE "%%" OR location LIKE "%%" OR url LIKE "%%" OR keywords LIKE "%%" ) AND anbieterid = 7 and (datum="1970-01-01" or datum >= CURDATE()) ORDER BY datum ASC LIMIT 540, 15;