SELECT *
FROM vkt_prog_erw
WHERE (
(
bis_datum >= CURRENT_DATE
OR datum >= CURRENT_DATE
)
AND (
(
bis_datum <= DATE_ADD( CURRENT_DATE, INTERVAL 31
DAY )
AND bis_datum > '0000-00-00'
)
AND (
datum <= DATE_ADD( CURRENT_DATE, INTERVAL 31
DAY )
AND datum > '0000-00-00'
)
)
)
ORDER BY 'datum', 'ort', 'zeit' ASC
LIMIT 0 , 30