Leaderboard

If you know the date, you know the day of the week. For example SELECT m.title , s.name as screen , date_format(sg.screen_on, '%W, %D %b') as date FROM screening sg JOIN screen s ON sg.screen_id = s.id JOIN movie m ON sg.movie_id - m.id WHERE dayname(screen_on) = 'Wednesday' ORDER BY screen_on; giving +------------------------+------------+---------------------+ | title | screen | date | +------------------------+------------+---------------------+ | Mission Implausible | Screen One | Wednesday, 17th Jan | | Shaving Ryan's Private | Screen Two | Wednesday, 17th Jan | +------------------------+------------+---------------------+