Box Office by Studio
January 1March 22, 2015
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 '2015-01-01' AND '2015-03-22' AND todateGross>0 AND studio.filename IN('wdimension.htm','dragondynasty.htm','weinsteincompany.htm') ORDER BY gross DESC, gross DESC LIMIT 0, 100#12
#12Data based on movies released between Jan. 1 and Mar. 22 and includes titles released by Weinstein Company, Weinstein / Dimension and Weinstein / Dragon Dynasty.
|Rank||Movie Title (click to view)||Studio||Total Gross / Theaters||Opening / Theaters||Open|
|Summary of 2 Movies on Chart:|