You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group by m.movie_id order by collection desc limit 0,100' at line 1

Rank

Film

Release Date

Nett Gross

Rate It!