Box Office by Studio
SELECT id_movie, webid, MovieTitle, studio.nameRegular 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-05-06' AND todateGross>0 AND studio.filename IN('wreckinhill.htm') ORDER BY studio.nameRegular ASC, gross DESC LIMIT 0, 100#14
#14Note: This chart shows all movies from a specific studio where grosses are available. Because box office was not widely tracked prior to 1982, many titles may not be available before this time period.
|Row||Rank||Movie Title (click to view)||Studio||Total Gross / Theaters||Opening / Theaters||Open|
|2||2||The Flowers of War||Wrekin Hill||$311,434||30||$48,448||30||1/20/12|
|3||3||The Inbetweeners Movie||Wrekin Hill||$36,000||10||$36,000||10||9/7/12|
|4||4||Comic-Con Episode IV: A Fan's Hope||Wrekin Hill||$34,665||6||$8,203||3||4/6/12|
|Summary of 4 Movies on Chart:|