SELECT COUNT(cinemaId) as numSessions FROM movieSessionTimes WHERE cineplexId = 1 AND movieId = 1022 AND TO_DAYS(date) >= TO_DAYS("2016-09-29") ORDER BY date SELECT COUNT(cinemaId) as numSessions FROM movieSessionTimes WHERE cineplexId = 2 AND movieId = 1022 AND TO_DAYS(date) >= TO_DAYS("2016-09-29") ORDER BY date SELECT COUNT(cinemaId) as numSessions FROM movieSessionTimes WHERE cineplexId = 3 AND movieId = 1022 AND TO_DAYS(date) >= TO_DAYS("2016-09-29") ORDER BY date SELECT COUNT(cinemaId) as numSessions FROM movieSessionTimes WHERE cineplexId = 4 AND movieId = 1022 AND TO_DAYS(date) >= TO_DAYS("2016-09-29") ORDER BY date SELECT COUNT(cinemaId) as numSessions FROM movieSessionTimes WHERE cineplexId = 5 AND movieId = 1022 AND TO_DAYS(date) >= TO_DAYS("2016-09-29") ORDER BY date SELECT COUNT(cinemaId) as numSessions FROM movieSessionTimes WHERE cineplexId = 6 AND movieId = 1022 AND TO_DAYS(date) >= TO_DAYS("2016-09-29") ORDER BY date SELECT COUNT(cinemaId) as numSessions FROM movieSessionTimes WHERE cineplexId = 7 AND movieId = 1022 AND TO_DAYS(date) >= TO_DAYS("2016-09-29") ORDER BY date Cineplex - 21
Join Cineplex! Password Retrieval