An Error Was Encountered
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-12, 12' at line 11
SELECT fa_movies.name, fa_movies.year, fa_movies.length, fa_movies.movieID, fa_movies.rating, coverImageName, _shd_languages.language as language, COUNT(fa_posts.content) as num FROM fa_posts JOIN fa_movies ON fa_movies.movieID = fa_posts.movieID JOIN _shd_languages ON _shd_languages.languageID = fa_movies.languageID JOIN fa_contracts ON fa_contracts.id = fa_movies.contractID AND fa_contracts.user_id != fa_posts.userID WHERE fa_movies.online = 1 AND fa_movies.recordType = 'normal' AND fa_movies.contractID != 0 GROUP BY fa_posts.movieID ORDER BY num DESC LIMIT -12, 12