ERROR SQL

Requéte : SELECT * FROM produits WHERE famille='6' AND debut_affichage_prod<=NOW() AND fin_affichage_prod>=NOW() AND p_affichage='o' ORDER BY id DESC LIMIT -10,10

Erreur : 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 '-10,10' at line 1