Cinema 3		Features	Prices
	2322 West Pierce Carlsbad NM 88220 (map) Print All Carlsbad Showtimes	•  Advance ticket purchase available •  All Theatres Digital Projection •  Now offering Online Ticket Sales. Click on the show time to buy.	Adult (after 6:00 pm): $8.00 Child: $6.00 Senior: $6.00 Matinee (before 6:00 pm): $6.00 3D Movie Surcharge: $2.00
	Cinema 3 Showtimes For  Sat Feb 4, 2012 Sun Feb 5, 2012 Mon Feb 6, 2012 Tue Feb 7, 2012 Wed Feb 8, 2012 Thu Feb 9, 2012

SELECT * FROM allen_movies LEFT JOIN allen_ratings USING(rating_num) LEFT JOIN allen_movie_genres USING(genre_num) LEFT JOIN allen_show_times USING(movie_num) WHERE theater_num = '5' AND show_date = '07-05-2009' GROUP BY movie_num ORDER BY movie_release_date DESC, movie_name ASC