This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
events:30dayfeed [2017/01/06 12:29] marto |
events:30dayfeed [2017/02/13 10:21] (current) marto include booking status |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Events within the next 30 days. ====== | ====== Events within the next 30 days. ====== | ||
- | Below is a list of events scheduled within the next 30 days. Certain events have their own listing in the [[events: | + | Below is a list of events scheduled within the next 30 days. Certain events have their own listing in the [[events: |
< | < | ||
Line 7: | Line 8: | ||
name as "Event Name", | name as "Event Name", | ||
description as " | description as " | ||
- | concat('< | + | concat('< |
+ | CASE | ||
+ | WHEN status = ' | ||
+ | WHEN status = ' | ||
+ | END as " | ||
from mrbs_entry | from mrbs_entry | ||
where from_unixtime( floor(start_time)) >= curdate() | where from_unixtime( floor(start_time)) >= curdate() |