ERROR: 42000: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 ') AND PHOTO_PRIORITY < 4 ORDER BY PHOTO_PRIORITY DESC' at line 5
SELECT PHOTO_HOTELCODE as hotelcode,PHOTO_NAME as photo
FROM tbl_photo
WHERE PHOTO_USER = '1'AND
PHOTO_SEASON IN ('4') AND
PHOTO_HOTELCODE IN () AND PHOTO_PRIORITY < 4 ORDER BY PHOTO_PRIORITY DESC
