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