SELECT * FROM `mdb`.`movies` WHERE (ORIGINALTITLE LIKE '%Gavin MacLeod%' OR TRANSLATEDTITLE LIKE '%Gavin MacLeod%' OR ACTORS LIKE '%Gavin MacLeod%' OR DIRECTOR LIKE '%Gavin MacLeod%' OR PRODUCER LIKE '%Gavin MacLeod%') ORDER BY DATEADDED DESC, TRANSLATEDTITLE ASC  LIMIT -100,100<br />
<br />
Invalid Query: 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 '-100,100' at line 1