Is there a better MySql query that’s more efficient

I have a query I built up with a little help from web searching, however it is not efficient with the large dataset I have. I set the query running 10 days ago and it’s not finished. I have no idea how far it has actually gotten either. I’m fairly sure that the ORDER BY part isn’t required, I don’t know how much extra it is adding to the process.

Is this a good database design in 3NF?

I’m trying to understand how databases work by creating a movie theater database in MySQL. I created the following requirements and attempted to sketch out my ER diagram based on 3NF. A lot of resources said I should use associative tables, so I attempted to, but I am not sure if I am understanding the relationships between them correctly. Is this a good database design for the requirements? Are the associations correct?
enter image description here