SET @s = CONCAT(
            'SELECT * FROM p_events as e
            INNER JOIN p_locations as l
            ON e.location = l.id
            INNER JOIN p_locations_staedte s
            ON  l.stadt = s.id
            INNER JOIN p_events_bilder b
            ON e.id = b.cid
            WHERE
                datum = DATE_FORMAT(DATE_ADD(now(), INTERVAL ' , val , ' DAY), "%Y-%m-%d")
            and
                GetDistance(' , latitude , ',' , longitude , ', l.breitengrad, l.laengengrad) < ' , radius ,
            ' and ( l.name IN ( ' , searchterm , ') OR e.titel IN (' , searchterm , ') OR e.kurztext IN (' , searchterm , ')) LIMIT ' , lmt
            );