Box Office by Studio
SELECT id_movie, webid, MovieTitle, studio.nameShort as studio, todateGross as gross, MaxTheaters as theaters, openWkndGross as opengross, openWkndTheaters as opentheaters, ReleaseDate as open, CloseDate as close, TRIM(LEADING '\'' FROM TRIM(LEADING '* ' FROM TRIM(LEADING 'THE ' FROM TRIM(LEADING 'AN ' FROM TRIM(LEADING 'A ' FROM UPPER(m.MovieTitle)))))) as title FROM boxoff_movies m, boxoff_names_convert studio WHERE distributor=studio.nameRegular AND ReleaseDate BETWEEN '1910-01-01' AND '2015-06-03' AND todateGross>0 AND studio.filename IN('mgm.htm','mgmweinstein.htm','ua.htm') ORDER BY gross DESC, gross DESC LIMIT 500, 100#1100 - #101200 - #201300 - #301400 - #401500 - #501505
#1100 - #101200 - #201300 - #301400 - #401500 - #501505Note: This chart shows all movies from a specific studio (and includes titles released by MGM, MGM (Weinstein) and United Artists) where grosses are available. Because box office was not widely tracked prior to 1982, many titles may not be available before this time period.
|Rank||Movie Title (click to view)||Studio||Total Gross / Theaters||Opening / Theaters||Open|
|504||The Dust Factory||MGM||$12,311||22||$8,000||22||10/15/04|
|Summary of 505 Movies on Chart:|