Author's Website: https://www.oliviacosneau.blogspot.co.uk
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, bi.cover_large, bi.cover_medium, bi.cover_small, 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 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.AuthorNpn=? ORDER BY pub_date DESC