Upholland UNITAPE
Online Catalogue
PDF version download - Shop Basket

ERROR: Not a valid subject or subject has no associated lectures.

SELECT l.LectureID, l.UnitapeNumber, l.LectureName, l.Unavailable, s.SubjectID, s.SubjectName, ser.SeriesID, ser.SeriesName, top.TopicID, top.TopicName, GROUP_CONCAT(CONCAT(spk.Forename, ' ', spk.Surname) SEPARATOR ';') AS SpeakerNames FROM subjects AS s INNER JOIN lecturesubject AS ls ON s.SubjectID = ls.Subject INNER JOIN lectures AS l ON ls.Lecture = l.LectureID INNER JOIN series AS ser ON l.Series = ser.SeriesID INNER JOIN topics AS top ON ser.Topic = top.TopicID INNER JOIN lecturespeaker AS lecspk ON l.LectureID = lecspk.Lecture INNER JOIN speakers AS spk ON lecspk.Speaker = spk.SpeakerID WHERE s.SubjectID = 1 GROUP BY l.UnitapeNumber ORDER BY l.UnitapeNumber
Site maintained by Liverpool Hope University
Online store provided by Liverpool Catholic Archdiocese
Any enquiries contact unitape@hope.ac.uk