All pastes #343107 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-02-06 20:04 UTC
rendered paste body
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