SQL: (29.240183) select l.*, t.time_zone, t.full_name as theater_full, t.short_name as theater_short from locations l, theaters t where l.theater_id = t.id order by l.place
SQL: (2.2433) 
		select u.* from users u where u.teacher = 1  
SQL: (10.162351) 
		select w.id, title, tags, s.start, s.end, capacity,
		cost, class_show, notes, teacher_user_id,
		co_teacher_user_id, s.rank, w.online_url,
		s.online_url as override_url,
		s.location_id as override_location_id,
		s.last_session, application,
		w.location_id, w.status_id, w.class_sessions,
		w.show_sessions, w.last_session_start, w.spots_taken
		from workshops w
		LEFT JOIN sessions s on s.workshop_id = w.id
		where ((s.start >= date('2015-06-28 00:00:00') and s.start <= date('2015-08-02 00:00:00')))
		order by s.start asc;
wgis: class calendar

1615 N. Vermont Ave. Los Angeles, CA 90027

Sun
Mon
Tue
Wed
Thu
Fri
Sat

28

29

30

1

2

3

4

5

6

7

8

9

10

11

12

5pm: Tracers Workshop Will Hines (1 of 1) (LA)

13

14

15

16

17

18

19

20

21

22

23

24

25

3pm: Silence, Reactions, Presence (Villa) Will Hines (1 of 1) (LA)

26

1pm: Silence, Reactions, Presence (MC) Will Hines (1 of 1) (LA)

27

28

29

30

31

1