SELECT * FROM `mrlafiadb01`.`movies` WHERE CATEGORY LIKE '%Historique%' AND COUNTRY LIKE '%U.S.A.%' AND (ORIGINALTITLE LIKE '%PierreMarie RochefortSchneider%' OR TRANSLATEDTITLE LIKE '%PierreMarie RochefortSchneider%' OR ACTORS LIKE '%PierreMarie RochefortSchneider%' OR DIRECTOR LIKE '%PierreMarie RochefortSchneider%' OR PRODUCER LIKE '%PierreMarie RochefortSchneider%') ORDER BY DATEADD DESC, ORIGINALTITLE   LIMIT -40,40<br />
<br />
Invalid Query: 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 '-40,40' at line 1