Meny

Arrangementer
Nullstill filter
Filter Filter

last query = SELECT *,event_feed.id as efid,event_feed_schedule.id as eid, DATE(event_feed_schedule.start_time) as date, DATE(event_feed_schedule.start_time) as start_daten, DATE(event_feed_schedule.end_time) as end_daten, TIME(event_feed_schedule.start_time) as start_timen, TIME(event_feed_schedule.end_time) as end_timen FROM event_feed LEFT JOIN event_feed_schedule ON event_feed_schedule.event_feed_id = event_feed.id WHERE event_feed_schedule.start_time > CURRENT_DATE() AND MONTH(event_feed_schedule.start_time) = '7' order by date,event_feed.id last query = SELECT *,event_feed.id as efid,event_feed_schedule.id as eid, DATE(event_feed_schedule.start_time) as date, DATE(event_feed_schedule.start_time) as start_daten, DATE(event_feed_schedule.end_time) as end_daten, TIME(event_feed_schedule.start_time) as start_timen, TIME(event_feed_schedule.end_time) as end_timen FROM event_feed LEFT JOIN event_feed_schedule ON event_feed_schedule.event_feed_id = event_feed.id WHERE event_feed_schedule.start_time > CURRENT_DATE() AND MONTH(event_feed_schedule.start_time) = '8' order by date,event_feed.id
August
last query = SELECT *,event_feed.id as efid,event_feed_schedule.id as eid, DATE(event_feed_schedule.start_time) as date, DATE(event_feed_schedule.start_time) as start_daten, DATE(event_feed_schedule.end_time) as end_daten, TIME(event_feed_schedule.start_time) as start_timen, TIME(event_feed_schedule.end_time) as end_timen FROM event_feed LEFT JOIN event_feed_schedule ON event_feed_schedule.event_feed_id = event_feed.id WHERE event_feed_schedule.start_time > CURRENT_DATE() AND MONTH(event_feed_schedule.start_time) = '9' order by date,event_feed.id last query = SELECT *,event_feed.id as efid,event_feed_schedule.id as eid, DATE(event_feed_schedule.start_time) as date, DATE(event_feed_schedule.start_time) as start_daten, DATE(event_feed_schedule.end_time) as end_daten, TIME(event_feed_schedule.start_time) as start_timen, TIME(event_feed_schedule.end_time) as end_timen FROM event_feed LEFT JOIN event_feed_schedule ON event_feed_schedule.event_feed_id = event_feed.id WHERE event_feed_schedule.start_time > CURRENT_DATE() AND MONTH(event_feed_schedule.start_time) = '10' order by date,event_feed.id last query = SELECT *,event_feed.id as efid,event_feed_schedule.id as eid, DATE(event_feed_schedule.start_time) as date, DATE(event_feed_schedule.start_time) as start_daten, DATE(event_feed_schedule.end_time) as end_daten, TIME(event_feed_schedule.start_time) as start_timen, TIME(event_feed_schedule.end_time) as end_timen FROM event_feed LEFT JOIN event_feed_schedule ON event_feed_schedule.event_feed_id = event_feed.id WHERE event_feed_schedule.start_time > CURRENT_DATE() AND MONTH(event_feed_schedule.start_time) = '11' order by date,event_feed.id last query = SELECT *,event_feed.id as efid,event_feed_schedule.id as eid, DATE(event_feed_schedule.start_time) as date, DATE(event_feed_schedule.start_time) as start_daten, DATE(event_feed_schedule.end_time) as end_daten, TIME(event_feed_schedule.start_time) as start_timen, TIME(event_feed_schedule.end_time) as end_timen FROM event_feed LEFT JOIN event_feed_schedule ON event_feed_schedule.event_feed_id = event_feed.id WHERE event_feed_schedule.start_time > CURRENT_DATE() AND MONTH(event_feed_schedule.start_time) = '12' order by date,event_feed.id