
Tourbeginn
Am 18.3. startet die kleine Frühjahrstour. Wann comedy Handwerker denn? Jetzt!
[mehr]
SELECT a.articleID AS id, a.subline AS link, a.var2 AS slots, a.headline AS title, a.var19 AS conditions, a.var3 AS pic, a.var10 AS pic_cover, a.var8 AS location, a.var9 AS address, a.var14 AS status, a.text2 AS more, a.var13 AS info, a.var1 AS url_ticket, a.var11 AS url_website, UNIX_TIMESTAMP(a.userdate) AS ts_date, DATE_FORMAT(a.userdate,'%d. #. %Y') AS datestr, DATE_FORMAT(a.userdate,'%c') AS date_month, DATE_FORMAT(a.userdate, '%c %Y') AS date_head, DATE_FORMAT(a.userdate,'%w.%d.%m') AS date_str, DATE_FORMAT(a.userdate,'%H:%i') AS time_str, g.name AS event, g.groupID AS id_event FROM article a LEFT JOIN link l ON (l.linkID = a.articleID AND l.keyID=0 AND l.subricID=1 ) LEFT JOIN groups g ON (g.groupID = l.groupID) LEFT JOIN link l2 ON (l2.linkID = a.articleID AND l2.keyID=0 AND l2.subricID=2 ) LEFT JOIN groups g2 ON (g2.groupID = l2.groupID) WHERE a.active>=1 AND a.list>=1 AND a.rubricID=5 AND a.userdate >= NOW() AND (a.userdate2 IS NULL OR a.userdate2 <= NOW()) ORDER BY a.userdate LIMIT 14
Hier findest Du alle kommenden LIVE-Termine von Handwerker Peters im Überblick