No se pudo ejecutar la consulta

SELECT p.id,p.title,p.title_alias,p.hits,c.title as cate FROM mos_content p, mos_categories c WHERE p.catid = c.id AND c.title = 'Suspense'  ORDER BY p.created DESC LIMIT -100,100

Error MySQL: : 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 '-100,100' at line 1

Este Script no puede continuar.