ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lovereading.Stock13' doesn't exist QUERY: SELECT bc.BookID, bc.ISBN13, bc.PubDate, bc.BookAuthString, bc.Author AS BCAuthor, bc.Illustrator AS BCIllustrator, bc.NoPunctName, bc.Themas AS ThemasString, bc.PrimaryThema AS PrimaryThemaTextCode, b.Enabled, b.Title, b.Chapter, b.Synopsis, b.Reviews, b.AudiobooksLink, b.CustomLinks, b.SEOTitle, b.SEODescription, b.AppleISBN, b.ReaderReviews, b.TotalVersions, bv.VersionID, bv.VersionTitle, bv.HiResCover, bv.Cover, bv.SmallCover, bv.Format, bv.VersionSynopsis, bv.Publisher, bv.ColorTheme, bv.FeatureColor, bv.AudiobookID, bv.MonthEdition, st.Qty, st.Rrp, st.Price, st.Availability, eb.EAN AS ebEAN, eb.Title AS ebTitle, eb.Author AS ebAuthor, eb.Description AS ebDescription, eb.Publisher AS ebPublisher, eb.ENotForSale, a.AuthorID, a.Fullname, a.Profile, i.IllustratorID, i.IFullname, i.IProfile, t.TranslatorID, t.TFullname, t.TProfile, bi.series_title, bi.pages, bi.bics, bi.book2look_url, bi.themas, bi.isbn13, bi.title, bi.subtitle, bi.binding, bi.author, bi.illustrator, bi.description, bi.publisher, e.expertname, e.expertid, br.ShortReview AS LRCommentShort, br.FullReview AS LRComment, st.Qty, st.Rrp, st.Price, st.Availability, ste.eRrp, ste.ePrice, ste.eActive, ste.eFormat, ste.eAvailability, ste.eISBN FROM BookCacheNew bc LEFT JOIN BookVersion bv ON bc.ISBN13 = bv.ISBN13 LEFT JOIN BookNew b ON b.BookID = bv.BookID LEFT JOIN Author a ON b.AuthorID = a.AuthorID LEFT JOIN Illustrator i ON b.IllustratorID = i.IllustratorID LEFT JOIN Translator t ON b.TranslatorID = t.TranslatorID LEFT JOIN BookIndex bi ON bc.ISBN13 = bi.isbn13 LEFT JOIN Ebooks eb ON bc.ISBN13 = eb.EAN LEFT JOIN Stock13 st ON st.ISBN = bc.ISBN13 LEFT JOIN BookReviews br ON bv.ISBN13 = br.ISBN13 AND br.Enabled = 1 AND br.Approved = 1 LEFT JOIN LR_Experts e ON e.expertid = br.ReviewerID LEFT JOIN Stock13Ebook ste ON ste.eISBN = bc.ISBN13 WHERE (eb.EAN != '' OR b.BookID != '' OR bi.isbn13 != '') AND bc.PubDate <= ? AND b.AuthorID=? AND bc.Price >= ? AND bc.Price <= ? AND bc.Themas LIKE ? AND (Featured = 1 OR st.Availability != 4 OR eAvailability = 7) ORDER BY bc.PubDate DESC LIMIT 0,13 Crime and Mystery Books and Book Reviews | LoveReading

10% off all books and free delivery over £40

Buy from our bookstore and 25% of the cover price will be given to a school of your choice to buy more books. *15% of eBooks.

Crime and Mystery

Enter the criminal underworld and solve a complex case all from the comfort of your favourite reading nook. Have a look at our Crime/Mystery selection to get your hands on the latest and greatest case and get mystery solving! You might also be interested in our Thriller and Suspense categories.

Sort:

Current Filters

John Connolly Over £20

Show Filters

Sorry, no books were found in this genre.