JavaScript seems to be disabled in your browser.

You must have JavaScript enabled in your browser to utilize the functionality of this website. Click here for instructions on enabling javascript in your browser.

Cookie Consent
This site uses session cookies to personalise your browsing experience and to provide a secure shopping environment. We also use Google Analytics tracking cookies to provide data for the analysis of site traffic. Please click on the Accept button to accept cookies from this site.

For full details of the cookies that we use and your options for managing or refusing cookies, please visit our Cookie Policy page.

1054 - Unknown column 'pd.products_illust' in 'field list'

select distinct p.products_image, pd.products_isbn, pd.products_master_isbn, pd.products_author2, pd.products_illust, pd.products_subtitle, pd.products_shortdesc, p.products_date_available, p.products_id, p.products_ebook, pd.products_format, pd.products_format_short, p.products_amazon_id, pd.products_name, pd.products_series, p.products_price as products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, round(p.products_price * s.specials_new_products_price, 2), round(p.products_price, 2)) as final_price from products p left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_imprint = 'lp' and p.products_status > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '73' or p2c.categories_id = '80' or p2c.categories_id = '104') and (pd.products_name like 'B%') order by pd.products_name, pd.products_subtitle, p.products_ebook, pd.products_format limit 0, 20