< Back to summary of session times

SQL ERROR

SELECT session.*, Movie.ID AS Movie_ID, Movie.Name AS Movie_Name, Movie.MyRating AS Movie_MyRating, Movie.MyLanguage AS Movie_MyLanguage, Movie.MyGenre AS Movie_MyGenre, Movie.MyStatus AS Movie_MyStatus, Movie.SensorNote AS Movie_SensorNote, Movie.RunTime AS Movie_RunTime, Movie.Actors AS Movie_Actors, Movie.Spiel AS Movie_Spiel, Movie.TrailerLink AS Movie_TrailerLink, Movie.WebsiteLink AS Movie_WebsiteLink, Movie.ReviewsLink AS Movie_ReviewsLink, Movie.Download AS Movie_Download, Movie.StartDate AS Movie_StartDate, Movie.SmallPrint AS Movie_SmallPrint, Movie.Pic AS Movie_Pic, Movie.Views AS Movie_Views, Rating.ID AS Rating_ID, Rating.Name AS Rating_Name, Rating.Description AS Rating_Description, Language.ID AS Language_ID, Language.Name AS Language_Name, Genre.ID AS Genre_ID, Genre.Name AS Genre_Name, Status.ID AS Status_ID, Status.Name AS Status_Name, Theatre.ID AS Theatre_ID, Theatre.Name AS Theatre_Name FROM session LEFT JOIN Movie AS Movie ON session.MyMovie=Movie.ID LEFT JOIN Rating AS Rating ON Movie.MyRating=Rating.ID LEFT JOIN Language AS Language ON Movie.MyLanguage=Language.ID LEFT JOIN Genre AS Genre ON Movie.MyGenre=Genre.ID LEFT JOIN Status AS Status ON Movie.MyStatus=Status.ID LEFT JOIN Theatre AS Theatre ON session.MyTheatre=Theatre.ID WHERE MyMovie= ORDER BY Theatre.Name, SessionTime