USA
ROM
|
People
Articles
Regions
Download
Lists
Schools
News
Movies
Sites & Blogs
Couples
Questions
Quotes
Born Today
Born Where
Fame Schooling
Movies
Famous Lists
SHOCK!
Quotes
Zodiac
Sites/Blogs
Couples
Famous Movies
Comedy
Short
Family
Animation
Crime
Film-Noir
Drama
Biography
Adventure
Documentary
Musical
Romance
Action
Mystery
Western
Music
War
Fantasy
Western
History
Thriller
Sci-Fi
Sport
Horror
Game-Show
comedy
horror
thriller
News
Reality-TV
Action/Adventure
Kids
and
Adaptation
action
adventure
science fiction
fantasy
adaption
Adventure
Fantasy
Talk-Show
Romance
Kids/Family
Sequel
Art/Foreign
Drama
Science Fiction/Fantasy
Acion
Action,
Comedy
Family
Thriller
Crime
Mystery
Comedy
Sci-Fi
Action
Crime
Movies from Horror category
Apartment 20
2003
The Love Ballad of Scarab Hack
2003
Exorcism
2003
Open Water
2003
Arachnia
2003
The Manson Family
2003
Trick or Treat!
2003
Love Object
2003
Beyond Re-Animator
2003
Hunting for Herschell
2003
Season of the Hunted
2003
Corner of Your Eye
2003
The Order
2003
Filthy
2003
Final Destination 2
2003
Underworld
2003
Identity
2003
Maplewoods
2003
Beauty in the Dark
2003
The Pill
2003
Phobias
2003
Vanity Mirror
2003
The Raven
2003
Tsui Hark`s Vampire Hunters
2002
Showing 1153 - 1176 of 3113 records returned
Previous
49
50
51
52
53
54
55
56
57
58
...
130
Next
Search a movie
reviews
popular
box office
Error at line:
1055 : Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'famousw_famousdata.movie_reviews.mr_entry_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Sql
SELECT m_name,m_id FROM movies,movie_reviews WHERE m_id = mr_movie_id GROUP BY m_id ORDER BY mr_entry_date DESC LIMIT 10