~[tlist_sql;SELECT bs.id, bs.Name
FROM Calendar_Day cd
INNER JOIN Bell_Schedule bs ON cd.Bell_Schedule_ID = bs.ID
WHERE cd.date_value = trunc(to_date('~[date]','MM/DD/YYYY'))
AND cd.SchoolID =~(curschoolid);nonemessage=
~[tlist_sql;SELECT t.first_name, t.last_name FROM Teachers t WHERE t.ID=~[x:userid]] ~[text]psx.html.teachers_mobile.home.schedule,param:~(t.first_name;t),param:~(t.last_name;t)[/text][/tlist_sql]
~[tlist_sql;
SELECT s.ID, s.Expression, s.Room, c.Course_Name, s.no_of_students
FROM Sections s
INNER JOIN Courses c
ON UPPER(s.Course_Number)=UPPER(c.Course_Number)
WHERE s.Teacher=~[x:userid] AND s.termid IN (SELECT ID FROM Terms WHERE firstday <= trunc(to_date('~[date]','MM/DD/YYYY')) AND lastday >= trunc(to_date('~[date]','MM/DD/YYYY')) AND schoolid=~(curschoolid))
ORDER BY s.Expression, c.Course_Name]