SELECT * FROM `thebigwaf01`.`movies` WHERE DIRECTOR LIKE '%John Carpenter%' AND (ORIGINALTITLE LIKE '%Kit Ying Lam%' OR TRANSLATEDTITLE LIKE '%Kit Ying Lam%' OR DIRECTOR LIKE '%Kit Ying Lam%' OR PRODUCER LIKE '%Kit Ying Lam%' OR ACTORS LIKE '%Kit Ying Lam%' OR DESCRIPTION LIKE '%Kit Ying Lam%' OR VIDEOFORMAT LIKE '%Kit Ying Lam%' OR FRAMERATE LIKE '%Kit Ying Lam%' OR FILESIZE LIKE '%Kit Ying Lam%' OR AUDIOFORMAT LIKE '%Kit Ying Lam%' OR DATEADD LIKE '%Kit Ying Lam%' OR MEDIA LIKE '%Kit Ying Lam%' OR RESOLUTION LIKE '%Kit Ying Lam%' OR LENGTH LIKE '%Kit Ying Lam%' OR LANGUAGES LIKE '%Kit Ying Lam%' OR SUBTITLES LIKE '%Kit Ying Lam%' OR MEDIATYPE LIKE '%Kit Ying Lam%') 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