ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lovereading.Stock13' doesn't exist QUERY: SELECT b.Accolades, b.PrimaryGenre, b.SecondaryGenre, b.BookID, b.Chapter, b.Synopsis, b.Reviews, b.CustomLinks, b.SEOTitle, b.SEODescription, b.AppleISBN, b.ReaderReviews, b.HiResCover, b.Cover, b.SmallCover, b.Publisher, b.ColorTheme, b.FeatureColor, b.MonthEdition, b.AudiobookID, b.LROtherInfo, b.PrimaryGenre AS PrimaryGenreTextCode, bc.ISBN13, bc.Title, bc.PubDate, bc.Format, bc.Author AS BCAuthor, bc.Illustrator AS BCIllustrator, bc.NoPunctName, st.Qty, st.Rrp, st.Price, st.Availability, 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.isbn13, bi.title, bi.subtitle, bi.binding, bi.author, bi.illustrator, bi.description, bi.publisher, bi.thema AS PrimaryThemaTextCode, e.expertname, e.expertid, br.ShortReview AS LRCommentShort, br.FullReview AS LRComment FROM lovereading.KIDS_BookCacheNew bc LEFT JOIN lovereading.KIDS_Book b ON b.BookID = bc.BookID LEFT JOIN lovereading.KIDS_Author a ON b.AuthorID = a.AuthorID LEFT JOIN lovereading.KIDS_Illustrator i ON b.IllustratorID = i.IllustratorID LEFT JOIN lovereading.KIDS_Translator t ON b.TranslatorID = t.TranslatorID LEFT JOIN lovereading.BookIndex bi ON bc.ISBN13 = bi.isbn13 LEFT JOIN lovereading.Ebooks eb ON b.ISBN13 = eb.EAN LEFT JOIN lovereading.Stock13 st ON st.ISBN = bc.isbn13 LEFT JOIN lovereading.KIDS_BookReviews br ON b.ISBN13 = br.ISBN13 AND br.Enabled = 1 AND br.Approved = 1 LEFT JOIN lovereading.KIDS_Experts e ON e.expertid = br.ReviewerID LEFT JOIN lovereading.Stock13Ebook ste ON ste.eISBN = bc.ISBN13 WHERE bc.PubDate <= ? AND b.AuthorID=? AND bc.Format=? AND bc.Price >= ? AND bc.Price <= ? AND (PrimaryGenre=? OR SecondaryGenre LIKE ?) ORDER BY bc.PubDate DESC LIMIT 0,13
To mark the centenary of the end of World War One, 2018 we have gathered together a selection of books, fiction and non-fiction, new titles and old ones, for a wide range of ages, to reflect the tragedy of the First World War. We will refresh the list on a regular basis as new titles are published.