First prototype
diff --git a/sqldeprecated.txt b/sqldeprecated.txt
new file mode 100644
index 0000000..ffac11a
--- /dev/null
+++ b/sqldeprecated.txt
@@ -0,0 +1,71 @@
+$sql = "SELECT st.*, t.*, r.*, strftime('%Y%m%d', '22:34:12') as today, strftime('%Y%m%d', '22:34:12', '1 day') as tomorrow, time('22:34:12') as now
+ FROM stop_times st
+ INNER JOIN trips t
+ ON st.trip_id = t.trip_id
+ INNER JOIN routes r
+ ON t.route_id = r.route_id
+ LEFT JOIN calendar c
+ ON t.service_id = c.service_id
+ LEFT JOIN calendar_dates cd
+ ON t.service_id = cd.service_id
+ WHERE
+ st.stop_id IN (".implode(", ", array_fill(0, count($stops), "?")).") AND
+ (
+ (
+ time(now) < time('23:30:00') AND
+ time(st.departure_time) BETWEEN time(now) AND time(now, '30 minutes') AND
+ (
+ c.service_id IS NULL OR
+ (
+ c.start_date <= today AND
+ c.end_date >= today
+ )
+ ) AND
+ (
+ cd.service_id IS NULL OR
+ cd.date = today
+ )
+ ) OR
+ (
+ time(now) >= time('23:30:00') AND
+ (
+ (
+ time(st.departure_time) >= time(now) AND
+ (
+ c.service_id IS NULL OR
+ (
+ c.start_date <= today AND
+ c.end_date >= today
+ )
+ ) AND
+ (
+ cd.service_id IS NULL OR
+ cd.date = today
+ )
+ ) OR
+ (
+ time(st.departure_time) <= time(now, '30 minutes') AND
+ (
+ c.service_id IS NULL OR
+ (
+ c.start_date <= tomorrow AND
+ c.end_date >= tomorrow
+ )
+ ) AND
+ (
+ cd.service_id IS NULL OR
+ cd.date = tomorrow
+ )
+ )
+ )
+ )
+ ) AND
+ (
+ c.service_id IS NULL OR
+ c.$dow = ".(int)Gtfs\Calendar\CalendarDay::AVAILABLE."
+ ) AND
+ (
+ cd.service_id IS NULL OR
+ exception_type = ".(int)Gtfs\CalendarDate\ExceptionType::ADDED."
+ )
+ ORDER BY departure_time ASC";