SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'dekanEMail' 
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'dekanName' 
SELECT * FROM deans
SELECT SID FROM Students WHERE MID='1'
SELECT PID FROM Teachers WHERE MID='1'
SELECT DID FROM deans WHERE MID='1'
SELECT AID FROM admins WHERE MID='1'
select * from mid_log where mid=1
UPDATE mid_log SET page='4',role=4,data=NOW() where mid=1
select type from Teachers where mid=1
SELECT PID FROM Teachers WHERE MID='1' AND CID='1000017'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_FAR'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_ENG'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_RUS'
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'schedule' 
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'Mail' 
SELECT SQL_CACHE  value FROM OPTIONS WHERE name='chat'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_FAR'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_ENG'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_RUS'
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'schedule' 
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'Mail' 
SELECT SQL_CACHE  value FROM OPTIONS WHERE name='chat'
SELECT CID, Title as Title, scorm FROM Courses WHERE CID = '1000017' OR CID = '1000018' OR CID = '1000019' OR CID = '1000020' OR CID = '1000021'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_TREE1'
SELECT ModID,ord, Title as Title, SUBSTRING(Descript,1,8000) as Description FROM mod_list WHERE CID=1000017 AND Pub = 1 ORDER BY ord
select LID, ord, Title as Title, SUBSTRING(Description,1,8000) as Description from Lesson where MID=35 ORDER BY ord
SELECT PID FROM Teachers WHERE MID='1' AND CID='1000017'
select TID, ord, Title as Title,SUBSTRING(Description,1,8000) as Description from Target where LID=65 ORDER BY ord;
select * from exercise where cid='1000017' AND lid=65
SELECT PID FROM Teachers WHERE MID='1' AND CID='1000017'
select TID, ord, Title as Title,SUBSTRING(Description,1,8000) as Description from Target where LID=54 ORDER BY ord;
select * from exercise where cid='1000017' AND lid=54
SELECT PID FROM Teachers WHERE MID='1' AND CID='1000017'
select TID, ord, Title as Title,SUBSTRING(Description,1,8000) as Description from Target where LID=55 ORDER BY ord;
select * from exercise where cid='1000017' AND lid=55
SELECT PID FROM Teachers WHERE MID='1' AND CID='1000017'
select TID, ord, Title as Title,SUBSTRING(Description,1,8000) as Description from Target where LID=56 ORDER BY ord;
select * from exercise where cid='1000017' AND lid=56
select test_id from mod_list where modid=35
SELECT Title AS Title, tid FROM test WHERE tonm=2 AND tid IN('5000001')
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_TREE2'
SELECT Assign FROM Courses WHERE CID=1000017
select Title AS Title, tid from test where cid=1000017 AND status=1 AND tonm=3
SELECT Title as Title FROM Courses WHERE CID='1000017'
SELECT Description AS Description FROM Courses WHERE CID='1000017'
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'dekanEMail' 
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'dekanName' 
SELECT * FROM deans
select type from Teachers where mid=1
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_FAR'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_ENG'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_RUS'
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'schedule' 
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'Mail' 
SELECT SQL_CACHE  value FROM OPTIONS WHERE name='chat'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_FAR'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_ENG'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_RUS'
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'schedule' 
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'Mail' 
SELECT SQL_CACHE  value FROM OPTIONS WHERE name='chat'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_FAR'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_ENG'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_LANG_SWITCHER_TOOLTIP_TO_RUS'
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'schedule' 
SELECT  SQL_CACHE value FROM OPTIONS WHERE name = 'Mail' 
SELECT SQL_CACHE  value FROM OPTIONS WHERE name='chat'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_ABOUT'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_ABOUT1'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_ABOUT2'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_ABOUT3'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_ABOUT4'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_ABOUT5'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_ABOUT6'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_ABOUT7'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_ABOUT8'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_ABOUT9'
SELECT SQL_CACHE Title as Title FROM resources WHERE ID='IDS_ABOUT14'
SELECT FIO, email, type FROM personal ORDER BY type;
