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 (datum="1970-01-01" or datum >= CURDATE()) ORDER BY anbieterid ASC LIMIT 165, 15;