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 ') ORDER BY MessageNumber DESC, MediaType ASC' at line 1 SELECT ID,SubjectKeywords,MessageNumber,online,Type,Title,Speaker,MessageDate,Summary,MediaType,CD,DVD,Digitized,mp4,Youtube_HOW FROM messageinfo where MediaType in ('CD','DVD') and MessageNumber in (22,21,20,19,17,16,13,11,10,5,4,1,) ORDER BY MessageNumber DESC, MediaType ASC