f_ReturnArrayOrdinal

SELECT Isbn,Item,Title,Author,Dept,BindingCode,BookCode,RetailPrice,UserInfo,ConditionCode,PubDate,PubCode,PubCode,Copyright,Edition,AvailableQty,WebCode,UsedMusicCode,LocatorCode,user2,sale_price,sale_start_date,sale_end_date,available_date,ProblemCode,Misc3,Misc4,first_received,dashless_isbn,tax_code FROM Weblist WHERE AND NOT (Weblist.BookCode LIKE 'M%' AND Weblist.AvailableQty = 0) AND AvailableQty > 0 ORDER BY Author,Title


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 NOT (Weblist.BookCode LIKE 'M%' AND Weblist.AvailableQty = 0) AND AvailableQ' at line 1