Распаковывается пакет mysql-server-5.0 (из файла .../mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb)...
Настраивается пакет mysql-server-5.0 (5.0.51a-3ubuntu5.1) ...
 * Stopping MySQL database server mysqld                                                  [ OK ] 
/var/lib/dpkg/info/mysql-server-5.0.postinst: line 143: /etc/mysql/conf.d/old_passwords.cnf: No such file or directory
dpkg: не удалось обработать параметр mysql-server-5.0 (--configure):
 подпроцесс post-installation script возвратил код ошибки 1
При обработке следующих пакетов произошли ошибки:
 mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)

не установлено до конца или удалено 1 пакетов.
After this operation, 0B of additional disk space will be used.
Настраивается пакет mysql-server-5.0 (5.0.51a-3ubuntu5.1) ...
 * Stopping MySQL database server mysqld                                                  [ OK ] 
080622  4:44:39 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
080622  4:44:39 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/user.frm' (errno: 13)
080622  4:44:39 [ERROR] Aborting

080622  4:44:39 [Note] /usr/sbin/mysqld: Shutdown complete

Reloading AppArmor profiles : done.
 * /etc/init.d/mysql: WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz
 * Starting MySQL database server mysqld                                                  [fail] 
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: не удалось обработать параметр mysql-server-5.0 (--configure):
 подпроцесс post-installation script возвратил код ошибки 1
При обработке следующих пакетов произошли ошибки:
 mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1

SELECT id
FROM course
WHERE courseID
IN (
  SELECT `courseID`
  FROM cclass_user_course
  WHERE `userID` = 1
)

SELECT date
FROM course_date
WHERE courseID
IN (

  SELECT id
  FROM course
  WHERE courseID
  IN (

    SELECT courseID
    FROM user_course
    WHERE `userID` =1
  )
)

select d.date, c.title 
from course_date d 
left join course c on d.courseID = c.id 
left join course_user u on c.id = u.courseID 
where userID = 1;

SELECT d.date, c.title
FROM cclass_course_date AS d
LEFT JOIN cclass_course AS c ON d.courseID = c.id
LEFT JOIN cclass_user_course AS u ON c.id = u.courseID
WHERE u.userID =1
AND u.type =1
AND d.date > NOW()
GROUP c.title