Home » Catalogue » Antiquarian » Illustrated Books Basket Contents
Search Results
Displaying 81 to 100 (of 1070 books)
1030 - Got error 28 from storage engine

select pd.products_name, p.products_id, p.products_price, p.products_model, p.products_author, p.products_first_pub, p.products_tax_class_id, if(s.status, s.specials_new_products_price, null) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd join products p on pd.products_id = p.products_id join products_to_categories pc on p.products_id = pc.products_id left outer join specials s on p.products_id = s.products_id where p.deleted = 0 and p.products_quantity > 0 and p.products_status = 1 and pd.language_id = 1 and pc.categories_id = 22 group by pd.products_name, p.products_id, p.products_price, p.products_model, p.products_author, p.products_first_pub, p.products_tax_class_id, specials_new_products_price, final_price order by p.products_author, pd.products_name, p.products_price limit 80, 20

[TEP STOP]