cauta in articole
intra in cont

 121.news:

Programul cinematografelor din Bucuresti

pe perioada 27.08.2010 - 02.09.2010
Table 'one2one_db121.movies' doesn't exist in select movies.name_ro as name, movies.name as name_en, cinema_events.hours as hours, cinema_events.start_day as start_day, cinema_events.end_day as end_day, cinema_events.status as status, movies.production_ro as production, movies.director as director, movies.artists as artists, movies.descr_ro as descr_ro, movies.id as movie_id, movie_categories.name_ro as movie_category, Cinemas.name_ro as cinema, Cinemas.id as cinema_id from movies, cinema_events, movie_categories, Cinemas where ( ( cinema_events.start_day >= '2010-08-27' and cinema_events.start_day <= '2010-09-02' ) or ( cinema_events.start_day <= '2010-08-27' and cinema_events.end_day >= '2010-09-02' ) or ( cinema_events.end_day >= '2010-08-27' and cinema_events.end_day <= '2010-09-02' ) ) and Cinemas.id=cinema_events.cinema_id and movies.id=cinema_events.movie_id and movies.categ_id=movie_categories.id order by name asc, cinema asc, start_day asc