SELECT m.id_movie, m.webid, m.MovieTitle, studio.nameShort as studio, SUM(c.gross) as gross, MAX(c.maxtheaters) as theaters, m.todateGross as totalgross, SUM(c.gross)/m.todateGross*100 as percoftotal, 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_bocalendarmonthly c, boxoff_movies m, boxoff_names_convert studio WHERE c.date BETWEEN '2014-01-01' AND '2014-12-31' AND c.gross!=0 AND c.id_movie=m.id_movie AND m.distributor=studio.nameRegular AND studio.filename IN('drivingwithoureyesshut.htm') GROUP BY c.id_movie ORDER BY gross DESC, gross DESC LIMIT 0, 100