Not Rated Movies Index - G

This list shows an overview of categories with Not Rated movies with a title beginning with G with for each category the movies listed that generated the most revenue. Click on the category to see a full list of all movies starting with those letters.

See also: People Names Beginning with G

« F H »

Index	Highest Grossing Movies
G -Ga	Query Failed: select mfs.movie_odid as movie_odid, mfs.movie_display_name as display_name, mfs.movie_od_name as od_name, mfs.domestic_box_office + mfs.international_box_office + IF( mvs.odid IS NOT NULL, mvs.domestic_dvd_consumer_spending+mvs.domestic_bluray_consumer_spending, 0 ) AS total_revenue FROM movie_financial_summary AS mfs LEFT JOIN movie_video_summary AS mvs ON mfs.movie_odid=mvs.movie_odid LEFT JOIN movie_movie_board_rating AS mmbr ON mmbr.movie_odid=mfs.movie_odid WHERE UPPER(substring(mfs.movie_od_name,1,2)) >= "G" AND UPPER(substring(mfs.movie_od_name,1,2)) <= "GA" mmbr.movie_board_rating_odid=60104 ORDER BY total_revenue DESC limit 3; -- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mmbr.movie_board_rating_odid=60104 ORDER BY total_revenue DESC limit 3' at line 1

Index

Highest Grossing Movies

G -Ga

Query Failed: select mfs.movie_odid as movie_odid, mfs.movie_display_name as display_name, mfs.movie_od_name as od_name, mfs.domestic_box_office + mfs.international_box_office + IF( mvs.odid IS NOT NULL, mvs.domestic_dvd_consumer_spending+mvs.domestic_bluray_consumer_spending, 0 ) AS total_revenue FROM movie_financial_summary AS mfs LEFT JOIN movie_video_summary AS mvs ON mfs.movie_odid=mvs.movie_odid LEFT JOIN movie_movie_board_rating AS mmbr ON mmbr.movie_odid=mfs.movie_odid WHERE UPPER(substring(mfs.movie_od_name,1,2)) >= "G" AND UPPER(substring(mfs.movie_od_name,1,2)) <= "GA" mmbr.movie_board_rating_odid=60104 ORDER BY total_revenue DESC limit 3; -- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mmbr.movie_board_rating_odid=60104 ORDER BY total_revenue DESC limit 3' at line 1