SELECT * FROM `thebigwaf01`.`movies` WHERE COUNTRY LIKE '%New Zealand%' AND (ORIGINALTITLE LIKE '%Rosemary Harris%' OR TRANSLATEDTITLE LIKE '%Rosemary Harris%' OR DIRECTOR LIKE '%Rosemary Harris%' OR PRODUCER LIKE '%Rosemary Harris%' OR ACTORS LIKE '%Rosemary Harris%' OR DESCRIPTION LIKE '%Rosemary Harris%' OR VIDEOFORMAT LIKE '%Rosemary Harris%' OR FRAMERATE LIKE '%Rosemary Harris%' OR FILESIZE LIKE '%Rosemary Harris%' OR AUDIOFORMAT LIKE '%Rosemary Harris%' OR DATEADD LIKE '%Rosemary Harris%' OR MEDIA LIKE '%Rosemary Harris%' OR RESOLUTION LIKE '%Rosemary Harris%' OR LENGTH LIKE '%Rosemary Harris%' OR LANGUAGES LIKE '%Rosemary Harris%' OR SUBTITLES LIKE '%Rosemary Harris%' OR MEDIATYPE LIKE '%Rosemary Harris%') ORDER BY DATEADD DESC, ORIGINALTITLE ASC  LIMIT -24,24<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 '-24,24' at line 1