SELECT CONCAT(user.firstname, ' ', user.lastname ) AS `ФИО`, (SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = '10200' AND UID.userid = user.id) as 'Повышение квалификации и переподготовка', DATE_FORMAT((SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = '10203' AND UID.userid = user.id), '%d.%m.%Y') as 'Дата получения диплома', DATE_FORMAT((SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = '10202' AND UID.userid = user.id), '%d.%m.%Y') as 'Дата окончания срока действия диплома', DATEDIFF((SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = '10202' AND UID.userid = user.id),NOW()) as 'Дней до окончания срока действия диплома', (SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = '20200' AND UID.userid = user.id) as 'Повышение квалификации и переподготовка1', DATE_FORMAT((SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = '20203' AND UID.userid = user.id), '%d.%m.%Y') as 'Дата получения диплома1', DATE_FORMAT((SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = '20202' AND UID.userid = user.id), '%d.%m.%Y') as 'Дата окончания срока действия диплома1', DATEDIFF((SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = '20202' AND UID.userid = user.id),NOW()) as 'Дней до окончания срока действия диплома1', (SELECT name FROM prefix_role WHERE id=en.roleid) AS '' FROM prefix_course AS course JOIN prefix_enrol AS en ON en.courseid = course.id JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id JOIN prefix_user AS user ON ue.userid = user.id WHERE (DATEDIFF((SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = '10202' AND UID.userid = user.id),NOW())) > -5000 ORDER BY (DATEDIFF((SELECT UID.data FROM prefix_user_info_field UIF, prefix_user_info_data UID WHERE UID.fieldid = UIF.id AND UIF.shortname = '10202' AND UID.userid = user.id),NOW())) ASC