Recent News

create or replace view vevents as SELECT regions.path, r2.content as dtstart, r3.content as dtend FROM regions left join regions as r2 on regions.path = r2.path and r2.name = 'dtstart' left join regions as r3 on regions.path = r3.path and r3.name = 'dtend' WHERE regions.path NOT LIKE '%/index.html' AND regions.path not like '%/list/%' group by regions.path having dtend > date_sub(curdate(), interval 1 hour) order by dtstart ASC ;