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
Das preisgekrönte Weihnachts-Comedy-Programm
18 Uhr (Einlass 17 Uhr)
Dauer: 2 Stunden + Pause
Tickets:
- Eventim (0 1806 570 07 0)
- Westticket (0 2161 62 10 78 1)
- Report Anzeigenblatt, Berliner Platz 11, 41061 Mönchengladbach (0 2162 933 99 0)
- Hall of Ticket, Alter Markt 9, 41061 Mönchengladbach (0 2161 247 21 6)
- Das Kartenhaus, Ticketshop im Kunstwerk Wickrath, Wickrathberger Str. 18B, 41189 Mönchengladbach-Wickrath (0 2166 133 93 0)
- Die Anzeige, Hauptstraße 89, 41747 Viersen (0 2162 933 99 0)
https://handwerker-peters.deHandwerker PetersHandwerker Peters - Drauß von der Baustell komm ich her | PolchSolo Veranstaltung mit Handwerker PetersDas preisgekrönte Weihnachts-Comedy-Programm
20 Uhr (Einlass 18 Uhr, Zeit zum lecker Essen)
Dauer: 2 Stunden + Pause
Tickets:
- Alter Bahnhof, Am Bahnhof 5, 56751 Polch, 0 2654 96 922 40, info@alter-bahnhof-polch.de
