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
|
